FND Audit Table Changes by Record

Description
Categories: Audit, Enginatics, Toolkit - Data Management, Toolkit - Metrics, Toolkit - Operations, Toolkit - Setup & Support
Repository: Github
Reports all changes to an audited application table.

The report has one row per audit transaction showing the old and new values for all audited columns in a single row.
Run FND Audit Table Changes by Record and other Oracle EBS reports with Blitz Report™ on our demo environment
select
:audit_table audit_table,
xxen_util.client_time(aud_a.audit_timestamp) audit_timestamp,
xxen_util.meaning(aud_ac1.audit_transaction_type,'FND_AUDIT_TRANS_TYPE',0)  audit_transaction_type,
xxen_util.user_name(aud_ac1.audit_user_name) audit_transaction_user,
&sel_xinfo_table_user_cols
&sel_table_user_cols
&sel_audit_key_cols
&sel_audit_cols
to_char(aud_a.row_key) audit_row_key,
aud_a.audit_session_id,
aud_a.audit_sequence_id,
aud_a.audit_commit_id
from
&from_tables
where
aud_a.row_key=aud_ac1.row_key and
&join_audit_tab_key_cols
&join_xinfo_table_key_cols
1=1
order by
aud_a.row_key desc
/*&dummy*/
Parameter Name SQL text Validation
Audit Table
 
LOV
Audit Date From
aud_a.audit_timestamp>=:date_from
DateTime
Audit Date To
aud_a.audit_timestamp<=:date_to
DateTime
Audited User
aud_a.audit_user_name=:audited_user
LOV
Informational Audit Table Columns
x=:dummy
LOV
Additional Info Table
 
LOV
Additional Info Table Columns
x=:dummy
LOV