Search Results groupbox_user_id




Overview
Explore in AI Chat

Overview

The HR.GHR_GROUPBOX_USERS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the US Federal Human Resources (GHR) module. Its primary function is to define the membership and associated roles of users within a Groupbox. A Groupbox is a configurable container used to manage groups of users for workflow routing and approval processes in federal personnel actions. This table acts as the junction between a defined group (GHR_GROUPBOXES) and the individual EBS users assigned to it, explicitly capturing the functional roles each user is authorized to perform within that group's context.

Key Information Stored

The table stores user assignments and their authorized roles for specific Groupboxes. The key columns are:

  • GROUPBOX_USER_ID: The system-generated primary key (from sequence GHR_GROUPBOX_USERS_S), uniquely identifying each user-group assignment.
  • GROUPBOX_ID: Foreign key to HR.GHR_GROUPBOXES, identifying the specific group to which the user belongs.
  • USER_NAME: The identifier (typically the EBS username) of the assigned user.
  • Role Flags (INITIATOR_FLAG, REQUESTER_FLAG, etc.): A series of VARCHAR2 columns indicating which of the predefined workflow roles (Initiator, Requester, Authorizer, Personnelist, Approver, Reviewer) the user is permitted to fulfill for actions associated with this Groupbox.
  • Standard Who Columns (CREATION_DATE, CREATED_BY, etc.): Audit columns tracking the record's creation and last update details.

Common Use Cases and Queries

This table is central to configuring and auditing workflow security and routing rules. A common operational use case is identifying all users authorized to approve actions for a specific group. For reporting and administration, queries often join to the GHR_GROUPBOXES table to provide context. A typical diagnostic query to list all members of a Groupbox and their roles would be:

SELECT gbu.USER_NAME, gb.GROUPBOX_NAME, gbu.INITIATOR_FLAG, gbu.APPROVER_FLAG, gbu.REVIEWER_FLAG FROM HR.GHR_GROUPBOX_USERS gbu, HR.GHR_GROUPBOXES gb WHERE gbu.GROUPBOX_ID = gb.GROUPBOX_ID AND gb.GROUPBOX_NAME = '&GROUPBOX_NAME';

Another critical use case is validating user permissions during a workflow process, where the application checks this table to determine if the current user has the required role flag (e.g., AUTHORIZER_FLAG = 'Y') for the relevant Groupbox associated with the transaction.

Related Objects

The table has defined relationships with other key GHR objects, primarily through foreign key constraints.

  • HR.GHR_GROUPBOXES: This is the primary parent table. The column GROUPBOX_ID in GHR_GROUPBOX_USERS is a foreign key referencing GHR_GROUPBOXES.GROUPBOX_ID. This relationship ensures every user assignment is linked to a valid, existing Groupbox definition.
  • Sequence: GHR_GROUPBOX_USERS_S: The sequence responsible for generating unique values for the GROUPBOX_USER_ID primary key column.

While not listed in the provided dependencies, this table is logically central to the GHR workflow engine and is likely referenced by various application program interfaces (APIs) and forms that manage Groupbox configuration and user role assignments.