Search Results pqh_roles_pk

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:

• HR_ALL_ORGANIZATION_UNITS: Linked via PQH_ROLES.BUSINESS_GROUP_ID to scope roles to a business group.
• PQH_ROLE_EXTRA_INFO: Linked via PQH_ROLE_EXTRA_INFO.ROLE_ID to store additional attributes for a role.
• PQH_ROLE_TEMPLATES: Linked via PQH_ROLE_TEMPLATES.ROLE_ID to define role-based templates.
• PQH_ROUTING_CATEGORIES: Linked via PQH_ROUTING_CATEGORIES.OVERRIDE_ROLE_ID to define an override role for a routing category.
• PQH_ROUTING_HISTORY: Linked via both FORWARDED_TO_ROLE_ID and FORWARDED_BY_ROLE_ID to log the roles involved in routing a transaction.
• PQH_ROUTING_LIST_MEMBERS: Linked via PQH_ROUTING_LIST_MEMBERS.ROLE_ID to assign individuals or other roles as members of a routing list role.