Recently Updated Pages
Check Process Override Options
This SQL checks all process definitions where the parameter list, command line or working directo...
Record Naming Conventions
This is the naming convention (prefixes/suffixes) recommeded by PeopleSoft in PeopleBooks for Rec...
Oracle Dynamic Performance Views
Oracle dynamic performance views (v$) are built on the virtual tables ($x). The views (v$) are mu...
Oracle Data Dictionary
There's a view of all the data dictionary views in oracle called DICTIONARY. So you can query it ...
Retain Temp Table Data
If you've ever worked on a complicated app engine program that uses temp tables, then you'll know...
Dynamic Roles
Roles (and permission lists) can be assigned to users dynamically in PeopleSoft using dynamic rol...
Embedded SQL in PeopleSoft Query
Turns out that you can embed SQL into your PeopleSoft Query using the Meta-SQL operator, %Sql. He...
Managing PS Queries
There is a way to delete and rename queries as well as to change them from private to public quer...
Find Custom PeopleSoft Queries
The following SQL identifies custom queries created in your system from the PSQRYDEFN PeopleTools...
Query Statistics
PeopleSoft provides the ability to track query statistics for PeopleSoft Queries such as the numb...
Reauthenication Required to View Reports
I came across a scenario where the user would need to re-authenticate with PeopleSoft in order t...
LogParser
LogParser is a command line driven tool from Microsoft for parsing web server log files. However,...
The Structure of PS_HOME
Here's an overview of the structure of the PS_HOME directory on a typical PeopleSoft file server....
Copying Rowsets
I find that you often need to create and manipulate standalone rowsets. Sometimes you can get the...
PeopleSoft Keyboard Shortcuts
Hot keys perform immediate actions. When you press one, the designated action occurs. Note that s...
PSHttpFactory init or setCertificate fails
During IB configuration while loading gateway connectors the following error messages kept appear...
Letter Printed Data
Letter printed data is an option that you can set for standard letters configuration in PeopleSof...
Output to the Report Repository
If you are developing a new SQR that creates files that need to be posted from the process schedu...
Clear PeopleTools Cache
The PeopleTools cache refers to the local cache on your PC for any PeopleTools programs that you ...
Template File Missing
The following SQL links together the XML publisher Report Definition, Data Source, Template, and ...