Search Results pqh_cbr_engine




Overview
Explore in AI Chat

Overview

PQH_CBR_ENGINE is an Oracle Application Object Library (APPS) schema PL/SQL package that implements the Criteria-Based Rules (CBR) evaluation engine for Oracle Human Resources and Oracle Payroll. Its role is to apply configurable business rules — sets of attribute-defined conditions — against HR and budgeting data, and to determine whether a given condition is satisfied. In practice the package supports the rule-driven logic used by budget pools, budget versions, and position/budget reallocation processes, where the outcome of one or more rules governs how funds are allocated, reallocated, or validated during transactional processing.

Within Oracle EBS, Criteria-Based Rules allow organizations to express eligibility, allocation, and validation logic declaratively rather than through hard-coded customizations. PQH_CBR_ENGINE is the runtime component that reads the rule definitions stored in the PQH_RULES, PQH_RULE_SETS, and PQH_RULE_ATTRIBUTES tables, resolves attribute values against the transactional context, and returns a pass/fail result. The package is classified as OTHER rather than a published open interface, meaning it is an internal engine consumed by other application modules rather than a supported external API.

Key Procedures and Functions

The ETRM documentation lists thirteen documented procedures and functions. Grouped by purpose:

Parameter lists are not documented in the metadata and are intentionally omitted here.

Tables Accessed

PQH_CBR_ENGINE reads and writes the following tables via APPS synonyms. Rule configuration is sourced from PQH_RULES, PQH_RULE_SETS, PQH_RULE_ATTRIBUTES, and PQH_ATTRIBUTES. Budget context is drawn from PQH_BUDGETS, PQH_BUDGET_POOLS, PQH_BUDGET_PERIODS, PQH_BUDGET_VERSIONS, and PQH_BDGT_POOL_REALLOCTIONS. Organisational structure resolution uses PER_ORG_STRUCTURE_ELEMENTS, PER_ORG_STRUCTURE_VERSIONS, and PER_SHARED_TYPES, while PER_TIME_PERIODS supplies date-period information and HR_ALL_POSITIONS_F supplies position data. FND_NEW_MESSAGES is used for Oracle Application Framework message handling, enabling the engine to raise or retrieve user-facing error messages. The package is referenced by PQH_BDGT_REALLOC_UTILITY and by itself recursively.

Usage Notes

PQH_CBR_ENGINE is an internal engine rather than a directly callable public interface. It is invoked indirectly through Oracle HR/Payroll budget and position allocation processes, most notably by PQH_BDGT_REALLOC_UTILITY, and its CBR evaluation logic is typically triggered from the budget reallocation concurrent program and related forms. Because the package name appears in the ETRM dependency documentation, it is sometimes diagnosed during troubleshooting of budget reallocation or rules-based allocation errors. Custom code should not call results-dependent internals directly, as signatures are not assured across patch levels; any extension should instead rely on standard budget or rule APIs. The VALID status in 12.1.1 and 12.2.2 indicates the package is compiled and current in both releases.