FND Audit Table Changes by Record

➜ Back to Library
Description
Categories: Enginatics
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.
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 NameSQL textValidation
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=:dummy1
LOV
Additional Info Table
 
LOV
Additional Info Table Columns
x=:dummy2
LOV
Download
Related Blitz Reports
CAC Intercompany SO Price List vs. Item Cost Comparison CAC AP Accrual Reconciliation Summary by Match Type CAC Receiving Activity Summary PSP Post Upgrade Bad Data CAC Invoice Price Variance CAC WIP Account Detail CAC Receiving Account Detail CAC WIP Account Summary CAC Receiving Account Summary CAC Receiving Account Detail (GST)
Blitz Report™