Search Results ghr_groupboxes_uk1




Overview
Explore in AI Chat

Overview

The HR.GHR_GROUPBOXES 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 role is to define logical group boxes used by the system's workflow and routing processes. These group boxes serve as abstract containers or distribution lists, enabling the routing of personnel actions, position descriptions, and other workflow items to predefined sets of users or roles rather than to individuals. The table is stored in the APPS_TS_SEED tablespace, indicating its foundational nature within the application's data model.

Key Information Stored

The table stores the definition and metadata for each workflow group box. Key columns include:

Common Use Cases and Queries

This table is central to configuring and auditing workflow routing in GHR. Common use cases include troubleshooting routing issues, generating reports on active routing groups, and validating setup data. A fundamental query retrieves all group boxes with their associated routing group information:

SELECT gb.NAME, gb.DISPLAY_NAME, gb.DESCRIPTION, rg.NAME as ROUTING_GROUP
FROM HR.GHR_GROUPBOXES gb
LEFT JOIN HR.GHR_ROUTING_GROUPS rg ON gb.ROUTING_GROUP_ID = rg.ROUTING_GROUP_ID
ORDER BY gb.NAME;

To find a specific group box by its unique name (as enforced by GHR_GROUPBOXES_UK1), a typical query would be: SELECT * FROM HR.GHR_GROUPBOXES WHERE NAME = '&GROUPBOX_NAME';. This is essential for verifying the existence of a group box referenced in workflow rules or error messages.

Related Objects

The HR.GHR_GROUPBOXES table is a central hub in the GHR routing schema, with defined foreign key relationships to several other tables. It references one parent table and is referenced by multiple child tables, as documented in the ETRM metadata:

  • Parent Reference (Outgoing FK):
    • References HR.GHR_ROUTING_GROUPS via the ROUTING_GROUP_ID column.
  • Child References (Incoming FKs):

These relationships confirm the table's critical function as the master definition for group boxes that are utilized across the GHR workflow and routing infrastructure.