DDD Audit ?
Finds Inconsistencies between People Tools record and Index definitions and the Database
objects.
This Audit consists of queries that checks tables, views, Indexes and Triggers.
DDDAudit.sqr is Located in PS_HOME/sqr
It will check the Integrity between System Catalog and People Tools tables.
Scenario:
We create an Object through Application Designer This Object Information is defined in
People Tools table but not present in the PeopleSoft Database.
This inconsistency will be reflected in DDDAudit report.
SYS Audit ?
System Audit Identifies Orphaned PeopleSoft Objects and Other Inconsistencies with in the
system.
Scenario:
An Orphaned object is a module of PeopleCode that exists, but which does not relate to any
other objects in the system.
Alter Audit ?
This report checks the difference between People Tools record Definitions (Front - End)
and RDBMS System Catalog definitions (Back - End).
Scenario:
If the Table has 5 records in People Tools records Definition and the same table has 3 records
in RDBMS System Catalog definitions then it will be reflected in Alter Audit reports.
No comments:
Post a Comment