How to enable Audit Trail on EBS

Here is an example to enable Audit Trail on HZ_PARTIES and HZ_CUST_ACCOUNTS tables:

a. (R)System Administrator, (N) Profile -> System
Query Profile: 'AuditTrail:Activate'. Click FIND
Set it to 'Yes' at Site level.

b) Enable Audit Installations (AR)
-- Got System Admin: Security:AuditTrail:Install
-- Enable Audit Installation for AR


c) Define Audit tables and desired columns.
-- Got System Admin: Security: Audit Trail: Tables
-- Query for user table name 'HZ_PARTIES' and add columns on which you want to enable trail
-- do the same for table HZ_CUST_ACCOUNTS

d) Define an Audit Group and associated tables
-- Got System Admin: Security: Audit Trail: Groups
-- Create Audit group for table defined in 'C'

e) Run Concurrent program 'AuditTrail Report for Audit Group Validation' with parameter as your
Audit Group.

f) Define an Industry Template contain Audit Group
-- Got System Admin: Security: Audit Trail Reporting: Audit Industry Template

g) Run concurrent program "AuditTrail Update Tables".

h) Confirm existence of Audit tables (_A).

i) Run Audit report from SysAdmin menus. (Security: AuditTrail: Audit Trail Reporting: Audit Report)

Above request will fire a concurrent request whose output can be used for Audit reporting.

metalink note. 848039.1