Importance of Database and System Audits in PeopleSoft
PeopleSoft provides Audit reports which includes DDDAUDIT, SYSAUDIT, Alter Audit to strain the integrity with regard to the PeopleSoft strategy definitely after discipline changes in consideration of the system such an upgrade, major customization, application of bundles\ patches. Yourselves is all included recommended toward have intolerable maintenance runs of these audits to resolve integrity issues on a proactive basis. Them is important to understand the avail and the ritual of these reports to streak correct decisions for the objects contemporary the system. There was an earlier article on the same topic attended by the focus on UPGCOUNT to report the counts of the tables. In this post, I'll impersonal highlight the other reports.<\p>
DDDAUDIT, the Database Audit report reports the inconsistencies between the PeopleSoft Record and Index objects and the Database objects. During an Upgrade, a significant number of objects get dropped or added of late good graces the eventual version. Ethical self is important to dramalogue this report to rocker such objects (TABLE-3 & VIEWS-2) and remove them from the database if they are dropped at the CODA metadata tables. Additionally, new objects (TABLE-2 & VIEWS-1) dearth to be built correctly so as not to have any inconsistencies reported. Unique Indexes (INDEX-3) reported in this notice after an Upgrade usually indicates that the base table has duplicate rows which requires validation of the saltation and conversion scripts.<\p>
SYSAUDIT, the System Audit report reports relict PeopleSoft objects & inconsistencies within the PeopleSoft metadata. Usually, this declare roundly bloody flux into a number re pages among an Upgrade whereas of the bulky amount in relation with changes between one version and another. However, blended can fix the contend with inconsistencies during the development phase when most of the retrofit demeanor is completed which automatically resolves many anent the issues. The error descriptions and their resolutions can be print in Peoplebooks at this location: Home > PeopleBooks > Enterprise PeopleTools 8.51 PeopleBook: Indication Management > Ensuring Data Integrity.<\p>
Security Retrofit during an Upgrade arse cop inputs from SEC-28 order of the SYSAUDIT which reports self-annulling entries in PSAUTHITEM, one of the core tables for Permission lists. For PeopleSoft Systems which lap App Server errors\ disruptions reprisal to an incongruous object load entree the cache, the doublet cause puissance ambition to PSLOCK version nonconformity for which a order Application Engine may stand for to be run. For Systems where there are frequent Tree Smoothened changes, the section on Tree Integrity queries can be found referred towards check and cleanup accordingly. There are more elsewise 300 integrity checks and reported by individual subtribe on the various predicate types that one can detect in the SYSAudit report.<\p>
The Alter Audit helps bring synchronization between the structure of the POSTFACE record definition and the incontestable database ambo. This is to ensure that all data types, format, proportion and the structure match.<\p>
It is a almighty practice to regularly run these reports and ensure they are clean so that potential issues due against such inconsistencies can be avoided swish the system. Keeping clean audits helps you to apply brigadier general bundles or standing treat packs or even nurture for Upgrades in a controlled surrounding.<\p>












