Search Results table_app_id




Overview
Explore in AI Chat

Overview

The FND_AUDIT_LKUPS table is a core metadata repository within the Application Object Library (FND) of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary function is to enhance the usability of the Audit Query Navigator, a tool used for querying and reporting on audit trail data. The table achieves this by storing information about Lookup Types associated with specific audited columns. When a column's data is stored as a lookup code in an audited table, this table provides the necessary metadata to display the human-readable, decoded meaning of that code within audit reports and queries, rather than showing the internal, often cryptic, code value.

Key Information Stored

The table's structure is designed to map audited columns to their corresponding Lookup Types. The documented primary key, FND_AUDIT_LKUPS_PK1, consists of the columns AUDIT_TABLE_ID, AUDIT_COLUMN_ID, and TABLE_APP_ID. This composite key uniquely identifies the lookup mapping for a specific column in a specific audited table within a given application. The TABLE_APP_ID column, which was the focus of the user's search, is a critical foreign key that links the record to the application (APPLSYS.FND_APPLICATION) to which the audited base table belongs. The AUDIT_TABLE_ID and AUDIT_COLUMN_ID columns reference the core audit metadata tables (FND_AUDIT_TABLES and FND_AUDIT_COLUMNS) to identify the exact table and column being described.

Common Use Cases and Queries

The primary use case is the population and support of the Audit Query Navigator interface. When a user runs an audit query on a column that uses a lookup (e.g., a status or type column), the system joins FND_AUDIT_LKUPS to FND_LOOKUP_TYPES to retrieve the valid values and their meanings for display. A common administrative query would be to list all audited columns that have associated lookups for a specific table. A sample SQL pattern is:

  • SELECT fat.table_name, fac.column_name, fal.lookup_type FROM apps.fnd_audit_lkups fal, apps.fnd_audit_tables fat, apps.fnd_audit_columns fac WHERE fal.audit_table_id = fat.audit_table_id AND fal.audit_column_id = fac.audit_column_id AND fat.table_name = '&TABLE_NAME';

This helps in understanding what decoded data will be available in audit reports.

Related Objects

FND_AUDIT_LKUPS sits at the center of a key metadata relationship for audit reporting. Its documented primary key relationship implies foreign key dependencies to the core audit metadata tables. It is directly related to:

  • FND_AUDIT_TABLES: Joined via the AUDIT_TABLE_ID column to identify the audited table.
  • FND_AUDIT_COLUMNS: Joined via the AUDIT_COLUMN_ID column to identify the specific audited column within that table.
  • FND_APPLICATION: Joined via the TABLE_APP_ID column to resolve the application ownership of the base table being audited.
  • FND_LOOKUP_TYPES: Joined via the LOOKUP_TYPE column (inferred from the table's purpose, though not explicitly listed in the provided metadata) to retrieve the actual set of lookup codes and meanings for display.

These relationships are essential for the Audit Query Navigator to correctly resolve and display decoded lookup values.