Previous | Next | Contents | Index | Navigation | Glossary | Library |
First identify the tables you want to audit, then, using the Audit Tables window, select which columns in each table you wish to audit. Or, select which columns in a particular table you wish to audit (using the Audit Tables window), then define your audit group (using this window).
To enable or disable auditing for the tables in your audit group, run the Audit Trail Update Tables program using the Submit Requests window. If you change the definition or audit state of your group later, you must rerun this program.
Attention: Your tables and their primary key information must already be registered and defined for successful auditing. If the table you want to audit is a custom table (not shipped as part of Oracle Applications), you should also perform the following two steps:
Application Name
Select the name of an application to associate with your audit group. The combination of application name and group name uniquely identifies your audit group. An audit group may be used to audit tables in additional applications.
Disable - Prepare for Archive | Copies the current values of all rows in the audited table into the shadow table, and then disables the auditing triggers. This option requires the most space, since there is at least one row in the shadow table for every row in the audited table (and another row in the shadow table for each transaction on the original row in the audited table). You should then archive the table before you empty the shadow table. |
Disable - Interrupt Audit | Modifies the triggers to store one final row in the shadow table as the audited row is modified in the audit table (remember that a given row in the shadow table represents the data in the audited row before an update). Inserts or further changes are no longer audited. The shadow table then grows slowly, and the data may be accessed by the existing audit views. |
Disable - Purge Table | Drops the auditing triggers and views and deletes all data from the shadow table. |
User Table
Select the end user table name (frequently the same name as the table name) for your database table. Once you choose a table, you see its table name and associated application.
Table Name
This field displays the actual name for the table you have selected to include in your audit group.
Application
This field displays the application name for the table you have selected to include in your audit group.
Description
This field displays the description for the table you have selected to include in your audit group.
Setting Up Release 11 AuditTrail
Release 10.4 AuditTrail Tables, Triggers and Views
Reporting on Release 11 Audit Information
Disabling AuditTrail and Archiving Audit Data
Previous | Next | Contents | Index | Navigation | Glossary | Library |