Search Results ghr_groupbox_users_uk




Overview
Explore in AI Chat

Overview

The GHR_GROUPBOX_USERS table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves a critical administrative function by defining the membership of a "Groupbox." In the context of GHR, a Groupbox is a security and workflow construct used to group users, typically for the purpose of routing and approving personnel actions or other HR transactions. This table acts as the junction between a defined group (GHR_GROUPBOXES) and the individual users assigned to it, thereby enabling role-based access control and task assignment within the federal HR processes.

Key Information Stored

The table's structure is designed to map users to their respective groups. The primary columns include the GROUPBOX_USER_ID, which serves as the unique system-generated identifier for each membership record. The GROUPBOX_ID is a foreign key that links to a specific group defined in the GHR_GROUPBOXES table. The USER_NAME column stores the identifier (typically the EBS username) of the user who is a member of that group. The combination of GROUPBOX_ID and USER_NAME is enforced as a unique key (GHR_GROUPBOX_USERS_UK), preventing duplicate user assignments within the same group.

Common Use Cases and Queries

This table is primarily accessed for security configuration, workflow routing, and audit reporting. A common operational query is to retrieve all users within a specific Groupbox to verify approver lists or for mass notification purposes. For example: SELECT user_name FROM hr.ghr_groupbox_users WHERE groupbox_id = <ID>;. Conversely, to find all groups a particular user belongs to, one would query: SELECT gb.groupbox_name FROM hr.ghr_groupbox_users gbu JOIN hr.ghr_groupboxes gb ON gbu.groupbox_id = gb.groupbox_id WHERE gbu.user_name = '<USERNAME>';. System administrators frequently interact with this table when setting up or modifying the approval hierarchy for personnel actions, ensuring the correct individuals are in the routing path.

Related Objects

The GHR_GROUPBOX_USERS table has a direct and essential relationship with the GHR_GROUPBOXES table, which defines the group entities themselves. The documented foreign key relationship is:

  • GHR_GROUPBOX_USERS.GROUPBOX_ID references GHR_GROUPBOXES. This ensures that every user membership record is associated with a valid, pre-existing group. The integrity of this relationship is fundamental to the module's security model.

While not explicitly listed in the provided metadata, this table is logically central to the GHR workflow engine. It is likely referenced by various GHR APIs, concurrent programs, and forms that manage personnel action approvals and routing based on group membership.