Search Results ben_enrt_mthd




Overview
Explore in AI Chat

Overview

APPS.BENBV_LER_CHG_PGM_ENRT_V is a business view (BV) in the Oracle E-Business Suite Advanced Benefits (BEN) module. It presents the rows of the underlying change-program enrollment rules, exposing both the raw coded values and their decoded, user-facing meanings. The view is a read-only construct: its definition terminates with the WITH READ ONLY clause, so it is intended strictly for query, reporting, and integration consumption rather than for DML.

In the context of the "ben_enrt_mthd" search term, this view is directly relevant because it surfaces the enrollment method column ENRT_MTHD_CD together with its decoded counterpart produced by HR_BIS.BIS_DECODE_LOOKUP('BEN_ENRT_MTHD', LGE.ENRT_MTHD_CD). This allows a report or interface to obtain the enrollment method code and its descriptive meaning without performing a separate lookup against the BEN lookup tables.

Underlying Base Objects

The view is defined over two documented referenced objects:

  • BEN_LER_CHG_PGM_ENRT_F (accessed through the synonym LGE) — the base table holding change-program enrollment rule records. All columns exposed by the view originate from this table or are derived from its values.
  • HR_BIS (package) — the HR Business Intelligence/decoding package, invoked through BIS_DECODE_LOOKUP and GET_SEC_PROFILE_BG_ID.

The WHERE predicate LGE.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, LGE.BUSINESS_BG_ID) enforces business-group security: rows are filtered to the business group returned by the security profile, or, when no profile value is resolved, to the row's own business group. This is the standard multi-tenant data-segregation pattern used throughout BEN business views.

Key Columns

The view also exposes a descriptive flexfield reference, '_DF:BEN:BEN_LER_CHG_PGM_ENRT_F:LGE', signaling that DFF segments defined on the base table are surfaced through this view.

Common Use Cases and Queries

Typical uses include reporting on enrollment methods configured for change programs, validating rule setup, and data extracts to external systems. A representative query filtering on the decoded enrollment method follows:

  • List enrollment method codes and their descriptions for a program:
    SELECT PGM_ID, ENRT_MTHD_CD, BIS_DECODE_LOOKUP('BEN_ENRT_MTHD', ENRT_MTHD_CD) ENRT_MTHD_MEANING FROM APPS.BENBV_LER_CHG_PGM_ENRT_V WHERE PGM_ID = :pgm_id;
  • Identify rules that prevent mid-period changes:
    SELECT LER_CHG_PGM_ENRT_ID, CRNT_ENRT_PRCLDS_CHG_FLAG FROM APPS.BENBV_LER_CHG_PGM_ENRT_V WHERE CRNT_ENRT_PRCLDS_CHG_FLAG = 'Y';
  • Current effective rules by business group and program:
    SELECT * FROM APPS.BENBV_LER_CHG_PGM_ENRT_V WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Because the view is read-only and applies business-group security automatically, it is the preferred access path for reporting over BEN_LER_CHG_PGM_ENRT_F within Oracle EBS 12.1.1 and 12.2.2, avoiding the need to join the underlying lookup tables directly.