Recently Updated Pages
Web Server URI
If you need to retrieve the web server URI for rending images in HTML emails try this method Get...
SQR SQL Trace
To trace the status of cursors being executed, append the -S flag to your parameter list. You can...
Stringing Text in SQR
You can use the commands string, by, and into in SQR to string together text by a particular char...
Conditional Counting In SQL
If you ever want to conditionally count the number of times a particular condition occurs in SQL,...
Enumerate Rows in SQL
The following SQL is an example of how to enumerate (number) rows in SQL. This SQL will only work...
Page Data is Inconsistent with Database
During development you may come across the following error: Page data is inconsistent with datab...
Case When Exists SQL
The Case-When-Exists expression in Oracle is really handy. Here's an example of how to use it in ...
Roles
Roles are used by PeopleSoft to implement security. A role is way of grouping one or more Permis...
Get roles and permissions for a particular user
The following query will return the roles and permission lists that a particular user belongs to....
Configuration Manager
Configuration manager is a PeopleSoft Windows based application for configuring connecting settin...
Last Refresh of Environment
Sometimes you'll need to known when an environment was last refreshed and may not have the detail...
Custom Sorting with Decode
When trying to sort based on values that do not fit the standard ascending and descending sort lo...
SQL Account Is Locked ORA-28000
If you ever get the following message: SQL Access Manager SQL error. Stmt #: 2 Error Position: ...
PeopleCode Statement Number
Most errors and logs will point you to a particular PeopleCode statement number. But how do you f...
Could Not Create Shared Cache
One of the causes of the error Could not create shared cache. (0,0) on the signon screen is if th...
Web Service Target Locations
Web Service Target Locations are defined under: PeopleTools > Integration Broker > Configu...
Preview HTML in Message Catalog
The spell check functionality in the message catalog actually lets you preview HTML. For example ...
Scheduled Jobset going to Completed
If you have a scheduled jobset that is going to completed, then it could be because there is a re...
UserName not defined in database
If you get this message with the web services listening connectors e.g. SOAP or REST: UserName n...
Generate Oracle Public Synonyms
The following SQL can be used to generate a script to create public synonyms (in Oracle). This ex...