Search Results full_refresh

Overview

HRI_OPL_SUP_STATUS_HST is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Oracle HR Intelligence (HRI) product family, which supplies the extract, transformation, and loading infrastructure behind Oracle HRMS analytics and workforce reporting. As implied by its name, the package maintains the history of supervisor status assignments — that is, the record of which supervisor relationship was active for a worker over a given period. The public package body is declared with AUTHID CURRENT_USER, so it executes with the privileges of the calling user, a convention typical of HR Intelligence maintenance utilities that are invoked from concurrent programs rather than from direct session code. The package has no documented API classification beyond OTHER, indicating it is treated as an internal maintenance component rather than a published integration interface.

Key Procedures and Functions

The package defines the following documented procedures:

• FULL_REFRESH — Rebuilds supervisor status history for the requested date range. One overloaded form accepts the dates as VARCHAR2 (suited to concurrent program parameters), and a second overload accepts them as DATE. It supports an optional debugging flag.
• INCREMENTAL_UPDATE — Applies only the changes that have occurred since the last processing run, again offered in both a VARCHAR2 parameter form and a DATE parameter form. This is the routine used for routine, low-cost refresh cycles.
• FIND_CHANGED_SUPERVISORS — Identifies supervisors whose status or assignment has changed, producing the working set that drives the incremental update logic.
• RUN_REQUEST — A concurrent-program entry point that accepts a start date, end date, a refresh-mode flag, and a debugging flag, then dispatches to either the full refresh or the incremental update path. Its standard errbuf/retcode signature confirms it is designed to be registered as a concurrent executable.

All four procedures are documented in the ETRM metadata; their parameter lists beyond those shown in the package header should not be assumed.

Tables Accessed

The package reads and writes a mix of HR Intelligence summary tables and Oracle HRMS transactional tables:

• HRI_CL_WKR_SUP_STATUS_ASG_CT, HRI_CL_WKR_SUP_STATUS_CT, HRI_EQ_SPRVSR_HSTRY_CHGS, and HRI_MB_ASGN_EVENTS_CT — HR Intelligence collection/change tables that store the derived supervisor status history and the change events used to detect deltas.
• PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES, PER_PERIODS_OF_PLACEMENT, and PER_PERIODS_OF_SERVICE — the source of truth for assignment, status, placement, and service dates from which supervisor status history is derived.
• FND_NEW_MESSAGES — used to communicate processing messages and errors back to the requesting session.

Usage Notes

HRI_OPL_SUP_STATUS_HST is normally invoked through the RUN_REQUEST entry point registered as a concurrent program in Oracle HRMS, where the full refresh is scheduled periodically and the incremental update runs on a shorter cycle. Because it is referenced by one other package in the ETRM metadata, changes to its behavior can affect dependent HR Intelligence logic. Custom code should call the package only with valid date ranges and should not assume the VARCHAR2 overloads are interchangeable with the DATE overloads.