Search Results ben_determine_eligibility2




Overview
Explore in AI Chat

Overview

The APPS.BEN_DETERMINE_ELIGIBILITY2 package is a core PL/SQL component within the Oracle E-Business Suite Advanced Benefits (Oracle Benefits) module. It operates as part of the benefits eligibility engine, providing the procedural logic required to evaluate whether a participant, dependent, or other eligible party qualifies for a given program, plan, or plan option. In EBS 12.1.1 and 12.2.2, eligibility processing is driven by configurable eligibility profiles, life event rules, and participation rules rather than by hard-coded logic. BEN_DETERMINE_ELIGIBILITY2 serves as the orchestration layer that coordinates these evaluations, invoking subordinate routines to derive eligibility facts, assess profile criteria, and apply life event outcomes.

The package is classified under ETRM as an "OTHER" API and is documented with the VALID status in the APPS schema. It is a dependent object within a tightly coupled Benefits call stack, and it is referenced by BEN_DETERMINE_ELIGIBILITY as well as recursively by itself, indicating a layered or iterative evaluation design. It further depends on BEN_DERIVE_PART_AND_RATE_FACTS, BEN_EVALUATE_ELIG_PROFILES, BEN_MANAGE_LIFE_EVENTS, BEN_PER_IN_LER, and HR_UTILITY.

Key Procedures and Functions

The documented interface for this package consists of a single procedure:

  • CHECK_PREV_ELIG — Evaluates whether a participant has a prior eligibility determination, allowing the eligibility engine to consider previously established eligibility or ineligibility results when resolving the current determination. This supports continuity logic across life events and enrollment periods, preventing redundant recomputation and preserving historical eligibility outcomes where appropriate.

No additional formal parameters are documented in the ETRM metadata; the procedure should be treated as an internal helper routine whose signature is subject to change and should not be invoked directly by custom code.

Tables Accessed

The package reads and writes a broad set of Benefits configuration and transactional tables, resolved through APPS synonyms:

Usage Notes

BEN_DETERMINE_ELIGIBILITY2 is not a public, supported API for direct customer invocation. It is called within the Benefits eligibility engine, typically initiated from the Benefits enrollment and life event processing flows — including the concurrent processes that recalculate eligibility after a life event or during open enrollment — and indirectly from Oracle Benefits self-service forms. It appears in the dependency chain beneath BEN_DETERMINE_ELIGIBILITY, which is the more commonly referenced entry point in customizations. Custom code should generally call the higher-level eligibility APIs rather than this package. Because the package references the _F date-tracked tables, any direct invocation must respect effective dating and the BUSINESS_GROUP_ID context. Given its VALID status and its dependency on multiple core Benefits packages, modifications or direct calls should be validated against Oracle Support guidance, as the interface is Oracle proprietary and confidential.