Search Results run_for_asg




Overview
Explore in AI Chat

Overview

The APPS.HRI_OPL_ASGN_EVENTS package belongs to the Oracle HRMS intelligence and workforce analytics layer within Oracle E-Business Suite. It serves as a batch processing engine for assignment event data, converting raw assignment and workforce event records into the aggregated, dimensional structures used by Oracle HRMS analytics and Oracle Learning Management reporting. The package is classified as OTHER in ETRM, indicating that it is an internal, non-public API rather than a supported interface for customer extensions. It is typically scheduled or invoked as part of a larger data-refresh pipeline that populates the HRI_* tables, which underpin workforce intelligence dashboards, headcount and turnover analytics, and supervisor hierarchy reporting. It is valid in both 12.1.1 and 12.2.2, where its structure and dependencies remain consistent.

Key Procedures and Functions

Five documented program units comprise the package:

  • SHARED_HRMS_DFLT_PRCSS — establishes shared default processing behaviour used across the package's execution, providing common setup or fallback logic invoked by the main processing entry points.
  • PRE_PROCESS — performs preparatory work before the main event-processing loop, such as clearing staging structures or initialising runtime state for a run.
  • PROCESS_RANGE — the core worker that processes a defined range of assignment event records, transforming source rows into the target analytics tables.
  • POST_PROCESS — finalises a run after the range processing completes, handling consolidation, cleanup, or derived updates.
  • RUN_FOR_ASG — a targeted entry point allowing processing to be scoped to a specific assignment, used for isolated or incremental recalculation rather than a full batch.

These units follow the conventional pre-process / process / post-process batch pattern common in HRMS payroll and intelligence packages.

Tables Accessed

Through APPS synonyms the package reads and writes a number of HRI_*, HRI_EQ_*, HRI_CS_* and HRI_MB_* tables. The HRI_EQ_ASGN_EVNTS and related HRI_EQ_WRKFC_EVT, HRI_EQ_WRKFC_EVT_MGRH, HRI_EQ_WRKFC_EVT_ORGH and HRI_EQ_WRKFC_MNTH tables hold extracted assignment events and their manager-hierarchy and organisation-hierarchy aggregations. The HRI_CS_* tables (HRI_CS_SUPH, HRI_CS_ORGH_CT, HRI_CS_POW_BAND_CT, HRI_CS_PRSNTYP_CT) provide cached dimension counts for supervisor hierarchy, organisation hierarchy, pay bands and person types. The HRI_MB_ASGN_EVENTS_CT and HRI_MB_ASGN_EVENTS_CT_S tables hold the materialised assignment-event analytics and sequencing data, while HRI_ADM_MTHD_ACTIONS stores administrative method actions. PAY_ELEMENT_TYPES_F supplies element definitions required for assignment-level grouping, and FND_NEW_MESSAGES is used for message construction.

Usage Notes

HRI_OPL_ASGN_EVENTS is an internal utility. It is referenced by no other documented packages and is not exposed through standard forms, so it is generally invoked from concurrent programs or scheduled batch jobs associated with HRMS intelligence collection. Because it manipulates HRI_* analytics tables directly, direct custom calls are discouraged; any extension should follow the standard pre-process, process-range, post-process sequence to preserve data integrity across the dependent dimension and materialisation tables.