Previous | Next | Contents | Index | Navigation | Glossary | Library |
For a datetracked table, the dynamic SQL structure retrieves information from the function and procedure created for each datetracked table by the Audit Trail Update Datetracked Tables process:
The structure is built up by identifying the audited table column information, which is retrieved from the FND_AUDIT_COLUMNS table. The logic varies depending on the data type being audited.
The package for the dynamic SQL is called py_audit_report_pkg. It is found in the script pyadyn.pkh/pyadyn.pkb.
COLUMN TYPE NULL --------------------------- ------------ -------- audit_id number(15) not null commit_id number(9) not null current_session_id number not null primary_key varchar2(30) not null primary_key_value number(15) mot null sequence_id number(9) not null session_id number not null table_name varchar2(30) not null timestamp date not null transaction varchar2(30) not null transaction_type varchar2(30) not null user_name varchar2(100) not null effective_end_date date null effective_start_date date null
COLUMN TYPE NULL --------------------------- ------------ -------- audit_id number(15) not null column_id number(9) not null column_name varchar2(30) not null new_value varchar2(240) null old_value varchar2(240) null
Previous | Next | Contents | Index | Navigation | Glossary | Library |