Results for “benbv_benfts_grp_v”

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

Overview

BENBV_BENFTS_GRP_V is a read-only view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the BEN (Advanced Benefits) product family and presents benefit group definitions in a reporting-friendly, secured format. A benefit group is the logical grouping of items that may be applied to participants so that they can be eligible for the same benefits. In practice, benefit groups drive eligibility and plan assignment logic, which makes this view a natural access point for administrators and integrators who need to enumerate the groups configured within a business group.

The view is documented as VALID in the ETRM 12.2.2 metadata and is intended for concurrent program output, BI Publisher data models, and custom reporting rather than for transactional updates. Because it carries a WITH READ ONLY clause, all access is restricted to query operations. Its most distinctive feature is the injection of a descriptive flexfield token, which allows a reporting layer or Oracle Forms-based consumer to render the descriptive flexfield context associated with each benefit group.

Underlying Base Objects

BENBV_BENFTS_GRP_V is defined over two documented objects:

• BEN_BENFTS_GRP (referenced through a SYNONYM) — the principal base table holding benefit group header rows, including the group name, description, primary key, and standard WHO audit columns.
• HR_BIS (PACKAGE) — the HR business intelligence and security package. The view calls HR_BIS.GET_SEC_PROFILE_BG_ID in its WHERE clause to resolve the current security profile's business group.

The defining query selects from BEN_BENFTS_GRP and filters rows with BNG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BNG.BUSINESS_GROUP_ID). When a security profile resolves to a business group, only rows for that business group are returned; when the function returns NULL, the NVL causes all business groups to pass the filter. This pattern is the standard mechanism for business-group-level data security in EBS benefits views.

Key Columns

• NAME — the user-defined name of the benefit group, used as the primary user-facing identifier in eligibility and enrollment setups.
• BNG_DESC — the description of the benefit group. This is the column returned by the user's search term "bng_desc" and is the natural label for report headings and list-of-values display.
• _DF:BEN:BEN_BENFTS_GRP:BNG — a descriptive flexfield reference token, not a stored column. It signals the flexfield definition attached to BEN_BENFTS_GRP under the context code BNG, allowing consumers to expand the DFF segments for the benefit group.
• BENFTS_GRP_ID — the unique primary key of the benefit group, used to join to eligibility, plan, and assignment tables.
• BUSINESS_GROUP_ID — the business group (operating unit) to which the group belongs and against which row-level security is enforced.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard WHO audit columns that support change tracking and data lineage reporting.

Common Use Cases and Queries

Typical uses include validating benefit group configuration before a benefits open enrollment cycle, comparing configured groups across business groups, and joining the view to eligibility or plan tables on BENFTS_GRP_ID. Because the view is secured, any user running a report sees only the business groups permitted by their HR security profile.

A simple listing of benefit groups for the current security context:

• SELECT benefit_group_id, name, bng_desc FROM apps.benbv_benfts_grp_v ORDER BY name;

A version-agnostic variant is not required; the same definition applies in both 12.1.1 and 12.2.2. To retrieve descriptive flexfield detail, query the DFF table for BEN_BENFTS_GRP using the context code BNG, joined on BENFTS_GRP_ID. When auditing recent configuration changes, filter on LAST_UPDATE_DATE and include LAST_UPDATED_BY. Note that the view should never be used for DML; benefit group maintenance is performed through the standard Advanced Benefits setup forms against BEN_BENFTS_GRP.