Enable Audit Trail for GL_PERIOD_STATUS

Enable Audit Trail

1        Enable system profile option “Audit Trail:Active=yes”

2        Need to define audit trail group

Navigation: Security -> AuditTrail -> Groups       

3        Now define audit installations:

Navigation: Security -> AuditTrail -> Install

GL oracle username already audit enabled.

4        Navigation: Security -> AuditTrail ->Table

Query for GL_PERIOD_STATUS table

5        Run Concurrent program 'AuditTrail Report for Audit Group Validation' with parameter as that of Audit Group

   Audit Group Name is Accounting Period

Select “Accounting Period”

6        Run concurrent program "AuditTrail Update Tables".

7        Define Template ,Go to Audit Trail-Audit Trail Reporting-Audit Industry Template

8        Run Audit Report, Go to Security-Audit Trail-Audi Trail Reporting-Audit Report and update Parameter values then run the report.

http://allappsdba.blogspot.in/