Search Results schema_id




Overview
Explore in AI Chat

Overview

The FND_AUDIT_SCHEMAS table is a core repository within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) that defines and manages audit schemas. An audit schema is a logical grouping of database tables and columns that have been registered for auditing within the application. This table acts as the master definition, enabling the system to track and record changes to critical business data for compliance, security, and historical analysis. Its existence is fundamental to the EBS auditing infrastructure, providing the structural framework upon which detailed audit trails are built.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the documented foreign key relationships and primary key reveal its critical structure. The primary key is SCHEMA_ID, a unique identifier for each registered audit schema. The table stores foreign key references to other master tables to define the schema's context: APPLICATION_ID links to FND_APPLICATION to associate the schema with a specific EBS product or module, and ORACLE_ID links to FND_ORACLE_USERID to associate the schema with a specific database schema or user. This structure allows the system to know which tables, in which application, and under which database schema are subject to auditing.

Common Use Cases and Queries

The primary use case is the administration and investigation of data audits. System administrators may query this table to review which audit schemas are active. A common reporting need is to list all audit schemas defined for a specific application. A typical query would join to the related master tables for descriptive information:

  • Identifying registered audit schemas: SELECT schema_id, application_id, oracle_id FROM apps.fnd_audit_schemas;
  • Listing schemas with application and user details: SELECT fas.schema_id, fa.application_short_name, fou.oracle_username FROM apps.fnd_audit_schemas fas, apps.fnd_application fa, apps.fnd_oracle_userid fou WHERE fas.application_id = fa.application_id AND fas.oracle_id = fou.oracle_id;

This table is typically referenced when diagnosing or reporting on audit trail functionality, as it is the parent record for the specific audit columns defined in FND_AUDIT_COLUMNS.

Related Objects

The FND_AUDIT_SCHEMAS table is central to a small but critical network of auditing objects, as confirmed by the documented foreign keys.

  • FND_APPLICATION: The SCHEMA_ID is linked via FND_AUDIT_SCHEMAS.APPLICATION_ID. This relationship ties an audit schema to a specific EBS application.
  • FND_ORACLE_USERID: The SCHEMA_ID is linked via FND_AUDIT_SCHEMAS.ORACLE_ID. This associates the audit schema with a database user.
  • FND_AUDIT_COLUMNS: This is a key child table. FND_AUDIT_COLUMNS.SCHEMA_ID is a foreign key referencing FND_AUDIT_SCHEMAS.SCHEMA_ID. This relationship is where the audit schema definition is extended to specify the exact table columns being audited.