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.
Hi
ReplyDeletei have found this blog very informative related to the Oracle application tips .i have found little for information from other site oracle fussion middleware