How to disable audit trail in E Business suite R12.2

 

How to disable audit trail in E Business suite R12.2

There could a situation where you want to stop auditing, then you must set the audit group state to either “Disable-prepare for archive” or
“Disable-Interrupt Audit” and run the “AuditTrail Update Tables” report.

1. Disable Prepare for Archive

Copies the current value of all rows in the audited table into the shadow table and then disables the auditing triggers. There is no
longer any recording of any changes. The shadow table should be archived at this point.

2. Disable Interrupt Audit

Modifies the triggers to store one "final" row in the shadow table for each row that is modified in the audit table. There is no
longer any recording of any changes.

3. Disable Purge Table

Drops the auditing triggers and views and deletes all data from the shadow table.

These options are available from the "Define Audit Groups" form. Login as the System Administrator User Responsibility: Navigate AuditTrail Groups

Select one of the above options contained in the "State" field to disable auditing. Then run the Audit Trial Update Tables report.