Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Thursday, November 17, 2011

[SYS] R12: Enable Audit Trail


Step to enable AuditTrail:

(1) AuditTrail->Install
ONT Oracle Order Management Account

(2) AuditTrail->Groups
Application Name: Order Management
Audit Group: XX_ABC_GROUP
Group State: Enabled
...
User Table Name: OE_ORDER_LINES_ALL

(3) AuditTrail->Tables
User Table Name: OE_ORDER_LINES_ALL
Table Name: OE_ORDER_LINES_ALL
Application: Order Management
Column: UNIT_SELLING_PRICE, etc

After completed above steps, run "AuditTrail Update Tables". It will then add additional columns into the table and create a new trigger on it.

Schedule "Audit History Consolidator" to collect the audit data.