Audit Trail In Oracle Apps

Audit Trail is a way of keeping track of changes made to important data
in Oracle Application tables. Audit Trail  keeps a history of the Changes.

To setup Audit Trail in Oracle Applications perform the
following steps:

Step 1: Go to System Administrator Responsibility

Step 2: Make sure APPLSYS  has select privileges on SYS.DBA_TABLES.

For example, if you are auditing the PER_AUDIT_ALL table,
use the following SQL statement to verify this:

select TABLE_NAME
from SYS.DBA_TABLES
where TABLE_NAME like 'PER_AUDIT_ALL';

Step 3:  Define audit groups: It is required to group the tables that you
need to audit since auditing is enabled on an audit groups basis.

Navigation: Security -> Audit Trail -> Groups
Step 4:. Define audit installations: In order to be able to audit across
application installations, you must specify the Oracle ID's whose
tables you wish to audit. At this point, you will need to specify
the list of columns from the table you want audited.

Navigation: Security -> Audit Trail -> Install

Step 5:  Run the "Audit Trail Update Tables" report from the submit request
form to enable auditing.

Navigation: Requests -> Run -> select a single request

"Team Work" More We Less Me.

   Sameer Patil