Search Results fnd_data_groups




Overview
Explore in AI Chat

Overview

The FND_DATA_GROUPS table is a core repository within the Oracle Application Object Library (FND) that defines and manages data groups. A data group is a fundamental configuration entity that establishes a logical mapping between an Oracle Applications user, a responsibility, and an Oracle database (specifically, an ORACLE_ID). This mapping is critical for determining the database connection and set of application tables (via synonyms) a user accesses when they sign on to Oracle E-Business Suite. The table serves as the master registry for all such groups, enabling the system's multi-org and data security architecture by controlling access to specific sets of data.

Key Information Stored

The table's structure centers on uniquely identifying each data group and its configuration. The primary identifier is the DATA_GROUP_ID column, which is the system-generated primary key. The DATA_GROUP_NAME column holds the unique, user-defined name for the data group and is also enforced as a unique key. While the provided ETRM excerpt does not list all columns, standard implementation columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are invariably present. The table's definition ensures that each responsibility is associated with one, and only one, data group.

Common Use Cases and Queries

This table is primarily referenced for system administration, auditing, and troubleshooting connection or data access issues. A common query retrieves all defined data groups to review the system's security setup. For example: SELECT data_group_id, data_group_name FROM apps.fnd_data_groups ORDER BY data_group_name;. To diagnose a user's access path, one would join this table with FND_RESPONSIBILITY and FND_USER to see which data group is assigned to a user's active responsibility. Administrators may also query it to identify unused data groups before cleanup or to verify configurations during an upgrade or migration, ensuring the correct ORACLE_ID mappings are in place for each application module.

Related Objects

As documented in the foreign key relationships, FND_DATA_GROUPS is a parent table to several key objects. The DATA_GROUP_ID column is referenced by:

  • ALR_ALERT_INSTALLATIONS: Links alert installations to a specific data group.
  • FND_CONCURRENT_QUEUES: Associates concurrent manager processing queues with a data group, defining which database they target.
  • FND_DATA_GROUP_UNITS: A child table that defines the specific application database objects (units) associated with the parent data group.
Furthermore, the table has an intrinsic relationship with the FND_RESPONSIBILITY table, which stores the DATA_GROUP_ID assigned to each responsibility, forming the core of the user access model.