Configuring a Table for Auditing
Enter P9500003 in the Fast Path, or enter GH9091 and
then select the Audit Table Configuration menu.
On the Work with Audit Table Configuration form, click Add.
On the Audit Table Setup Director, click Next.
On the JD Edwards EnterpriseOne Table Selection form, in the Table Name field, enter the name of the table that you want to audit, and then click Next.
Alternatively, you can click the Find button and select a table from the list.
Note: If a table was previously configured for audit, it cannot be selected.On the Audit Table Information form, if necessary, make changes to the default values, and then click Next.
This action launches TDA in audit mode, which creates audit table specifications locally and adds the audit table to your default project in OMW.
By default, the Primary Key columns from the original table are populated along with eight more columns, which are mandatory for the audit table.
In the Auditable Columns area, select the columns that you want to trigger an audit and move them to the Columns area. You can append new columns to the end of the audit table, but they cannot be inserted between existing columns or reordered.
In the Auditable Columns area, select any additional columns that you want recorded in the audit table and move them to the Columns area. Right-click the column and then select Audit Trigger Column.
This action removes the check mark from this option so that the column will not trigger an audit. Instead, this column will be recorded along with the other columns in the audit table when an audit is triggered.
Click Save and then close TDA after all columns have been selected for auditing.
On the Work with Audit Table Configurations form, click End.
Restart all servers and clients.