Recently Updated Pages
COBOL SQL Trace
This article explains how to enable a COBOL SQL trace on a COBOL process definition. First, dete...
Welcome
Welcome to the PeopleSoft Wiki! I started this wiki way back in 2007 as a place to collect and ma...
Multilevel Rowsets
A multi-level rowset is one that has a parent-child-grandchild relationship structure. Such rowse...
What is Audited?
When there's an issue, a frequent question that comes up is: what is being audited? This is close...
Writing Meta-SQL
Meta-SQL is a great way to abstract SQL logic and ensure consistency in your SQL definitions. It ...
Project has been updated by another user
If you are migrating projects between environments and you have modified the project in the targe...
Validating a Project
The validate project command in Application Designer is very important for ensuring that your pro...
Copying Projects
Copying to a File Before copying any project to file, make sure you have verified the following:...
Project Verification Checklist
This article provides a check list of steps you might want to perform for your application design...
Site Booted With Internal Default Settings
If the following error message appears on the login page: CHECK APPSERVER LOGS. THE SITE BOOTED ...
Encryption
The following functions are provided as built-in functions in PeopleCode for encryption/decryptio...
Tips for Creating Views
Generally you should try to re-use views whenever possible and PeopleSoft has literally thousands...
Reusing Views
PeopleSoft has thousands of views! If you want to know just how many there are, try this query to...
Migrating Web Services
Once you've developed a component interface based web service, how do you migrate it between envi...
Error Code 5528
(SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 11: ORA-00933: SQL command not properly en...
Error Code 5400
(SQR 5400) Second page write attempted while writing current page. Check BEFORE-PAGE, AFTER-PAGE...
Error Code 4713
(SQR 4713) Cannot open the #INCLUDE file: 'setenv.sqc' (2): No such file or directory SQR for...
Error Code 3719
(SQR 3719) Columns names and expressions must be unique or be given unique pseudonyms (&name)...
Error Code 2904
(SQR 2904) File number already opened. This indicates that the file number you used for refere...
Manage Users with a Component Interface
Sometimes, you might need to work on a PeopleSoft instance that doesn't have a PIA. While you can...