Search Results fnd_data_group_units




Overview
Explore in AI Chat

Overview

The FND_DATA_GROUP_UNITS table is a core Application Object Library (FND) table in Oracle E-Business Suite (EBS) that defines the mapping between applications, data groups, and Oracle database accounts. Its primary role is to manage the assignment of specific Oracle database schemas (ORACLE_ID) to an application (APPLICATION_ID) within the context of a given data group (DATA_GROUP_ID). This structure is fundamental to the EBS architecture, enabling multiple applications to share or be isolated within different database schemas and facilitating the connection model used by application responsibilities and concurrent managers.

Key Information Stored

The table stores the critical links that form a data group unit. Its composite primary key and foreign key columns are central to its function.

  • APPLICATION_ID: Identifies an Oracle EBS application (e.g., General Ledger, Payables). Part of the primary key (FND_DATA_GROUP_UNITS_PK).
  • DATA_GROUP_ID: Identifies the data group to which this application mapping belongs. Part of the primary key and a foreign key to FND_DATA_GROUPS.
  • ORACLE_ID: References the specific Oracle database schema (from FND_ORACLE_USERID) designated for the given application within this data group. This defines the database account used for connecting to the database when this application/data group combination is active.

Common Use Cases and Queries

This table is primarily queried for system configuration analysis, troubleshooting responsibility definitions, and auditing the database connection setup. A common scenario is identifying all applications and their associated database schemas for a specific data group, which is essential for understanding the security and data access model of an EBS instance.

Sample Query: To list all application-to-schema mappings within a data group named 'STANDARD':

SELECT fgu.application_id,
       fa.application_short_name,
       fgu.data_group_id,
       fdg.data_group_name,
       fgu.oracle_id,
       fou.oracle_username
  FROM apps.fnd_data_group_units fgu,
       apps.fnd_application      fa,
       apps.fnd_data_groups      fdg,
       apps.fnd_oracle_userid    fou
 WHERE fgu.application_id = fa.application_id
   AND fgu.data_group_id = fdg.data_group_id
   AND fgu.oracle_id = fou.oracle_id
   AND fdg.data_group_name = 'STANDARD'
 ORDER BY fa.application_short_name;

This table is also indirectly queried whenever a user logs into a responsibility, as the system uses the responsibility's assigned DATA_GROUP_ID and DATA_GROUP_APPLICATION_ID to resolve the correct ORACLE_ID from this table for establishing a database session.

Related Objects

FND_DATA_GROUP_UNITS sits at the intersection of several key FND tables, as documented in its foreign key relationships.

  • Referenced By (Foreign Keys from FND_DATA_GROUP_UNITS):
    • FND_DATA_GROUPS: Via FND_DATA_GROUP_UNITS.DATA_GROUP_ID. A data group is a parent entity containing multiple application mappings.
    • FND_ORACLE_USERID: Via FND_DATA_GROUP_UNITS.ORACLE_ID. This links to the registered database schema account.
  • Referenced By Other Tables (Foreign Keys to FND_DATA_GROUP_UNITS):
    • FND_RESPONSIBILITY: The columns FND_RESPONSIBILITY.DATA_GROUP_APPLICATION_ID and FND_RESPONSIBILITY.DATA_GROUP_ID together form a foreign key to this table's primary key. This is the most critical relationship, as it defines which specific application mapping (data group unit) a responsibility uses for its database connections.