Setting Up AuditTrail
Setting up AuditTrail is normally a task for the system administrator.
The first four steps must be done to enable auditing of any Oracle Applications table. They are explained in more detail in the Oracle Applications System Administrator's Guide. The fifth step is required only for tables in the HR account.
To set up AuditTrail:
1. Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally this step would already have been done as part of your installation or upgrade.
2. Select the tables you want to audit in the Audit Groups window, and select which columns in these tables you want to audit in the Audit Tables window.
Note: You cannot audit LONG, RAW, or LONG RAW columns.
3. Select the registered ORACLE IDs you want to audit in the Audit Installations window.
4. Run the Audit Trail Update Tables process. You do this in the Submit Requests window for a System Administrator responsibility. This process:
- creates database triggers on your audited tables
- creates one shadow table for each audited table, to contain the audit information
- builds special views on non-datetracked tables, which you can use to retrieve your audit data for reporting
5. Run the Audit Trail Update Datetracked Tables process. You do this in the Submit Requests window for an HRMS responsibility. For each datetracked table, this process:
- creates an index on the shadow table
- creates the function <tablesname>_TT and the procedure <tablename>_VP, which extracts information from the shadow table when you run the predefined audit report
Attention: You must rerun these processes any time you update any of your audit definitions.
Disabling AuditTrail
You can disable the auditing of an audit group at any time by selecting a Disable state in the Audit Groups window.
Suggestion: If you are planning high volume transactions on an audited table, such as loading a batch of information from another system, consider disabling auditing for the table's audit group. This will enable the batch loading to complete more quickly.
Before you restart auditing, you should archive your audit data, according to your business needs, and purge the shadow tables. You purge the tables by setting the audit group to Disable - Purge Table and running the Audit Trail Update Tables report. To restart auditing, you set the audit group to Enable Requested and rerun the Audit Trail Update Tables process and the Audit Trail Update Datetracked Tables process.
See Also
Setting Up Release 10 AuditTrail
Oracle Applications System Administrator's Guide
Disabling AuditTrail and Archiving Audit Data
Oracle Applications System Administrator's Guide
Reporting on Audit Information
