PeopleSoft Admin Realtime Interview Questions

DDDAudit, SYSAudit, AlterAudit




           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