Search Results pqh_roles_uk




Overview
Explore in AI Chat

Overview

The PQH_ROLES table is a core data object within the Oracle E-Business Suite Public Sector Human Resources (PQH) module. It functions as the master repository for defining and storing all workflow and security roles specific to position control processes. These roles are fundamental to the configuration of approval hierarchies, routing rules, and access permissions for critical HR transactions, such as position creation, budget authorization, and position management. The table's integrity is enforced by primary and unique key constraints, ensuring that each role is uniquely identifiable and named within the system.

Key Information Stored

The table's structure is designed to catalog essential attributes for each role. The primary identifier is the ROLE_ID column, which serves as the system-generated primary key (PQH_ROLES_PK). The ROLE_NAME column holds the unique, user-defined name for the role and is protected by a unique key constraint (PQH_ROLES_UK). A critical relational column is BUSINESS_GROUP_ID, which links the role to a specific business unit (HR_ALL_ORGANIZATION_UNITS), enabling role definitions to be scoped appropriately within a multi-organization implementation. While the provided metadata does not list all columns, typical supplementary columns would include descriptive fields, effective dates, and creation/modification audit information.

Common Use Cases and Queries

This table is central to administrative setup, reporting, and troubleshooting within the PQH module. Common operational scenarios include auditing the list of configured roles, identifying roles associated with specific business groups, and diagnosing workflow routing issues. A fundamental query retrieves all active roles for a given business group:

SELECT role_id, role_name FROM pqh_roles WHERE business_group_id = &bg_id ORDER BY role_name;

For integration or data validation purposes, a join to the organization table is frequently used:

SELECT pr.role_name, hou.name business_group FROM pqh_roles pr, hr_all_organization_units hou WHERE pr.business_group_id = hou.organization_id;

Analytical reporting often involves this table to understand the structure of approval hierarchies and security assignments across the enterprise.

Related Objects

The PQH_ROLES table maintains defined foreign key relationships with several other PQH tables, illustrating its central role in the position control schema. These relationships are: