Audit logging for a particular table can be set up using the Setup Audit Log and External Notification page (AUDCTRL).
To enable audit logging on a table, the following information can be set up on this page:
Resource Name – Enter the table name for which activity is being monitored. Note: The system will infer the Process Type as Tables.
Audit Enabled – Select the check box if audit logging needs to be turned on for the particular table; otherwise, leave the check box unselected.
The rest of the fields are only relevant to external notification setup.
To enable external notification on a table or on a transaction, the following information can be set up on this page:
Resource Name – Enter the table name for which events will be logged for external notification. If external notification is desired on a transaction then enter the Transaction Code in the Resource Name field. Depending upon the Resource entered, the system will infer the Process Type as Tables or Transactions. Note: Resource Name is case-sensitive.
External Notification – Select the check box if external notification needs to be turned on for the particular resource (table or transaction); otherwise, leave the check box unselected. Refer to the “Enable Audit Logging of IN_OBJ_ATT_STOR table” topic in the System Administration Guide for more information about this check box.
The following setup is relevant for setting up external notification for transactions only and does not apply to tables:
If transactions belonging to a particular Department are to be selected for external notifications then enter that Department in the Transaction Department field; otherwise, leave Transaction Department blank to indicate transactions of any Department. The System will infer Transaction Action Code as Submit since logging of external notification is only done for the transaction action of Submit.
Select the target Transaction phases (Draft, Pending and/or Final) for which external notifications needs to be enabled.
Note: It is possible to turn both Audit logging and External Notification on for a table.
For any changes on this page to take effect, the application server should be shut down and then restarted.