Search Results pqh_rule_sets




Overview
Explore in AI Chat

Overview

PQH_RULE_SETS is a table in the HR schema of Oracle E-Business Suite, belonging to the PQH (Public Sector HR) product family. It stores definitions of rule sets, each of which is a container for one or more configurable business rules. In the Oracle EBS framework, rule sets provide the grouping mechanism through which the rules engine evaluates business logic at runtime — for example, determining eligibility, approval routing, or process branching within Public Sector HR flows. A rule set can be scoped to an organization, a business group, or an organization structure, and can also reference another rule set, allowing hierarchical or reuse-oriented composition of rule logic.

From a dimensional modeling perspective, the ETRM metadata classifies this object as satellite-leaning based on its foreign key structure. The table's identity is anchored by a surrogate primary key, while its attributes (names, categorization, applicability, status) describe behavior and scope. This suggests it is best modeled as a satellite attached to an organizational or business-group hub rather than as a standalone hub or a pure link table.

Key Information Stored

The table documents 20 columns in the ETRM 12.2.2 physical schema. The most significant are:

Common Use Cases and Queries

Rule sets are typically queried when auditing or troubleshooting rule evaluation, and when reporting on which rules apply to a given organization or business group.

  • Listing active rule sets for an organization: 
    SELECT rule_set_id, rule_set_name, short_name, rule_category
FROM   pqh_rule_sets
WHERE  organization_id = :org_id
AND    status = 'A';
  • Finding the rules within a set by joining to PQH_RULES on RULE_SET_ID.
  • Resolving rule-set inheritance chains by following REFERENCED_RULE_SET_ID recursively.
  • Distinguishing seeded versus custom rule sets for upgrade-impact analysis using SEEDED_RULE_FLAG.
  • Reporting on rule applicability by RULE_LEVEL_CD and RULE_APPLICABILITY to identify configuration coverage across business groups.

Related Objects

  • PQH_RULES — the primary dependent table; joins via PQH_RULES.RULE_SET_ID = PQH_RULE_SETS.RULE_SET_ID. Each rule set owns one or more rules.
  • PQH_RULE_SETS (self) — joined via REFERENCED_RULE_SET_ID to resolve inheritance and reuse.
  • HR_ALL_ORGANIZATION_UNITS — joined via ORGANIZATION_ID and BUSINESS_GROUP_ID for organizational scope.
  • PER_ORGANIZATION_STRUCTURES — joined via ORGANIZATION_STRUCTURE_ID for hierarchy scope.
  • PQH_RULE_SETS_PK / PQH_RULE_SETS_UK — the primary and unique indexes enforcing identity and business-key uniqueness (both include ZD_EDITION_NAME).