How to enable audit in oracle apps r12 : Oracle r12 audit tables

How to enable audit in oracle apps r12 : Oracle r12 audit tables

In this post , We will be discuss about How to enable audit in oracle apps r12. Audit is the very important feature of the oracle apps. We can track the last changes in the Oracle apps records but what about second last change so well there is no track of this. So to see all the changes happened for the table we can use the Audit feature of the oracle apps. We can audit some of the sensitive tables in oracle apps r12 using audit trail functionality. We don't need to audit the complete table. We can audit the Complete or we can audit some of the columns in the table and Audit report will give us all the details regarding any changes in this table for that audit columns. Here below I will share how to enable audit in oracle apps r12.

 

 

 

Steps to Enable audit in oracle apps r12

 

Step1:- First we need to identify which table we want to audit and which column of this table. Then need to identify the Module of the Audit table to which that Table belongs.

 

Step2:-Go to the System Administrator Responsibility

 

System Administrator ==> Profile ==>System

Find the Profile 'AuditTrail:Activate' and set this to Yes at Site Level.

 

Step3:- Now we need to set the Audit on the Table and the column to which we want to keep track.

 

System Administrator ==> Security ==>AuditTrail ==>Install

 

Select the Module to which we want to Install the Audit Trail.

 

System Administrator ==> Security ==>AuditTrail ==>Tables

 

Select the Table 'QP_LIST_LINES' and the column 'OPERAND'

 

Step4:- Now we need to create the Table Audit Group.

 

System Administrator ==> Security ==>AuditTrail ==>Groups

 

Create the Audit Group for table 'QP_LIST_LINES'

 

Step5:- Now we will run the concurrent Program in System Administrator responsibility "AuditTrail report for Audit Group Validation

 

 

Step6:- Now we need to create the Audit Trail Templates

 

 

System Administrator ==> Security ==>AuditTrail Reporting ==> Audit Industry Template

 

Step7:- Now we will run the concurrent Program in System Administrator responsibility "AuditTrail Update Tables'

 

Step8:- At the End we need to run the Audit report  as below

 

System Administrator ==> Security ==>AuditTrail Reporting ==> Audit Report