To do this follow the 6 points

 

1)  Identify the tables and columns that need to be audited

2)  Create an audit group comprising the selected tables.

3)  Specify the columns to be audited from the tables in the audit group

4)  Specify the Oracle ID’s that need to be audited

5)  Run the audit trail update tables report program

6)  Develop the audit reports

Log into oracle application with system administrator responsibility

Navigate to  Security : AuditTrail →Tables

Make sure that you specify all the primary keys for the table

Navigate to  Security : AuditTrail →groups

 

Multiple tables can be given in one group of a same application

Navigate to  Security : AuditTrail →installations

Enable apps account here by clicking the tick mark.

 

From the concurrent request run the AuditTrial Update Tables report and check for the

tablename_A table thah would have been created (here tablename is the name of the table

that we selected in audit tables)

 

References : Metalink Document ID’s

i)  69660.1 : Understanding Data Auditing in Oracle Apps Tables

ii)  413847.1: How to remove a table from an audit group

iii) 73408.1: How to truncate,delete or purge rows from the audil trail table

Share →
Skip to toolbar