Steps by step: Enabling audit trial
As per the below example the 'Define An application user' is a user table name for FND_USER,the same steps you can follow for your own tables.
Go to Audit Trail -> Tables -> Query for Define an Application User.let say you are suppose to do the audit on these tables.
Add the columns whatever you want to audit.
Go to Audit Trail -> Groups -> Query for Audit Setup Group
Enable the 'Audit Setup Group'.
Run audittrail update table.
add the Define an application user table under Audit Setup Group.
Run the audit train update table again.
Go to Audit Query Navigator ->Functional Groups-> Now you can see the Define an Application user table added under the audit setup
If the table is available as per the step 8,Now run the Audit trail report,you will be able to get the audit information.
Steps by step: How to Disable AuditTrails
There are three ways to disable auditing feature:
- Disable Prepare for Archive
- Disable Interrupt Audit
- Disable Purge Table
Steps by step: How To Remove a Column From Audit Trial Tables?
- You need to navigate with System Administrator responsiblity Security -> AuditTrail ->Groups
- Query the group that contains the table that you want to modify columns assignment
- Disable this group using the option : Disable - Purge Table
- Run the concurrent request "AuditTrail Update Tables"
- Truncate fnd_audit_columns drop all triggers,procedure, view , synoyms
- Make a copy of table "FND_AUDIT_COLUMNS"
- Go to the following navigation path : System Administrator -> Security -> AuditTrail -> Tables
- Query your table that you need to remove a column from it.
- Go to Help -> Diagnostics -> Examine <Enter apps password>
- Choose the field = COLUMN_ID and take remark of that value
- Choose the field = TABLE_ID and take remark of that value too.
- Login to sqlplus using apps/<apps password>
- Execute the following:
delete from FND_AUDIT_COLUMNS where TABLE_ID = <value in step 10> and column_id = <value in
- Save you work
- Go back to step 1 and query the group that contains the table that you made the columns change and Enable this group using the option : Enabled
- Finally complete this by executing the concurrent request "AuditTrail Update Tables"
Steps by step: Enabling Audit Trail for Custom Objects
The process remain same, as mention above. You should make sure that your have used ad_dd package to create custom objects in Applications. and you have used ad_dd.register_table to register table and ad_dd.register_column to register columns
Your step for enabling custom Object should be as
- Grant select on table to APPS
- Create a synonym as APPS to the table
- Run the AD_DD package to register the table
- Run the AD_DD package to register the columns
- Run the AD_DD package to register the primary keys
- execute ad_dd.register_primary_key('application short name', 'primary key column name', 'table name','description of key column', 'S', 'Y','Y');
- execute ad_dd.register_primary_key_column('application short name', 'primary key column name', 'table name', 'column name', 1);
or you can also do it In the screen:
-> Security > Oracle > Register
Report helpful while enabling this feature
As discussed in last post these two report is important.
- AuditTrail Report for Audit Group Validation
- AuditTrail Update Tables