Search Results find_sub_event_group_events




Overview
Explore in AI Chat

Overview

HRI_OPL_EVENT_CAPTURE is an HRMS Intelligence (HRMSi) event capture package that interrogates the Oracle E-Business Suite PEM (Public Event Model / HRMSi event management) architecture in a single pass. Its purpose is to identify all events that have occurred which are relevant to the various HRMSi DBI (Daily Business Intelligence) base collections, and to record them for downstream incremental processing. The package is owned by APPS and is classified as OTHER, indicating it is an internal engine component rather than a public end-user API.

The central design construct is the event queue. For each assignment (the primary grain of the process), the package captures a single record per collection that has expressed interest in the event, storing it in the appropriate event queue table. A single business change, such as a supervisor change, may be relevant to multiple collections simultaneously — for example the supervisor hierarchy collection process, the assignment events fact collection, and the supervisor status history collection. In such a case a row is maintained in each of the relevant queue tables for that assignment change, allowing each collection to consume the same source event independently.

Queue maintenance follows an earliest-change rule. If no other change is already recorded for the assignment in the queue, the earliest change for that assignment is inserted. If a row exists with an earlier change date, the package takes no action. If the incoming change pre-dates the existing queue record, the package updates that assignment's record so the change date reflects the earlier value. The source header identifies the file as hrioetcp.pkb version 120.10 (2007/06/14), confirming the package has been shipped and stable across the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

  • RUN_FOR_BG — Background execution entry point for the event capture process, driving capture across the full population rather than a targeted range.
  • RUN_FOR_ASG — Assignment-scoped capture routine, used to process events for a specific assignment or set of assignments.
  • PURGE_QUEUE — Removes processed or obsolete rows from the event queue tables, controlling growth of the queue structures over time.
  • GET_EVENT_GROUP_ID — Resolves the event group identifier used to map and classify captured events for the DBI collections.
  • INTERPRET_ALL_ASGNMNT_CHANGES — Interprets all assignment changes produced by the PEM interrogation pass and determines which collections are interested in each change.
  • FIND_SUB_EVENT_GROUP_EVENTS — Locates subordinate event group events, supporting hierarchical event resolution within a group.
  • EMPTY_EVNTS_CPTR_REFRESH_LOG — Clears the event capture refresh log, typically in preparation for a new capture cycle.
  • FULL_REFRESH — Executes a complete refresh of the event capture collections rather than an incremental pass.
  • DBG — Internal debugging utility used to emit diagnostic information during execution.
  • PROCESS_RANGE — Processes a defined range of assignments or events, enabling chunked or parallelized execution.
  • PRE_PROCESS — Setup and initialization logic executed before the main capture pass.
  • POST_PROCESS — Finalization logic executed after the capture pass completes.

Tables Accessed

The package references a range of HRMSi queue, collection, and control structures through APPS synonyms. The event queue tables HRI_EQ_ASGN_EVNTS, HRI_EQ_SPRVSR_HRCHY_CHGS, HRI_EQ_SPRVSR_HSTRY_CHGS, HRI_EQ_UTL_ABSNC_DIM, HRI_EQ_WRKFC_EVT_MGRH, HRI_EQ_WRKFC_EVT_ORGH, and HRI_EQ_WRKFC_MNTH receive the per-assignment event records for each interested collection. The collection tables HRI_CS_MNGRSC_CT, HRI_CS_ORGH_CT, HRI_CS_SUPH, and the materialized base HRI_MB_ASGN_EVENTS_CT support the DBI base collections the events feed. HRI_ARCHIVE_EVENTS and HRI_ADM_MTHD_ACTIONS and FND_NEW_MESSAGES provide archive and message/action context, while BIS_REFRESH_LOG records refresh activity for the BIS/DBI framework.

Usage Notes

HRI_OPL_EVENT_CAPTURE is not intended for direct customer invocation. It is invoked by the HRMSi incremental event capture process and by the two other packages documented as referencing it, normally through scheduled concurrent programs that call the background and range entry points. Administrators encountering issues should verify that the capture concurrent request has completed and that the event queue tables are being purged regularly. The design document referenced in the package header (hri_lld_base_incremental_event_capture.doc) remains the authoritative source for process flow detail. The user search term "content capture drivers downlaod" does not correspond to any component of this package; there is no driver download associated with HRI_OPL_EVENT_CAPTURE.