Results for “ben_determine_eligibility”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BEN_DETERMINE_ELIGIBILITY is a PL/SQL package within the Oracle E-Business Suite Advanced Benefits (OAB) module. Its primary business function is to evaluate and determine the eligibility profiles, participation eligibility, and derived eligibility rules applicable to a person, assignment, or dependent within a benefits program. In the Oracle Benefits architecture, eligibility determination is the process by which the application decides whether a given participant (or potential participant) qualifies for a benefit plan, program, or option based on configured eligibility profiles, life events, and related criteria. This package acts as a central engine that the Benefits processing framework invokes to resolve those eligibility outcomes during enrollment, life event processing, and periodic eligibility reevaluation.

The package is classified as OTHER in the ETRM metadata, meaning it is not a formally published public API but rather an internal processing package that supports higher-level Benefits functionality. It is validated and present in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes a single procedure:

• DETERMINE_ELIG_PRFLS — The core routine responsible for determining the eligibility profiles that apply to a participant or subject. Its purpose is to evaluate the configured eligibility criteria (such as person, assignment, dependent, and organizational factors) and return or apply the resulting eligibility profile determinations used downstream by enrollment and life event processing. This procedure encapsulates the logic that maps a participant context to the set of qualifying eligibility profiles.

No additional public procedures or functions are documented in the ETRM metadata. The package body additionally contains private/internal logic that supports this determination process, and the package has self-referential dependencies indicating recursive or internal invocation patterns.

Tables Accessed

Based on the documented table references, BEN_DETERMINE_ELIGIBILITY reads from and works with the following core Benefits and HR tables:

• BEN_PER_IN_LER — Person in a life event record, linking participants to life event occurrences that drive eligibility reevaluation.
• BEN_ELIG_PER_F — Eligibility profile person-level definition, the primary configuration of person eligibility criteria.
• BEN_ELIG_DPNT — Dependent eligibility configuration, used when dependents are evaluated.
• BEN_ELIG_TO_PRTE_RSN_F — Maps eligibility profiles to participation reasons, defining why a participant qualifies.
• BEN_PL_F, BEN_PLIP_F, BEN_OIPL_F, BEN_PTIP_F — Plan, plan-in-program, option-in-plan, and plan-type-in-program tables that define the benefit offerings eligibility applies to.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES — Core HR person, assignment, and assignment status data used as eligibility inputs.
• PER_CONTACT_RELATIONSHIPS — Relationship data supporting dependent and contact eligibility evaluation.
• HR_ALL_ORGANIZATION_UNITS, HR_LOCATIONS_ALL — Organization and location attributes used when eligibility profiles include organizational or geographic criteria.
• FF_FDI_USAGES_F — Fast Formula usage definitions, supporting formula-driven eligibility rules.

Usage Notes

BEN_DETERMINE_ELIGIBILITY is invoked internally by the Benefits processing framework rather than called directly by end users. It supports enrollment processing, life event management, and eligibility reevaluation workflows. The metadata indicates that the package is referenced by two other packages, including BEN_MANAGE_LIFE_EVENTS and BEN_DETERMINE_ELIGIBILITY3, confirming its integration into life event and eligibility decision flows.

Custom code or extensions should generally call supported public Benefits APIs rather than invoke DETERMINE_ELIG_PRFLS directly, because the package depends on internal utilities such as BENUTILS, HR_UTILITY, BEN_DERIVE_PART_AND_RATE_FACTS, BEN_COMP_OBJ_FILTER, and BEN_PERSON_OBJECT. When troubleshooting eligibility outcomes in Oracle EBS 12.1.1 or 12.2.2, this package is a key object for tracing how eligibility profiles are resolved during concurrent Benefits processes and online enrollment transactions.