Run the Audit Trail Update Tables Concurrent Program

After you have defined CDR as the audit installation, run the Audit Trail Concurrent Program to enable auditing.

1. From the View menu, select Requests. The Find Requests pop-up appears.

2. Click Submit a New Request. The Submit a New Request pop-up appears.

3. Select Single Request and click OK.

4. From the Name drop-down list, select AuditTrail Update Tables and click OK. The system returns you to the Submit Request window with AuditTrail Update Tables displayed in the Name field.

5. Click Submit. A windows pops up if you want to proceed with the request submission or change the default request parameter value.

6. Click OK. A window pops up with the Request ID and asks if you want to submit another request.

7. Make a note of the Request ID and click No.

Monitor the Job: To monitor the job's progress:

1. Click Find and use the Request ID to search for the job.
2. Click Refresh Data periodically to update the execution phase and status of the job displayed on screen.
3. When the phase is Complete, click the View Log. Always check the log file.

   The log file contains a record of queries to update the FND tables, creating shadow tables, giving grants, creating triggers and procedures. At the end it should say: Concurrent Request completed successfully or, if the job did not complete successfully, an error message giving the reason for the failure.