FND Audit Table Changes by Record
Description
Categories: Enginatics
Repository: Github
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.
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 |
|
DateTime | |
| Audit Date To |
|
DateTime | |
| Audited User |
|
LOV | |
| Informational Audit Table Columns |
|
LOV | |
| Additional Info Table |
|
LOV | |
| Additional Info Table Columns |
|
LOV |
