How do I run a PeopleSoft Sysaudit report?
Audits the PeopleSoft Test Framework tests. To run SYSAUDIT: Select PeopleTools > Utilities > Audit > Perform System Audit. When prompted, enter a new run control ID and click OK.
What is SYSAUDIT in PeopleSoft?
The System Audit (SYSAUDIT) identifies orphaned PeopleSoft objects and other inconsistencies within the system. An example of an orphaned object is a module of PeopleCode that exists, but which does not relate to any other objects in the system. Audits PeopleSoft Application Engine program definitions and components.
What is ddd Audit?
DDD Audit is a SQR used to find the inconsistencies between the data structures defined in PeopleTools table against the underlying database.SYS Audit is an SQR used to compare the different people tools tables and find inconsistencies like orphaned objects ex.
What is Alter Audit in PeopleSoft?
Alter Audit is a process that identifies any records that require SQL Alter process. i.e. if the Data Designer definition doesn’t match Database definition. All records that are flagged should be Altered.
How do I run Dddaudit?
To run DDDAUDIT:
- Using Windows Explorer, navigate to PS_HOME\sqr and locate DDDAUDIT. SQR.
- Double-click it.
- Type in the database name, username, and password.
- Verify the Report arguments and click OK.
- At the Command Prompt, press ENTER.
How do I run an alter audit in PeopleSoft?
To run Alter Audit:
- Launch PeopleSoft PeopleTools and sign in to the Target database.
- From Application Designer, select File, New…
- Select Project, and then click OK.
- Select Insert, Definitions into Project…
- Select Records from the Definition Type drop-down list box.
- Select Table from the Type drop-down list box.
How do I run a PeopleSoft alter audit?
What is the purpose of sysaudit in PeopleSoft?
SYSAUDIT – The purpose of PeopleSoft’s System Audit (SYSAUDIT.SQR) is to identify “orphaned” PeopleSoft objects and other inconsistencies within your system. An example of an orphaned object would be a module of People Code that exists, but which does not relate to any other objects in the system.
What are the queries in PeopleSoft system audit?
This SQR consists of nine queries: four on tables, two on views, and three on indexes. SYSAUDIT – The purpose of PeopleSoft’s System Audit (SYSAUDIT.SQR) is to identify “orphaned” PeopleSoft objects and other inconsistencies within your system.
What are the dddaudit reports in PeopleSoft?
DDDAUDIT – The Database Audit Report (DDDAUDIT.SQR) finds inconsistencies between PeopleTools record and index definitions and the database objects. This SQR consists of nine queries: four on tables, two on views, and three on indexes.
What’s the purpose of SQL alter in PeopleSoft?
SQL Alter – The primary purpose of the Application Designer’s “SQL Alter” function is to bring SQL tables into accordance with PeopleTools record definitions. You can run SQL Alter in an “audit-only” mode that alerts you to discrepancies between your record definitions and SQL tables, but that doesn’t actually perform an alter.