One PeopleSoft Audit for multiple tables

I am posting this article for our benefit that I got to see on PeopleSoft Audit. This talks of how a single audit record can be used to audit multiple PeopleSoft records.

The easiest way to create an audit record is to open the record definition of the base record that you wish to audit. Remove the all edit and key attributes from the newly saved audit record. Also remove any attributes such as PARENT records, Query Security Records, and PeopleCode must be removed for the audit record. The audit record must be saved with the prefix AUDIT_.

To the top of this new audit record the following key fields have to be added in the same order and they should also be made as key fields.


  • AUDIT_OPRID

  • AUDIT_STAMP

  • AUDIT_ACTN

  • AUDIT_RECNAME**

In most cases we include only AUDIT_OPRID, AUDIT_STAMP, and AUDIT_ACTN. The AUDIT_STAMP must be given the attribute AUTOUPDATE attribute must be checked for the field AUDIT_STAMP. AUDIT_STAMP field must also be made a descending key field.


  • AUDIT_OPRID - Identifies the user who caused the system to trigger the audits

  • AUDIT_STAMP -Identifies the date and time the audit was triggered 

  • AUDIT_ACTN - Indicates the type of action that the system audited.

Possible audit actions include:


  • A: Row inserted. 

  • D: Row deleted.

  • C: Row changed (updated), but no key fields changed. The system writes old values to the audit table.

  • K: Row changed (updated), and at least one key field changed. The system writes old values to the audit table.

  • N: Row changed (updated), and at least one key field changed. The system writes new values to the audit table.

  • ** - AUDIT_RECNAME must be added only if the audit table needs to audit more than one record definition.

 The audit table need not have to include all the columns of the base table. In fact, for performance reasons, it’s best to only to include those fields in the audit record that are deemed to be changed.

In the record to be audited go to Record Properties -> Record Audit, specify the below options:


  • Record Name – Specify the user-defined audit record.

  • Specify the required Audit Options – following are the audit options to choose for auditing the record.

  • Add - Inserts an audit table row whenever a new row is added to the table underlying this record definition.

  • Change - Inserts one or two audit table rows whenever a row is changed on the table underlying this record definition.

  • Selective - Inserts one or two audit table rows whenever a field that is also included in the record definition for the audit table is changed.

  • Delete - Inserts an audit table row whenever a row is deleted from the table underlying this record definition.

Everytime the record is being inserted, deleted, updated a corresponding row gets inserted in the audit table as per the options specified.

Comments:

very nice and the Content is very good and informative as well. Thank you. I want you to be successful in Your future career.......!!!

Posted by android blackjack on January 23, 2012 at 12:30 PM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mohit Satraj Phogat
Author: Mohit Phogat

This site focuses on Oracle's offerings to higher education in the Indian region. It intends to cover news, reviews, guides, how-to articles, descriptive videos, and podcasts on the trends which should be helpful to customers, prospects and developer community alike.

Follow me @

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today