Results for “ben_wksht_grp”

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

Overview

APPS.BENBV_CWB_WKSHT_GRP_V is a read-only reporting view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes configuration data for Compensation Workbench (CWB) worksheet groups, which define the logical groupings used to organize and present worksheets during a compensation or benefits enrollment cycle. The view belongs to the "BV" (business view) family of BEN objects, which are intended for direct query, reporting, and integration consumption rather than for transaction processing.

The view's principal design objective is to present raw coded values alongside their decoded, translatable meanings. Foreign-key style codes stored on the base table are passed through the HR_BIS.BIS_DECODE_LOOKUP function to yield user-facing descriptions, allowing reporting tools and integrations to consume human-readable output without joining to lookup tables directly. The "ben_stat" search term maps directly to the STATUS_CD column, whose values are decoded against the BEN_STAT lookup type. The view is defined WITH READ ONLY, so it cannot be used as the target of DML and serves strictly as a query surface.

Underlying Base Objects

The view is defined over two documented objects:

• BEN_CWB_WKSHT_GRP (referenced in the view text as the synonym BEN_CWB_WKSHT_GRP) — the base table that stores Compensation Workbench worksheet group definitions, including ordering, labels, status, visibility, and ownership/security identifiers.
• HR_BIS (package) — provides the BIS_DECODE_LOOKUP function used to translate stored lookup codes into descriptive text, and the GET_SEC_PROFILE_BG_ID function used to constrain rows by the caller's business group security profile.

Row filtering is applied through the predicate CWG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CWG.BUSINESS_GROUP_ID). When a security profile business group is resolved, only rows for that business group are returned; when it is null, all business groups are visible. This makes the view inherently multi-tenant aware within a single EBS instance.

Key Columns

• ORDR_NUM — display sequence used to order worksheet groups.
• LABEL — the descriptive name shown to end users.
• WKSHT_GRP_CD — the worksheet group code, decoded via BEN_WKSHT_GRP.
• STATUS_CD — the record status; decoded via BEN_STAT, yielding the "ben_stat" meaning users search for (for example active or inactive states).
• HIDDEN_CD — a visibility flag decoded via BEN_CWB_HIDDEN, indicating whether the group is hidden from users.
• CWB_WKSHT_GRP_ID — the primary key identifier for the worksheet group.
• BUSINESS_GROUP_ID — the owning business group, central to the security predicate.
• PL_ID — the associated plan identifier linking the group to a benefit plan context.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — the standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include validating worksheet group configuration, building reporting extracts, and reconciling which groups are active or hidden per plan. A common query filters on the status description returned by the view:

SELECT cwb_wksht_grp_id, label, wksht_grp_cd, status_cd, hidden_cd, pl_id
FROM apps.benbv_cwb_wksht_grp_v
WHERE status_cd = 'A'
ORDER BY ordr_num;

Because the decoded lookup expressions are not assigned column aliases in the base view definition, consumers should reference them positionally or wrap the view in an outer SELECT when a named decoded column is required. The view is best suited for read-only reporting and integration extracts, consistent with its WITH READ ONLY definition.