Search Results ben_comp_obj_cache_s

Overview

BEN_COMP_OBJECT_LIST is an Oracle Applications (APPS) PL/SQL package body within the Oracle E-Business Suite Advanced Benefits (BEN) module. Its principal business function is to assemble, cache, and maintain the "compensation object list" — the set of benefit objects (plans, programs, plan types, options, eligibility profiles, life events, reporting groups, and rate definitions) that the Benefits engine evaluates when processing enrollment, eligibility, and compensation calculations for a participant. The package acts as a compilation and caching layer, resolving the many configuration tables in Oracle Advanced Benefits into an in-memory list structure that downstream benefits processing routines can consume efficiently.

The object is documented as VALID in the APPS schema under ETRM 12.2.2 and is classified as an OTHER API. It is not referenced by any database object, indicating that it functions as a high-level orchestration package rather than a reusable dependency. It does, however, depend on a substantial number of core Benefits tables and packages, including the BEN_COMP_OBJ_CACHE family of objects, which the user search term "ben_comp_obj_cache_row_s" directly targets.

Key Procedures and Functions

ETRM documents four procedures/functions in this package body:

• INIT_COMP_OBJECT_LIST_GLOBALS — Initializes the package-level global variables and in-memory structures used throughout the session. This establishes the working state for building and refreshing the compensation object list.
• FLUSH_MULTI_SESSION_CACHE — Clears the multi-session cache associated with the compensation object list. This supports multi-session scenarios (e.g., batch or concurrent workloads) where stale cache entries must be purged between processing runs.
• BUILD_COMP_OBJECT_LIST — The core routine that assembles the compensation object list from the underlying Benefits configuration tables and populates the cache structures, including BEN_COMP_OBJ_CACHE, BEN_COMP_OBJ_CACHE_ROW, and the _S (sequence/number) variants referenced in the user's search term.
• BUILD_GSP_RATE_SYNC_COOBJ_LIST — Builds the compensation object list specifically in support of Generalized Salary Plan (GSP) rate synchronization, coordinating rate definitions with the object list.

Tables Accessed

The package reads from a broad set of Benefits configuration tables via APPS synonyms, including BEN_ACTY_BASE_RT_F, BEN_ACTY_VRBL_RT_F, BEN_ELIGY_PRFL_F, BEN_LER_F, BEN_OIPLIP_F, BEN_OIPL_F, BEN_OPT_F, BEN_PGM_F, BEN_PLIP_F, and BEN_PL_F. These provide activity rates, eligibility profiles, life events, option/plan-in-program relationships, programs, and plans. BEN_ENRT_PERD and the year-period tables supply enrollment period context. The BEN_COMP_OBJ_CACHE, BEN_COMP_OBJ_CACHE_ROW, BEN_COMP_OBJ_CACHE_ROW_S, and BEN_COMP_OBJ_CACHE_S tables receive the assembled cache output, with the _S variants holding sequence-keyed entries. Additional dependencies include HR_LOOKUPS, HR_UTILITY, FND_MESSAGE, PER_ALL_ASSIGNMENTS_F, and PER_ALL_PEOPLE_F for participant data and lookups.

Usage Notes

BEN_COMP_OBJECT_LIST is invoked indirectly during Oracle Advanced Benefits processing rather than being called directly by end users. It is referenced by four other packages and is typically triggered when the Benefits engine prepares compensation objects for enrollment or eligibility evaluation. Because it manages both a session-level and a multi-session cache, it is relevant to batch and concurrent-program scenarios, where the FLUSH_MULTI_SESSION_CACHE routine must be called to avoid stale data between runs. Custom code should not call the internal build routines without first invoking INIT_COMP_OBJECT_LIST_GLOBALS to establish proper session state. The package supports GSP rate synchronization through its dedicated build routine, reflecting its role in coordinating compensation object data across Benefits features.