FND Audit Setup

Description

Categories
Enginatics
Repository
GitHub
FND audit setup validation report including audit groups, audit tables and audited columns, and a check if the corresponding audit tables are created in columns 'Audit Table Name' and 'Audit Column Exists'.

Oracle's standard audit trail works with a concurrent program 'AuditTrail Update Tables', which creates a set of database triggers for updates, inserts and deletes. The triggers write table changes to an audit table with the name: audited_table_A.

The whole audit trail setup process is describe in this blog: https://www.enginatics.com/blog/how-to-track-master-data-changes-using-oracle-ebs-audit-function-and-blitz-report/

SQL 81 lines

Parameters 2

ParameterTypeList of values SQL
Audit TableLOV
ft.table_name=:audit_table
Audit GroupLOV
fag.group_name=:audit_group