Search Results fnd_oracle_userid

Overview

The FND_ORACLE_USERID table is a core reference table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It functions as the central registry for all Oracle database schema accounts that contain application data. Its primary role is to provide a unique identifier (ORACLE_ID) for these schemas, enabling the EBS architecture to manage and reference them consistently across the entire application stack. This table is fundamental to the system's multi-org, data partitioning, and concurrent processing frameworks, ensuring that operations are correctly scoped to the appropriate data source schema.

Key Information Stored

The table's structure is designed to map internal identifiers to physical database schemas. The two most critical columns are ORACLE_ID and ORACLE_USERNAME. ORACLE_ID is a numeric primary key serving as the internal, immutable reference to a specific Oracle schema. ORACLE_USERNAME is the actual name of the database schema (e.g., APPLSYS, GL, AP) and is enforced as a unique key. While the provided metadata does not list all columns, typical implementations may also include descriptive columns and tracking attributes such as CREATION_DATE or LAST_UPDATE_DATE. The integrity of this mapping is maintained by the primary key (FND_ORACLE_USERID_PK) on ORACLE_ID and a unique key (FND_ORACLE_USERID_UK1) on ORACLE_USERNAME.

Common Use Cases and Queries

This table is frequently referenced in technical administration, troubleshooting, and reporting scenarios. A common use is identifying the database schema associated with a specific product module or concurrent request. For instance, to find all registered Oracle schemas, administrators would query: SELECT oracle_id, oracle_username FROM apps.fnd_oracle_userid ORDER BY oracle_username;. When investigating concurrent manager issues, one might join to FND_CONCURRENT_REQUESTS to see which schema executed a request: SELECT req.request_id, usr.oracle_username FROM apps.fnd_concurrent_requests req, apps.fnd_oracle_userid usr WHERE req.oracle_id = usr.oracle_id;. It is also essential for scripts that need to generate dynamic SQL or validate schema existence before performing DBA operations within the EBS context.

Related Objects

As indicated by the extensive foreign key relationships in the metadata, FND_ORACLE_USERID is a parent table to numerous critical application tables. Its ORACLE_ID column is referenced by objects managing concurrent processing (FND_CONCURRENT_REQUESTS, FND_CONCURRENT_QUEUE_CONTENT), product installations (FND_PRODUCT_INSTALLATIONS, FND_MODULE_INSTALLATIONS), data security (FND_DATA_GROUP_UNITS), and workflow alerts (ALR_ALERT_INSTALLATIONS, ALR_ORACLE_MAIL_ACCOUNTS). This widespread dependency underscores its role as a foundational cross-module entity. Key related tables include:

• FND_CONCURRENT_REQUESTS: Links requests to the executing schema.
• FND_PRODUCT_INSTALLATIONS: Tracks which products are installed in which schema.
• FND_DATA_GROUP_UNITS: Defines data group assignments for schemas.
• ALR_ALERT_INSTALLATIONS: Associates alert installations with specific schemas.