Search Results hri_opl_ben_dim_refresh




Overview
Explore in AI Chat

Overview

The APPS.HRI_OPL_BEN_DIM_REFRESH package belongs to the Oracle Human Resources Intelligence (HRI) family of objects that support the Oracle Daily Business Intelligence (DBI) and Operational Performance Management (OPM) reporting layer for Oracle E-Business Suite. Its specific responsibility is to refresh the benefit dimension data used by the OPL (Operational Performance) star-schema repository. In that architecture, transaction-level benefit and enrollment facts are consolidated against conformed dimension tables so that reporting, trending, and analytical comparisons remain consistent across reporting periods.

The package name encodes this role: "HRI" identifies the HR Intelligence schema, "OPL" identifies the operational performance collection, "BEN" denotes the Benefits product family, and "DIM_REFRESH" indicates that the unit's purpose is to load and rebuild benefit dimension rows rather than to post transactional facts. It is owned by APPS and is classified in the ETRM repository as OTHER, signifying that it is an internal utility package rather than a public, supported integration API. It is not referenced by any other package, confirming that it is intended to be driven directly by the collection infrastructure or an administrative caller.

Key Procedures and Functions

The package exposes two documented overloads, both named LOAD:

  • LOAD (p_full_refresh) — The programmatic entry point. It accepts a refresh-mode indicator and performs the dimension load for the benefit collections. It is designed to be called directly from PL/SQL when the caller requires control over refresh behavior without concurrent-program error handling.
  • LOAD (errbuf, retcode, p_full_refresh) — The concurrent-program entry point. It follows the standard Oracle EBS concurrent manager signature, returning status through errbuf and retcode while accepting the same refresh-mode parameter. This overload allows the routine to be registered and executed as a concurrent program, with outcomes surfaced to the request log.

The p_full_refresh parameter governs whether the collection is rebuilt in its entirety or refreshed incrementally; the documented header does not enumerate accepted literal values, so callers should treat it consistently with other HRI refresh utilities.

Tables Accessed

The package reads from the base Benefits dimension and derived fact tables, including BEN_PL_F and BEN_PL_TYP_F (plan and plan type), BEN_PGM_F (program), BEN_PTIP_F (plan type in program), BEN_PLIP_F and BEN_OIPLIP_F (plan-in-program and option-in-plan-in-program), and BEN_OIPL_F (option-in-plan). Enrollment and eligibility context is drawn from BEN_ENRT_PERD, BEN_POPL_ENRT_TYP_CYCL_F, and BEN_POPL_RPTG_GRP_F. These source rows are transformed and written into the HRI collection tables HRI_CS_COMPOBJ_CT and its staging counterpart HRI_CS_COMPOBJ_CT_S, together with the pre-aggregated collection tables HRI_CS_CO_PGM_CT, HRI_CS_CO_PGMH_PLIP_CT, and HRI_CS_CO_PGMH_PTIP_CT.

Usage Notes

Because the package is an internal collection utility, it is normally invoked by the DBI/OPM collection framework or scheduled as a concurrent program rather than called from form logic. Administrators may submit the concurrent-program overload when a targeted benefit dimension rebuild is required after configuration changes to plans, programs, or enrollment periods. Custom code should avoid a hard dependency on this package; a full collection run is the supported path. Because the object is documented as OTHER and referenced by no other package, its public signatures are effectively frozen but not part of the supported integration surface, and it should be treated as subject to change across releases.