Search Results ben_determine_activity_base_rt




Overview
Explore in AI Chat

Overview

BEN_ICM_LIFE_EVENTS is an Oracle EBS Advanced Benefits (OLM/OCM) PL/SQL package owned by the APPS schema. Its business purpose is to manage the implicit life event rules that govern when a participant's eligibility for a benefit offering must be re-evaluated. "ICM" in the package name refers to Implicit Context Manager, the engine component within Oracle Advanced Benefits that detects and processes life events and other implicitly tracked conditions affecting enrollment. In the context of Oracle EBS 12.1.1 and 12.2.2, this package works alongside the eligibility and activity base determination logic to trigger recalculation of benefits elections when a person's circumstances change.

The package is classified as OTHER in the ETRM metadata, meaning it is not a formally published public API but rather an internal component invoked by other Advanced Benefits packages. Its status is VALID, indicating it is compiled and active in the E-Business Suite instance from which the metadata was extracted.

Key Procedures and Functions

The documented interface exposes a single procedure, P_MANAGE_ICM_LIFE_EVENTS. As the name indicates, this procedure orchestrates the management of ICM-related life event processing. It is responsible for evaluating the life event definitions relevant to a participant and coordinating the dependent eligibility recalculations. Consistent with its internal classification, the procedure is typically called from within larger benefits processing flows rather than directly by end users. The procedure embodies the core logic that other packages—particularly BEN_DETERMINE_ACTIVITY_BASE_RT and BEN_DETERMINE_ELIGIBILITY2—rely upon when determining whether a life event has occurred and what impact it has on the participant's benefit activity bases and eligibility.

Tables Accessed

According to the documented metadata, BEN_ICM_LIFE_EVENTS references the following tables, most through APPS synonyms:

  • BEN_ELIG_PER_F — the eligibility profile rules used to evaluate whether a person qualifies under a given life event.
  • BEN_ELIG_PER_OPT_F — eligibility profile options that refine profile evaluation criteria.
  • PER_ALL_ASSIGNMENTS_F — assignment records providing the HR context for the participant.
  • BEN_ACTY_BASE_RT_F — activity base rates, reflecting the calculated base amounts that life events can alter.
  • BEN_ICD_CHC_RATES and BEN_ICD_CHC_RATES_S — rate tables supporting benefit calculation and currency-related processing.
  • BEN_OIPL_F and BEN_PL_F — plan and offering participation data.
  • DUAL and PLITBLM — standard utility constructs used for control-flow and PL/SQL table operations.

Collectively these reads supply the eligibility, enrollment, and assignment state required to decide whether life event processing should fire.

Usage Notes

BEN_ICM_LIFE_EVENTS is referenced by two other packages, with BEN_DETERMINE_ACTIVITY_BASE_RT appearing twice in the dependency chain alongside BEN_DETERMINE_ELIGIBILITY2 and BEN_ICM_LIFE_EVENTS itself (a self-reference typical of recursive or internal calls). This dependency pattern confirms that the package is invoked indirectly during activity base rate determination and eligibility processing—typically triggered by the Advanced Benefits concurrent programs that run life event batches, or from Oracle Forms actions in the Benefits workbench when a life event is entered or detected.

Because the package is not classified as a public API, custom integrators should exercise caution before calling P_MANAGE_ICM_LIFE_EVENTS directly. Instead, the recommended approach is to drive life event processing through the supported Advanced Benefits concurrent programs and enrollment flows, allowing BEN_DETERMINE_ACTIVITY_BASE_RT and BEN_DETERMINE_ELIGIBILITY2 to invoke BEN_ICM_LIFE_EVENTS in the intended sequence. When troubleshooting, DBMS_OUTPUT tracing and the standard EBS diagnostics on the calling packages are the practical means of observing this module's behavior during life event processing runs.