Search Results save_user_preference




Overview
Explore in AI Chat

Overview

HRKPI is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. In EBS 12.1.1 and 12.2.2 it sits within the Oracle HRMS (Human Resources Management System) technology stack and is classified in the ETRM repository under the generic category OTHER, meaning it is not exposed as a formally published public API. Its name suggests a Human Resources Key Performance Indicator role, and the package behaves as an internal utility supporting KPI-driven integration and event handling: it can issue requests, parse inbound responses, enumerate available adapters, surface events, persist user preferences, and run a self-test routine. The package is currently documented with a VALID status and depends on APPS objects HR_EXTLIB_EVT_TAB_T and HR_NVPAIR_TAB_T, plus the SYS-owned STANDARD package. It is not referenced by any other documented package, indicating it functions as a leaf-level consumer rather than a shared library.

Key Procedures and Functions

ETRM documents six callable units within HRKPI. Parameter lists are not published and should not be assumed.

  • REQUEST — Initiates an outbound KPI or adapter request, servicing the interaction with an external or internal data source.
  • PARSERESPONSE — Consumes the payload returned from a request and decodes it into the structures used internally by the package.
  • GETADAPTERS — Returns the set of adapters available to the KPI framework, allowing callers to enumerate supported integration endpoints.
  • GETEVENTS — Retrieves events surfaced by the KPI subsystem, which are held in the HR_EXTLIB_EVT_TAB_T collection type.
  • SAVE_USER_PREFERENCE — Persists operator-specific settings so that KPI configuration is retained across sessions.
  • TEST — Executes a diagnostic or smoke-test routine to verify package health and dependency resolution.

Tables Accessed

The documented table references are limited. HRKPI accesses DBMS_JAVA, DUAL, and PLITBLM through APPS synonyms. DUAL is used for singleton SELECT operations required by PL/SQL control flow and validation logic. DBMS_JAVA indicates the package relies on Java stored procedures or the Oracle JVM, consistent with an adapter/response-parsing mechanism that may delegate serialization or transformation work to Java. PLITBLM is the Oracle-supplied PL/SQL table of PL/SQL tables, and its presence suggests indexed, in-memory collection handling rather than direct DML against HR business tables. Additionally, the dependency list confirms use of the collection types HR_EXTLIB_EVT_TAB_T and HR_NVPAIR_TAB_T, which carry event records and name-value pairs respectively, plus the SYS.STANDARD package that is implicitly available to all PL/SQL units. No base HR or KPI transaction tables are documented as directly read or written.

Usage Notes

HRKPI is not a documented public interface and carries no entry in the list of packages referencing it. It is therefore normally invoked indirectly—through HRMS self-service or professional forms, through concurrent programs that wrap KPI refresh or event processing, or through custom code that calls the APPS.HRKPI package directly for integration, testing, or preference management. The GETEVENTS and GETADAPTERS routines are the most likely candidates for direct custom invocation, while TEST is intended primarily for diagnostics during patching or troubleshooting. Because the package is classified as OTHER and lacks published parameter contracts, customizations should treat its signatures as unstable across patches and should prefer supported HRMS APIs where they exist. Oracle marks the underlying documentation as proprietary and confidential.