Enable Audit Trail and Resolve Fatal error Issue in R12

Enable Audit Trail in R12

Responsibility Needed - System Administrator

1. Define audit Group

Navigation - Security->Audit Trail->Groups

Enter Application Name and Tables What need to be Audit and Save the change

Note: When you first create the audit group the group status will be 'Enable Requested' this will automatically be changed to 'Enabled' once the AuditTrail Update Tables concurrent request is run (Step 5)


2. Define Which columns to be audited

Navigation - Security->Audit Trail->Tables

3. Enable auditing for schema owners

Navigation - Security->Audit Trail->Install

4. Enable ‘AuditTrail Activate’ profile option

5. Submit the 'AuditTrail Update Tables' concurrent request

Solution for AuditTrail Update Tables program error on R12

   While running AuditTrail Update Tables concurrent request It's completed with Error.

  To fix the issue Check if you have enabled auditing for APPLSYS,APPS and the application schema owner you want to audit, if not enable the auditing for the schema you wish to audit.

   Then change the group statue for the Audit Group AP_SYSTEM_PARAMETERS_ALL to disable – purge table and run the concurrent request 'AuditTrail Update Tables'  again.