Search Results retrieve_result_tables

Overview

APPS.FND_AUDIT_PKG is a PL/SQL package in the Oracle E-Business Suite Applications Technology layer that supports the Oracle EBS audit-trail infrastructure. Its principal business function is to materialize the set of audited ("audit required") tables that satisfy a caller-supplied audit query, and then to populate the audit reporting data used to render audit results. In effect, the package sits between the audit configuration metadata stored in the FND_AUDIT_* tables and the user-facing audit report or audit form, allowing administrators and auditors to query audit history across one or many audited tables without hard-coding table lists.

The package header carries the identifiable revision marker FNDAUDTS.pls 120.2, dated 2005, indicating that it is a long-standing, stable component of the FND audit framework present in both 12.1.1 and 12.2.2. It declares public record and collection types — AUDIT_REQUIRED_TABLE / AUDIT_REQUIRED_TABLES_TYPE and REPORT_TABLE — together with the global AUDIT_ON boolean, which together define the data contracts used by calling programs.

Key Procedures and Functions

• RETRIEVE_RESULT_TABLES — Resolves the set of tables that must participate in an audit query. It accepts an audit-level WHERE clause and a table-level WHERE clause and returns, through an IN OUT NOCOPY collection of type AUDIT_REQUIRED_TABLES_TYPE, the audited tables matching those filters. This is the procedure most commonly referenced by the search term retrieve_result_tables; it is the entry point for determining which audit tables exist for a given reporting context.
• POPULATE_TAB_REP_DATA — Populates audit report data for a single audited table. Given a select clause, the physical table name, the user-facing table name, a WHERE clause, and identifiers for the application, table, and report, it inserts the audit rows required to produce output in the report structure defined by the REPORT_TABLE record (audit key, timestamp, transaction type, user name, and up to five audited column values).

The package exposes only these two documented procedures; no additional public functions are declared in the header excerpt.

Tables Accessed

• FND_AUDIT_DISP_COLS — audit display column definitions, used to determine which columns appear in audit output.
• FND_AUDIT_REP_DTL — audit report detail, holding the report-level rows populated by POPULATE_TAB_REP_DATA.
• FND_COLUMNS — column metadata for the audited tables, resolving column values into the COLUMN1_VALUE through COLUMN5_VALUE slots.
• FND_PRIMARY_KEYS and FND_PRIMARY_KEY_COLUMNS — primary key definitions and their constituent columns, used to build the audit key and to join audit records back to the source rows.
• FND_TABLES — the registered table inventory, used to validate and resolve table names, TABLE_ID, and TABLE_APPLICATION_ID.
• TAB — the user-facing synonym reference used to present readable table names (USER_TABLE_NAME).

All access is through APPS synonyms, consistent with standard EBS coding practice.

Usage Notes

FND_AUDIT_PKG is an internal, low-level utility rather than a public API. ETRM classifies it as OTHER and records zero packages referencing it, confirming it is not part of a documented call chain exposed to customers. It is normally invoked indirectly by the standard Oracle audit forms and by audit-report concurrent programs within the FND/Application Object Library audit feature set, which call RETRIEVE_RESULT_TABLES to build the working set of audited tables and then drive POPULATE_TAB_REP_DATA per table. Custom audit extensions and diagnostics may call the same procedures where a site requires bespoke audit reporting, but such use is unsupported and should be validated against the 12.1.1 and 12.2.2 code levels, since behavior depends on the completeness of the FND audit metadata (primary keys, display columns, and registered tables) for the objects being audited.