Search Results fnd_audit_pkg




Overview
Explore in AI Chat

Overview

FND_AUDIT_PKG is a core Oracle E-Business Suite package in the APPS schema responsible for the data-retrieval and reporting side of the Oracle EBS Audit Trail (AuditTrack) facility. AuditTrail allows administrators to enable auditing on selected application tables and columns, capturing inserts, updates, and deletions into shadow audit tables. FND_AUDIT_PKG complements the configuration and runtime components of this framework by providing the programmatic logic used to define and populate the audit reporting tables — specifically the display-column selection and the result/reporting data set presented to users querying audit history.

The package body is listed as VALID in ETRM for both 12.1.1 and 12.2.2 and is classified as a non-API (OTHER) package, meaning it is intended primarily for internal use by the AuditTrail forms and reports rather than as a published extension interface. It is not referenced by any other database object, confirming its role as a top-level support package in the audit reporting layer.

Key Procedures and Functions

  • RETRIEVE_RESULT_TABLES — Returns the set of audit result tables relevant to a given audit definition. It is the entry point through which callers obtain the dynamically generated audit table names that hold the captured change history for an audited entity, enabling the reporting layer to query the correct shadow tables.
  • POPULATE_TAB_REP_DATA — Populates the audit report/display data for a table. It assembles the metadata-driven result set that the AuditTrail reporting UI presents, drawing its column definitions and key structure from the audit display and primary-key metadata tables.

Both procedures rely on the package's private SQL and cursor logic to resolve table and column definitions dynamically; no parameter signatures are published in the ETRM metadata, and callers should treat them as internal components invoked by the standard AuditTrail screens and reports.

Tables Accessed

  • FND_AUDIT_DISP_COLS — Stores the columns selected for display in the audit report; drives which columns POPULATE_TAB_REP_DATA projects.
  • FND_AUDIT_REP_DTL — Holds the audit report detail definitions used to structure the reporting output.
  • FND_COLUMNS — Provides the base column metadata (names, data types, sequence) for the audited tables.
  • FND_TABLES — Supplies the registered application table definitions that anchor the audit configuration.
  • FND_PRIMARY_KEYS and FND_PRIMARY_KEY_COLUMNS — Define the primary key structure of audited tables, enabling the reporting logic to identify and group change records by key value.
  • TAB (PUBLIC synonym) — Used as the generic result-table reference for the dynamically retrieved audit data.

Together these tables form the metadata backbone of AuditTrail: table and column registrations, display configuration, and primary-key definitions. The package reads this metadata to construct its dynamic SQL and result structures.

Usage Notes

FND_AUDIT_PKG is typically invoked indirectly through the Oracle EBS AuditTrail administrative and reporting forms and concurrent programs rather than called directly by custom code. Administrators interact with the AuditTrail setup and query screens; those screens invoke this package to resolve result tables and populate the report data set. Because the package is not referenced by any other database object and is not a published API, direct invocation from custom integrations is discouraged — the internal SQL relies on the dynamic audit table naming conventions and the FND audit metadata tables remaining consistent. When troubleshooting AuditTrail reporting issues, DBAs commonly inspect this package body alongside FND_AUDIT_DISP_COLS and FND_AUDIT_REP_DTL to verify that display columns and report definitions are correctly configured. Standard Oracle support policy applies: modifications should be avoided, as the object is owned by APPS and patched by Oracle.