PeopleSoft stores all of its information/code in database tables. Each of the definitions that you can open in Application Designer can be found in one or more tables in the database. Knowing these tables can be helpful:
SQL Definitions
Object Type (11/15/2006)
Work in Progress…
The following lists the PeopleSoft tables that store SQL Definitions:
PSSQLDEFN
Noteworthy Fields
SQLID — Name of SQL Definition
SQLType — 0, 1, or 2
SQLText — Clob field that stores the text of the SQL Definition
PeopleTools Tip: Bypassing App Designer Login
Application Designer has command line options that allow you to specify the login information. This would allow you to create a shortcut on the desktop or in the Start Menu that automatically logs into an instance of PeopleSoft.
Just copy your shortcut to App Designer, and change the command line to look something like this:
Options:
PS Home – you shouldn’t have to change this if you copy a shortcut that already works
Database Type — ORACLE for an Oracle database
Server/Database Name — The name of the database or instance of PeopleSoft
Database Name – Same as the Server/Database Name
Username — The username you want to login with
Password — The password for that username
Security Warning –
You may want to limit this to Demo instances where no sensitive data exists. You are leaving your password available in plain text and bypassing security. If someone gains access to your computer they have your password and the ability to log into the PeopleSoft system with your security.
Tip — PeopleTools: Tablespaces
What happens when you decide to create a new record and PeopleSoft asks you which tablespace to use, but the tablespace you want is not in the list?
Solution: Insert a Row into the PeopleTools System Catalog table.
As far as I know, PeopleSoft offers no other way of adding tablespaces as options.
Insert Statement:
INSERT INTO PSTBLSPCCAT (DDLSPACENAME, DBNAME, TSTYPE, DBXTSTYPE, COMMENTS) VALUES (’TABLESPACE_NAME’, ‘ ‘, ‘R’, ‘DMS’, ‘Your Comments’);
More Information on Tablespaces
PeopleTools tables: PSTBLSPCCAT
http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplesoft-fi-l/creating-new-tablespace-in-ps84-489136#
Tip — Other Tools: Toad Installation Issue
Just recently, we installed the free version of Toad on a development VMWare server. After logging in, we received two error messages:
Access violation at address 00000000. Write of address 00000000.
and
Error loading SPServer.
I found the fix for these error messages at:
http://www.nabble.com/Error-loading-SPServer-t995120.html
Basically, you must turn off Data Execution Prevention for Toad.
