Use the Audit Requirements window to select the tables that you want to audit. You can audit every change made to a database table or audit only changes made to specific columns of a table. You can change what you want to audit at any time. Typically, only the database administrator can access this window.
Note: Treasury requires more disk space if you choose this option. The exact amount of disk space depends on the volume of transactions that your company processes. Please consult your Database Administrator if you plan to use this option.
You can also group your treasury events into a single audit report for your company through the Audit Group window. For more information on creating an audit group, see: Creating Audit Groups.
This audit setup is an internal Treasury audit only. It is separate from the Oracle database audit.
For more information on any table see Oracle Treasury Technical Reference Manual.
Use the Audit Requirements window to set up your audit requirements.
In the Audit Requirements window, select the Audit check box beside each table that you want to audit.
Note: You can select or deselect the Audit check box at any time and change your view of your audit data. Treasury collects audit data for all of your tables, but it displays data only for the columns that have the Audit check box selected. If the Audit check box on the Audit Requirements window is selected for the table, then you can query any column at any time.
If you want to group several treasury audit events into an audit report, choose the Audit Group button. For more information, see: Creating Audit Groups.
If you want to query a specific column in a table, select the table and choose the Audit Columns button. The Audit Columns window appears. Select the Audit check box next to any columns against which you want to perform queries.
Save your work.