PeopleSoft
- Change PTWEBSERVER Password
When creating a new PeopleSoft webserver domain, PTWEBSERVER is the user id set by default. In order to avoid issues this id should only be used for the webserver domain configuration. If the password for this user id gets changed it may cause the webserver to not boot up. If the PTWEBSERVER password ever needs to be changed, follow the below steps:
Change the online password for PTWEBSERVER:
This can be done by navigating to
- PeopleTools Object Version Tables
PeopleTools Object Versions
Record Description PSLOCK This table is used for version control PSOPTIONS This table is used to turn the change control enabling feature on or off. PSVERSION This table holds the version number details - PeopleTools Process Scheduler Tables
PeopleTools Process Type Details
Record Description PS_PRCSDEFN Contains process type and process names PSPRCSLOCK Contains a single record, this gets updated when a process is submitted PeopleTools Process Status
Record Description PSPRCSQUE Holds the process request details and should be in sync with PSPRCSRQST. PSPRCSRQST This table holds the process submitted details PS_CDM_LIST Contains the process instance details. Should be in sync with PS_CDM_AUTH PS_CDM_AUTH Contains the process instance details PeopleTools Report Node Details
Record Description PS_CDM_DIST_NODE This table holds the report node information which contains the report repository details PS_CDM_DISTSTATUS Contains the definition of report status PeopleTools Batch Server Details
Record Description PS_SERVERDEFN Contains the server definitions PSSERVERSTAT Gives information about the batch server status - PeopleTools Security Tables
Security is a very important part of any PeopleSoft application. It determines what pages users can see all the way down to which rows. It may seem overwhelming at first but don’t worry; it’s pretty straightforward once you learn all the pieces and how they’re connected.
Below you will find a list of the Main PeopleTools Security Records along with a brief summary of their purpose. Knowing these tables can prove useful to quickly troubleshoot, determine which users have what security or even to audit user security regularly.
- PeopleTools Update User Password DataMover
Useful for when the main user id gets locked out. First log into Datamover in bootstrap mode. Then using the script below update the users password.
Note: the script will vary depending on the peopletools version. I forget what the version is exactly, 8.54 I believe.
For earlier versions of PeopleTools:
update PSOPRDEFN set OPERPSWD = 'password', ENCRYPTED = 0 where OPRID = 'OPRID'; -- to encrypt the password encrypt_password OPRID;For later versions of PeopleTools
update PSOPRDEFN set OPERPSWD = ' ', PTOPERPSWDV2 = 'password', ENCRYPTED = 0 where OPRID = 'OPRID'; -- to encrypt the password encrypt_password OPRID; - PeopleTools Version Details Tables
PeopleTools Version Details
Record Description PSRELEASE This table holds the application release details PSSTATUS This table gives the peopletools information - Start Data Mover Bootstrap Mode
If the PS password has been lost or otherwise hosed, use bootstrap mode to make things right again.
In order to start Datamover in bootstrap mode, use the system access ID and access password. For example by default it’s SYSADM.
Learn how to update a user password including the PS password if needed.
- User Security Join Table (SJT) Jobs
All of the SJT (Security Join Tables) jobs that that joins security information from other tables in the database into a temporary table on the application server for use in business rules.
SJT_OPR_CLS: Contains the User IDs with their data permission lists.
SJT_CLASS_ALL: Contains the data permission information for all the data permission lists that are given data access on the ‘Security by Dept Tree’ page or ‘Security by Permission List’ page.