Search Results get_kpi




Overview
Explore in AI Chat

Overview

APPS.HRI_OLTP_PMV_WMV_WF_SUP is an Oracle E-Business Suite PL/SQL support package belonging to the Oracle HR Intelligence (HRI) product family, specifically the OLTP Performance Management Viewer (PMV) subsystem. Its name indicates its role: it supplies the SQL generation logic for a Workforce Management (WMV) performance indicator that depends on Oracle Workflow (WF) data. The package acts as a "supplier" or helper for the PMV engine, which renders configurable KPI dashboards and balanced scorecards from the HR Intelligence data warehouse and transactional HRMS schema. It does not maintain business data itself; rather, it is a query-provider component that returns dynamically constructed SQL and result-shaping metadata to the PMV framework at runtime.

This package originates from an older release generation, as shown by the header revision hriopwfs.pkh 120.0 2005/06/24, indicating the publicly shipped specification has remained stable across EBS 12.1.1 and 12.2.2. The API classification is recorded as OTHER, meaning it is not part of a formally published, supported public API surface, and Oracle does not guarantee backward compatibility of its signature.

Key Procedures and Functions

The package specification exposes exactly two procedures, both required by the PMV customization contract:

  • GET_KPI — Generates the SQL and associated output attributes used to produce a KPI (key performance indicator) result for the Workflow-related Workforce Management metric. The PMV page passes its parameter table, and the procedure returns custom SQL plus query attribute metadata for rendering.
  • GET_SQL — A closely related routine that returns the SQL text and query attribute definitions for the same subject area, typically used when the framework needs the underlying query without the KPI-specific wrapping logic.

Both procedures follow the standard PMV supplier pattern: they accept a page parameter table and emit a custom SQL string together with an attribute table that describes columns, formats, and drill-down behaviour. The documented signature confirms this contract, with parameters typed as BIS_PMV_PAGE_PARAMETER_TBL, BIS_QUERY_ATTRIBUTES_TBL, and a VARCHAR2 SQL output. No additional public functions or global variables are declared.

Tables Accessed

The package references a single documented table through APPS synonyms: PLITBLM. This is the PL/SQL internal table used to store and manipulate multi-line SQL text (the "PL/SQL Interface Table, Line, Multi-line" structure). Its presence confirms that the package builds SQL statements piece by piece at runtime and passes the assembled text back to the PMV engine. The metadata records no direct business-table access from this package; all workforce and workflow data retrieval is deferred to the dynamically generated SQL executed by the calling framework.

Usage Notes

HRI_OLTP_PMV_WMV_WF_SUP is invoked indirectly by the Oracle HR Intelligence PMV runtime whenever the relevant Workforce Management KPI or report page is rendered. It is not called from standard Oracle Forms or concurrent programs directly and is not referenced by any other documented package, giving it zero inbound dependencies. Because it falls under the OTHER API classification, it should be treated as an internal implementation detail. Customizations should avoid direct calls to GET_KPI or GET_SQL and should instead extend PMV behaviour through supported personalization and KPI configuration mechanisms. Any modification to the package body risks invalidating dependent PMV pages and is unsupported.