How to Track the History of the changes in Oracle Apps Tables

How to Track the History of the changes in Oracle Apps Tables

In this post , We will be discuss about How to Track the History of the changes in Oracle Apps Tables. Some time , We need to keep track of the changes in the Most important function of the Oracle apps. For Example we want to keep history of the Oracle Sales Order Price List changes so that we can keep track , How many changes happened in the prices list and who made these changes so by that way we can keep track of the changes for the more sensitive information's in the oracle apps. Here we will be discuss about how to Track the History of the changes in Oracle Apps Tables.

 

 

 

How to Audit the changes in the Oracle Apps Tables

Step1:- Go to the System Administrator Responsibility

 

 

System Administrator ==> Profile ==>System

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

 

Step2:- 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'

 

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

 

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

 

Create the Audit Group for table 'QP_LIST_LINES'

 

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

 

 

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

 

 

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

 

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

 

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

 

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