Search Results ghr_groupboxes




Overview
Explore in AI Chat

Overview

The GHR_GROUPBOXES table is a core data object within the US Federal Human Resources (GHR) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the master repository for defining groupboxes, which are logical containers used to organize and manage users within the workflow routing processes specific to federal personnel actions. The table's primary purpose, as indicated by its description, is to store groupboxes "defined to be used by workflow." This makes it a critical component for configuring and executing the approval and notification chains for actions such as personnel actions (PA) and position descriptions (PD) in the federal government context.

Key Information Stored

The table's structure centers on a unique identifier and a name for each groupbox. The primary key is the GROUPBOX_ID column, which provides a unique numeric identifier for each record. A separate unique key constraint (GHR_GROUPBOXES_UK1) is enforced on the NAME column, ensuring that each groupbox has a distinct, identifiable label within the system. While the provided metadata does not list all columns, the foreign key relationships imply the existence of a ROUTING_GROUP_ID column. This column links a groupbox to a specific routing group defined in the GHR_ROUTING_GROUPS table, establishing the hierarchical relationship between routing configurations and the user containers within them.

Common Use Cases and Queries

The primary use case for this table is the administration and reporting of workflow routing configurations. System administrators query this table to audit existing groupboxes, troubleshoot routing issues, or generate lists of all defined containers. A common reporting need is to list all groupboxes within a specific routing group. A sample SQL query for this would join the GHR_GROUPBOXES table to the GHR_ROUTING_GROUPS table. Furthermore, to see the actual users assigned to a groupbox, a query would join GHR_GROUPBOXES to GHR_GROUPBOX_USERS via the GROUPBOX_ID column. Troubleshooting a specific personnel action's routing history would involve joining GHR_GROUPBOXES to GHR_PA_ROUTING_HISTORY to identify which groupbox was involved at a particular workflow step.

Related Objects

The GHR_GROUPBOXES table is a central hub in the GHR workflow schema, with numerous foreign key relationships. The documented relationships are as follows:

  • GHR_ROUTING_GROUPS: A groupbox belongs to a routing group (GHR_GROUPBOXES.ROUTING_GROUP_ID references GHR_ROUTING_GROUPS).
  • GHR_GROUPBOX_USERS: A groupbox contains many users (GHR_GROUPBOX_USERS.GROUPBOX_ID references GHR_GROUPBOXES).
  • GHR_PA_ROUTING_HISTORY & GHR_PD_ROUTING_HISTORY: These history tables record when a personnel action or position description was routed to a specific groupbox.
  • GHR_POIS: The Position of Record (POI) table can reference a default groupbox.
  • GHR_ROUTING_LIST_MEMBERS: This table links groupboxes (among other entities) to specific routing lists for workflow.
These relationships illustrate that GHR_GROUPBOXES is essential for linking workflow definitions (routing groups/lists) to the actual users and tracking their involvement in historical transactions.