Search Results fnd_audit_tables_pk

Overview

The FND_AUDIT_TABLES table is a core repository object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Owned by the APPLSYS schema, its primary function is to register and manage the specific application tables that are configured for auditing. It acts as a junction table, linking defined audit groups (FND_AUDIT_GROUPS) to the individual tables (FND_TABLES) that are members of those groups. This table is essential for the EBS auditing framework, enabling administrators to track data changes at a granular, table-specific level for compliance, security, and business process monitoring.

Key Information Stored

The table's structure is defined by a composite primary key and foreign key relationships. The key columns store identifiers that establish the necessary links between auditing configurations and the application data model. The primary key, FND_AUDIT_TABLES_PK, is composed of four columns: AUDIT_GROUP_ID and AUDIT_GROUP_APP_ID, which together uniquely identify the parent audit group, and TABLE_APP_ID and TABLE_ID, which together uniquely identify the application table being audited. This design ensures that a specific table can be associated with a specific audit group only once, maintaining data integrity within the auditing setup.

Common Use Cases and Queries

The primary use case is querying the audit configuration to determine which tables are under audit surveillance and to which groups they belong. This is critical for auditing impact analysis, troubleshooting, and security reviews. A common administrative query joins FND_AUDIT_TABLES with FND_AUDIT_GROUPS and FND_TABLES to produce a readable report. For example:

• To list all audited tables with their corresponding group names: SELECT ag.AUDIT_GROUP_NAME, t.TABLE_NAME FROM apps.FND_AUDIT_TABLES at, apps.FND_AUDIT_GROUPS ag, apps.FND_TABLES t WHERE at.AUDIT_GROUP_ID = ag.AUDIT_GROUP_ID AND at.AUDIT_GROUP_APP_ID = ag.APPLICATION_ID AND at.TABLE_ID = t.TABLE_ID AND at.TABLE_APP_ID = t.APPLICATION_ID;
• To verify if a specific table (e.g., FND_USER) is audited: SELECT * FROM apps.FND_AUDIT_TABLES WHERE TABLE_ID = (SELECT TABLE_ID FROM apps.FND_TABLES WHERE TABLE_NAME='FND_USER');

Related Objects

FND_AUDIT_TABLES has documented foreign key relationships with two key metadata tables, forming the backbone of the EBS auditing definition layer. The relationships are as follows:

• FND_AUDIT_GROUPS: The table is a child of FND_AUDIT_GROUPS. The columns AUDIT_GROUP_APP_ID and AUDIT_GROUP_ID in FND_AUDIT_TABLES reference the APPLICATION_ID and AUDIT_GROUP_ID columns in FND_AUDIT_GROUPS, respectively. This defines the audit group to which the table membership belongs.
• FND_TABLES: The table is also a child of FND_TABLES. The columns TABLE_APP_ID and TABLE_ID in FND_AUDIT_TABLES reference the APPLICATION_ID and TABLE_ID columns in FND_TABLES, respectively. This identifies the exact application table that is subject to auditing.