Search Results fnd_request_groups_pk

Overview

The FND_REQUEST_GROUPS table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS). It serves as the master definition table for report security groups, a fundamental component of the application's security and access control model. Each record in this table defines a distinct request group, which is a logical collection of concurrent programs, request sets, or other executable functions. The primary role of a request group is to be assigned to a responsibility, thereby controlling which reports and programs a user can submit when operating under that responsibility. This mechanism ensures that users only have access to the specific business functions and reports appropriate for their role within the organization.

Key Information Stored

The table structure centers on uniquely identifying and naming each security group within a specific application. According to the provided metadata, the table's design enforces data integrity through two primary keys. The first, FND_REQUEST_GROUPS_PK, is based on APPLICATION_ID and REQUEST_GROUP_ID, ensuring each group has a unique numeric identifier within its application. The second, FND_REQUEST_GROUPS_UK1, is a unique key on APPLICATION_ID and REQUEST_GROUP_NAME, guaranteeing that no two groups within the same application can share the same name. The most critical columns are APPLICATION_ID, which links to FND_APPLICATION to identify the owning product; REQUEST_GROUP_ID, the internal primary key; and REQUEST_GROUP_NAME, the unique descriptive name used for identification within the application's forms and setups.

Common Use Cases and Queries

This table is central to security administration, reporting, and troubleshooting. A common administrative task is identifying which request groups are defined for a specific application or module. The following query retrieves all groups for the General Ledger application (APPLICATION_ID = 101):

• SELECT REQUEST_GROUP_NAME, REQUEST_GROUP_ID FROM APPLSYS.FND_REQUEST_GROUPS WHERE APPLICATION_ID = 101 ORDER BY 1;

Another frequent use case is diagnosing a user's inability to run a specific report. This involves tracing from the user's responsibility back to its assigned request group. Developers and DBAs also query this table to understand dependencies before modifying or purging setup data. Furthermore, the table is essential for generating documentation of the implemented security model, listing all defined groups and their constituent programs via a join to FND_REQUEST_GROUP_UNITS.

Related Objects

As indicated by the foreign key relationships, FND_REQUEST_GROUPS is a pivotal node in the EBS data model. The FND_APPLICATION table is referenced to validate the APPLICATION_ID. The FND_REQUEST_GROUP_UNITS table holds the detailed membership of the group, storing which specific concurrent programs and request sets belong to each REQUEST_GROUP_ID. Most importantly, the FND_RESPONSIBILITY table references FND_REQUEST_GROUPS via the columns GROUP_APPLICATION_ID and REQUEST_GROUP_ID. This link is what attaches a security group to a responsibility, making it a live part of the application's access control. Consequently, any analysis of responsibility security inherently involves this table.