Results for “wksht_grp_cd”

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

Overview

BENBV_CWB_WKSHT_GRP_V is a read-only Oracle EBS view owned by the APPS schema and validated under the Advanced Benefits (BEN) product family. It exposes worksheet group definitions used by Compensation Workbench, the component of Advanced Benefits that lets administrators configure worksheets, distribute them to managers, and collect compensation allocation decisions. The view surfaces the ordering, label, code values, status, and visibility attributes of each worksheet group alongside decoded meaning values, so downstream reports, OAF pages, and integration extracts do not have to join the lookup tables themselves.

The view is defined with the WITH READ ONLY clause, so it is intended strictly for query and reporting access. It is the standard reporting interface for worksheet group data in both EBS 12.1.1 and 12.2.2; the underlying table structure and the view definition are unchanged between those releases.

Underlying Base Objects

The view is defined over BEN_CWB_WKSHT_GRP, exposed in the APPS schema as a synonym for the base Compensation Workbench worksheet group table. It calls the HR_BIS package twice indirectly through the BIS_DECODE_LOOKUP function, which resolves coded values into their translated display meanings. HR_BIS is documented as a referenced base object of the view.

The driving query selects all rows from BEN_CWB_WKSHT_GRP subject to a business group filter: WHERE CWG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CWG.BUSINESS_GROUP_ID). When the session has a business group security profile set, only rows for that business group are returned; when no profile is resolved, the NVL predicate falls back to the column value and all business groups are visible. This makes the view multi-tenant safe by default under standard security-profile configuration.

Key Columns

• ORDR_NUM — display order number used to sequence worksheet groups in the user interface.
• LABEL — the user-visible name assigned to the worksheet group.
• WKSHT_GRP_CD / WKSHT_GRP_CD_M — the lookup code for the worksheet group type and its decoded meaning from the BEN_WKSHT_GRP lookup type.
• STATUS_CD / STATUS_CD_M — the record status code and its decoded meaning via the BEN_STAT lookup type (for example active or inactive).
• HIDDEN_CD / HIDDEN_CD_M — the visibility flag for the group and its decoded meaning via the BEN_CWB_HIDDEN lookup type.
• CWB_WKSHT_GRP_ID — primary key of the worksheet group record.
• BUSINESS_GROUP_ID — the business group that owns the row; the principal security filter column.
• PL_ID — the plan identifier associated with the worksheet group.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — the standard WHO audit columns.

Common Use Cases and Queries

Typical uses include listing active worksheet groups for a Compensation Workbench configuration review, validating that all groups are correctly ordered, and feeding group codes into downstream extracts that map managers and participants to worksheets.

To list all worksheet groups visible under the current security profile:

SELECT cwb_wksht_grp_id, label, wksht_grp_cd_m, status_cd_m, hidden_cd_m, ordr_num
FROM apps.benbv_cwb_wksht_grp_v
ORDER BY ordr_num, label;

To isolate only active, non-hidden groups:

SELECT label, wksht_grp_cd_m, pl_id
FROM apps.benbv_cwb_wksht_grp_v
WHERE status_cd_m = 'Active'
AND hidden_cd_m = 'No';

Because the view already performs lookup decoding, it is preferable to direct reporting queries at BENBV_CWB_WKSHT_GRP_V rather than joining BEN_CWB_WKSHT_GRP to FND_LOOKUP_VALUES directly. Note that the decoded meaning columns return the lookup's current translated meaning; if a lookup meaning is reworded, historical reports referencing the view will reflect the new wording.