Search Results audit_table_id

Overview

The GMA_AUDIT_LKUPS table is a configuration table within the Oracle E-Business Suite Process Manufacturing (GMA) module. Its primary role is to support the Audit Query Navigator functionality by storing metadata that maps specific table columns to their corresponding Application Object Library (FND) lookup types. This mapping enables the Audit Query Navigator form to display user-friendly, decoded descriptions (meaningful values) instead of internal stored codes (lookup codes) when presenting audit trail data to end-users. It acts as a critical reference layer for translating coded column values into business terminology within audit reports and inquiries.

Key Information Stored

The table's structure is designed to uniquely identify a column and its associated lookup definition. Its primary key is a composite of three columns: TABLE_APP_ID, AUDIT_TABLE_ID, and AUDIT_COLUMN_ID. The TABLE_APP_ID column stores the application identifier (from FND_APPLICATION) for the module owning the audited table. The AUDIT_TABLE_ID and AUDIT_COLUMN_ID columns hold identifiers that reference the specific table and column within the GMA audit infrastructure. While not explicitly listed in the brief metadata, based on its described purpose, the table would also contain a column (commonly named LOOKUP_TYPE) to store the actual FND lookup type (e.g., 'YES_NO', 'ORDER_TYPE') used to decode the column's stored values.

Common Use Cases and Queries

The primary use case is the population and operation of the Audit Query Navigator form. When a user runs an audit query, the application joins to this table to determine if any selected columns require value translation. A common administrative query would list all configured lookups for audit columns within a specific application. A sample SQL pattern to retrieve this mapping information is:

• SELECT gal.table_app_id, gal.audit_table_id, gal.audit_column_id, gal.lookup_type, fat.application_name FROM gma_audit_lkups gal, fnd_application_tl fat WHERE gal.table_app_id = fat.application_id;

This table is typically queried by the application's underlying packages and forms rather than directly by end-user reports, which would consume the already-decoded output from the Audit Query Navigator.

Related Objects

GMA_AUDIT_LKUPS is a central reference table within the GMA audit framework. Its primary key (GMA_AUDIT_LKUPS_P) ensures uniqueness for the column mapping. It has a direct relationship with the Application Object Library via the TABLE_APP_ID column, which is a foreign key to FND_APPLICATION.APPLICATION_ID. Furthermore, the AUDIT_TABLE_ID and AUDIT_COLUMN_ID columns are foreign keys to other core GMA audit metadata tables, such as GMA_AUDIT_TABLES and GMA_AUDIT_COLUMNS, which define the tables and columns being audited. The table is referenced by the programs and forms that render the Audit Query Navigator interface to perform the lookup value decoding.