Sometimes you want to create a view in PeopleSoft which is based on another view.
Example:
View 1 (named PS_LOCKED_USR_VW) is defined as follows:
SELECT OPRID FROM PSOPRDEFN WHERE ACCTLOCK = 1;
View 2 (named PS_GET_LOCKED_NAME_VW) is defined as follows:
SELECT A.NAME FROM PS_PERSON_NAME A, PS_LOCKED_USR_VW B WHERE A.EMPLID = B.EMPLID;
When creating views using the createvw.dms script (or the REPLACE_VIEW […]

• 1 Comment

Running the DDDAUDIT.SQR process is something every PeopleSoft administrator should do on a regular basis, because it detects flaws between objects in the database and the corresponding definitions in the PeopleSoft data dictionary.
In normal maintenance life however this process doesn’t run that often, so the output can be quite large. Also, when running a DDDAudit […]

• 0 Comments