Setting up AuditTrail is usually a task for the system administrator.

The first six steps are required to enable auditing of any Oracle Applications table. They are explained in more detail in the Oracle Applications System Administrator's Guide. The final step is required only for tables in the HR application.

   To set up AuditTrail:

1. Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally this step will already have been done as part of your installation or upgrade.

   Using a System Administrator responsibility:

2. In the System Profile Values window, set the AuditTrail:Activate profile option to Yes at Site or Application level.

3. In the Audit Installations window, query the application(s) you want to audit, and check the Audit Enabled box next to the Oracle User Name.

4. In the Audit Groups window, query the application and enter a name for the audit group, then select the tables you want to audit (using the User Table name). For a new audit group, select Enable Requested in the Group State field.

5. In the Audit Tables window, query each table you want to audit, and select which columns in these tables you want to audit.

   Note: You cannot audit LONG, RAW, or LONG RAW columns.

6. In the Submit Request window, run the AuditTrail Update Tables process. 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

   Using an HR Manager responsibility:

7. In the Submit Request window, run the AuditTrail Update Datetracked Tables process. For each datetracked table, this process:

   • Creates an index on the shadow table

   • Creates the function tablename_TT and the procedure tablename_VP, which extracts information from the shadow table when you run the predefined audit report

   Attention: You must rerun the AuditTrail Update Tables process and the AuditTrail Update Datetracked Tables process if you make any changes in the Audit Groups or Audit Tables windows.