Search Results ben_comp_object




Overview
Explore in AI Chat

Overview

APPS.BEN_COMP_OBJECT is the core object-resolution utility within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite, released under the APPS schema with a VALID status in both 12.1.1 and 12.2.2. Its business purpose is to resolve and materialize "compensation objects" — the eligibility, program, plan, plan-type, option, and rate structures that determine what benefits a participant is entitled to and at what cost. Rather than each Benefits form or concurrent program independently mining the underlying configuration tables, BEN_COMP_OBJECT centralizes the logic for constructing, retrieving, and caching these object hierarchies for a given person, assignment, or eligibility determination. By abstracting this logic, the package enforces consistent interpretation of plan eligibility, enrollment relationships, and rate consolidation across the application.

Key Procedures and Functions

The ETRM metadata documents 23 procedures and functions; four are explicitly named:

  • SET_OBJECT — Populates the in-memory representation of a compensation object for a participant. It drives the derivation of eligibility and the assembly of the associated program, plan, and option context, writing state into the package cache for subsequent retrieval.
  • GET_OBJECT — Returns the previously resolved compensation object. Callers use this to obtain the participant's eligibility and plan context without re-querying the base configuration tables.
  • GET_OBJECT_SET_COBRA — Variant of the retrieval routine tailored to Consolidated Omnibus Budget Reconciliation Act (COBRA) processing. It resolves objects while applying COBRA-specific eligibility and qualified-beneficiary rules, supporting the COBRA continuation-of-coverage business flow.
  • CLEAR_DOWN_CACHE — Invalidates and clears the package's cached object data. It is invoked to force re-resolution when underlying eligibility, enrollment, or configuration data changes during a session.

The remaining documented procedures and functions support the internal mechanics of these four public entry points and are not individually detailed in the ETRM excerpt.

Tables Accessed

BEN_COMP_OBJECT reads a coherent set of Benefits configuration and eligibility tables through APPS synonyms, including BEN_OIPLIP_F, BEN_OIPL_F, BEN_OPT_F, BEN_PGM_F, BEN_PLIP_F, BEN_PL_F, BEN_PTIP_F, BEN_ELIG_PER_F, BEN_PER_IN_LER, BEN_PL_REGN_F, BEN_REGN_F, and PLITBLM. Collectively these supply program definitions, plan and plan-type configuration, option and rate structures, plan-in-program linkages, eligibility criteria, and per-participant eligibility/relationship records. PLITBLM is a PL/SQL index-by table type used for bulk data handling. The package also depends on BEN_CACHE, BEN_ENV_OBJECT, BEN_HASH_UTILITY, and FND_MESSAGE for caching, environment resolution, hashing, and message reporting.

Usage Notes

BEN_COMP_OBJECT is designed as an internal shared service rather than a callable business API (API classification: OTHER). It is exercised indirectly through Oracle Advanced Benefits forms and concurrent programs that display or process participant eligibility, enrollment, and rate information, and it underlies COBRA processing via GET_OBJECT_SET_COBRA. The package is referenced by 16 other packages and is not referenced by any database object, placing it in the upper-middle tier of the Benefits dependency hierarchy. Custom code requiring compensation-object resolution should call these public routines rather than querying the underlying BEN_* tables directly, and must invoke CLEAR_DOWN_CACHE when data changes, because results are cached at the package level for the duration of the session.