Search Results hri_oltp_pmv_dynamic

Overview

APPS.HRI_OLTP_PMV_DYNAMIC is a valid PL/SQL package body in the APPS schema that belongs to the Oracle HRMS Intelligence (HRI) family of objects. Its name reflects its role within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments: it supplies dynamic, parameter-driven data extraction logic for Oracle HRMS Intelligence (formerly Oracle HR Intelligence and Daily Business Intelligence) reporting. The package supports the HRMS Intelligence "Page/Record" and metric infrastructure by resolving runtime filter criteria, such as organization hierarchies, supervisor hierarchies, and date ranges, into executable SQL.

The package is classified as OTHER in the ETRM metadata, meaning it is an internal, non-public API rather than an officially supported customer extension point. It forms part of the internal machinery that translates user-selected dashboard and analytics parameters into query results for workforce metrics.

Key Procedures and Functions

The 12.1.1 documentation records 47 procedures and functions. The visible subset indicates a strong concentration on workforce time-to-fill, time-to-hire, and vacancy-ageing analytics, expressed as paired variants that either aggregate by organization hierarchy (suffix _ORGH) or by supervisor hierarchy (suffix _SUPH).

• Vacancy ageing functions — VACANCY_AGEING_SUPH and VACANCY_AGEING_ORGH compute how long requisitions or vacancies have remained open, scoped either through supervisory reporting lines or organizational structures.
• Time-to-fill metrics — VAC_TIME_TO_FILL_ORGH, VAC_TIME_TO_FILL_SUPH, APL_TIME_TO_FILL_ORGH, and APL_TIME_TO_FILL_SUPH measure the elapsed duration from vacancy or applicant stage to the filled position, split by the two hierarchy modes.
• Time-to-hire metrics — VAC_TIME_HIRE_ORGH, VAC_TIME_HIRE_SUPH, APL_TIME_HIRE_ORGH, APL_TIME_HIRE_SUPH, TIME_TO_HIRE_ORGH, TIME_TO_HIRE_ORGH_1, TIME_TO_HIRE_ORGH_2, and TIME_TO_HIRE_SUPH calculate the interval from requisition creation or application receipt to the hire event. The numbered ORGH variants (TIME_TO_HIRE_ORGH_1 and _2) represent staged or alternate computation variants of the same metric.
• Accept-to-hire metrics — APL_ACCPT_HIRE_ORGH, APL_ACCPT_HIRE_SUPH, VAC_ACCPT_HIRE_ORGH, VAC_ACCPT_HIRE_SUPH, TIME_ACCPT_HIRE_ORGH, and TIME_ACCPT_HIRE_SUPH quantify the duration between offer acceptance and hire, again differentiated by applicant versus vacancy starting points.

Tables Accessed

The documented dependency list identifies BIS_PMV_PAGE_PARAMETER_TBL as an external table referenced by this package. This table belongs to the Oracle Business Intelligence System (BIS) Page/Record framework and stores page-level parameter definitions, including parameter names, prompts, default values, and filter bindings. HRI_OLTP_PMV_DYNAMIC reads these definitions to construct dynamic SQL at runtime. Because the package operates primarily by emitting SQL rather than querying fixed HR tables directly, its principal internal dependency is HRI_OLTP_PMV_DYNSQLGEN, the companion package that generates the SQL fragments consumed by the dynamic engine. STANDARD supplies the base PL/SQL package facilities. No other database objects reference HRI_OLTP_PMV_DYNAMIC, confirming its position as a leaf-level, internally consumed component.

Usage Notes

APPS.HRI_OLTP_PMV_DYNAMIC is not customer-invocable in the supported sense; it is referenced only by the HRMS Intelligence dashboard and analytics framework. Typical invocation occurs when a user opens an HRMS Intelligence dashboard, applies organization or supervisor hierarchy filters, and the page framework calls the package to resolve parameters and generate the corresponding metric SQL. This requires the caller to supply a parameter set consistent with BIS_PMV_PAGE_PARAMETER_TBL, which is why the ORGH and SUPH variants exist as separate entry points.

In both 12.1.1 and 12.2.2, the package is delivered as part of the HRI product topology and remains VALID under normal patch levels. Custom code should avoid direct calls, as signatures are unversioned and subject to change during Oracle patching. Release 12.2.2 retains the same functional design; differences relate primarily to underlying table and view implementation rather than to this dynamic resolution layer. Administrators should treat reports of invalid status or compile errors against this package as indicators of a broader HRMS Intelligence installation or patching issue.