Search Results ben_comp_obj_cache_row_pk

Overview

BEN_COMP_OBJ_CACHE_ROW is a table in the BEN (Advanced Benefits) product schema of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. Its documented description is "Contents of compensation object cache." The compensation object cache is the runtime mechanism by which Oracle Advanced Benefits stores the evaluated results of compensation object definitions—such as program, plan type, plan, and option eligibility—so that eligibility processors, enrollment windows, and rate calculations can reuse computed rows instead of re-evaluating the full object hierarchy on every pass. Each row in BEN_COMP_OBJ_CACHE_ROW therefore represents a single cached compensation object entry belonging to a parent cache header.

The ETRM metadata classifies this table heuristically as standalone under the Data Vault model, meaning it does not present the classic hub-and-link pattern of a shared business key with multiple referencing relationships. From a modeling perspective, it is best treated as a satellite-style cache detail table: it carries descriptive and state attributes tied to a parent cache identifier (COMP_OBJ_CACHE_ID), with no downstream dependents documented.

Key Information Stored

The table contains 23 documented columns. The most significant are summarized below.

• COMP_OBJ_CACHE_ROW_ID — surrogate primary key, enforced by BEN_COMP_OBJ_CACHE_ROW_PK. ETRM lists this as the only unique index/business-key candidate.
• COMP_OBJ_CACHE_ID — foreign key to BEN_COMP_OBJ_CACHE; the parent cache header that this row belongs to.
• PGM_ID, PTIP_ID, PLIP_ID, PL_ID, OIPL_ID, PAR_OPT_ID — the compensation object identity chain: program, program type in program, plan type in program, plan, option in plan, and parent option.
• PAR_PGM_ID, PAR_PTIP_ID, PAR_PLIP_ID, PAR_PL_ID — parent-level object identifiers used when resolving hierarchical or overriding eligibility.
• PL_NIP — identifies whether a plan is a "not in program" variant.
• ELIG_TRAN_STATE — eligibility transition state for the cached row, capturing where the object stands in the eligibility evaluation sequence.
• TRK_INELIG_PER_FLAG — flag controlling whether ineligibility periods are tracked.
• FLAG_BIT_VAL, OIPLIP_FLAG_BIT_VAL, OIPLIP_ID — bit values and option-in-plan-in-program identifiers used for compact flag encoding during processing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit columns.

Common Use Cases and Queries

This table is primarily an internal processing structure. Typical diagnostics involve joining rows back to the parent cache header to understand which objects were cached for a given run.

• Inspecting cached rows for a specific cache: SELECT * FROM ben.ben_comp_obj_cache_row WHERE comp_obj_cache_id = :cache_id;
• Counting cached objects by plan to detect unexpectedly large caches: SELECT pl_id, COUNT(*) FROM ben.ben_comp_obj_cache_row GROUP BY pl_id;
• Reviewing recent activity using the audit columns: SELECT * FROM ben.ben_comp_obj_cache_row WHERE creation_date > SYSDATE - 1;
• Data cleanup or purge verification after a benefits process run terminates abnormally, ensuring orphaned cache rows are removed alongside their parent.

Related Objects

• BEN_COMP_OBJ_CACHE — the parent cache header, joined via COMP_OBJ_CACHE_ID. This is the only documented foreign key relationship.
• BEN_COMP_OBJ_CACHE_ROW_PK — the primary key index on COMP_OBJ_CACHE_ROW_ID, used for direct row retrieval.
• BEN_PGM_F, BEN_PL_F, BEN_OIPL_F, BEN_PTIP_F, BEN_PLIP_F — the compensation object definition tables whose identifiers (PGM_ID, PL_ID, OIPL_ID, PTIP_ID, PLIP_ID) are denormalized into this cache.
• BEN_ELIG_* eligibility result tables — consumers of the cached eligibility state during enrollment processing.
• Benefits concurrent programs that populate and consume the compensation object cache during eligibility and enrollment runs.