Search Results group_option_in_plan




Overview
Explore in AI Chat

Overview

APPS.BENBV_CWB_PERSON_RATES_V is a database view registered in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 Applications schema (APPS) with a status of VALID. The "BV" naming convention indicates that this is a business view, an internal object surfaced by the Oracle Advanced Benefits (BEN) and Compensation Workbench (CWB) modules for Oracle internal consumption. The view presents a consolidated, person-level picture of compensation worksheet rates, budgets, and recommendations used within the CWB compensation planning cycle. Its primary role is to expose derived and stored rate values — worksheet values, recommendations, eligible and stated salary components, and distribution, worksheet, and reserve budget figures — so that standard Oracle Applications programs can render compensation worksheets and calculate plan outcomes.

The FND Design Data reference BEN.BENBV_CWB_PERSON_RATES_V confirms the object is owned by the BEN product family. As the view carries the "Oracle Internal Use Only" designation, Oracle Corporation does not support direct customer access to the data through this object except via standard Oracle Applications programs.

Underlying Base Objects

The documented base objects referenced by this view are:

  • BEN_CWB_PERSON_RATES (SYNONYM) — the underlying compensation workbench person rates data source providing the core rate and budget columns surfaced by the view.
  • BEN_BIS_UTILS (PACKAGE) — an Advanced Benefits business intelligence utility package used for statement construction and value derivation logic.
  • HR_BIS (PACKAGE) — the Oracle HR business intelligence package supplying common HR intelligence routines applied in the view definition.

The view therefore layers benefits/HCM intelligence utility logic over the person rates synonym, filtering and shaping the data so that it is consumable by CWB worksheet and enrollment processing. It is documented as an internal-view type, consistent with its business-view classification.

Key Columns

The view exposes categories of columns rather than underlying keys:

Common Use Cases and Queries

Typical scenarios involve reconciliation of worksheet totals against budgets, auditing who last updated a worksheet value, and embedding rates into compensation statement or analytics logic. A representative query follows:

  • SELECT LF_EVT_OCRD_DT, ELIG_SAL_VAL, TOT_COMP_VAL, WS_VAL, REC_VAL, COPY_DIST_BDGT_VAL, COPY_WS_BDGT_VAL FROM APPS.BENBV_CWB_PERSON_RATES_V WHERE LF_EVT_OCRD_DT IS NOT NULL;
  • Use the WS_VAL versus REC_VAL comparison to validate manager recommendations within the REC_MN_VAL / REC_MX_VAL range.
  • Use COPY_DIST_BDGT_ISS_VAL and COPY_WS_BDGT_ISS_VAL to determine amounts already issued against distribution and worksheet budgets.

Because the object is flagged internal, customers should rely on supported CWB and Advanced Benefits concurrent programs and extract tables rather than querying this view directly; the "group_option_in_plan" association the user searched for is resolved through the plan and group option context established by these underlying benefits structures.