Search Results ben_dflt_enrt




Overview
Explore in AI Chat

Overview

APPS.BENBV_LER_CHG_PL_NIP_ENRT_V is a read-only Oracle EBS view in the Benefits (BEN) module that exposes default enrollment rule configuration at the Life Event Reason / Plan / Non-Investment Product level. The view presents a flattened and decoded representation of rows stored in the underlying flexfield table BEN_LER_CHG_PL_NIP_ENRT_F, joining a descriptive flexfield reference and applying lookup decoding so that code values appear alongside their human-readable meanings.

The view is defined with the WITH READ ONLY clause, confirming it is intended strictly for query and reporting purposes rather than for transactional data manipulation. The name includes the "BV" (Benefits View) convention used throughout Oracle EBS Benefits for seeded, business-oriented views that present base table data in a user-friendly form. In the context of the user's search term "ben_dflt_enrt", this view is significant because it surfaces the DFLT_ENRT_CD and DFLT_ENRT_RL columns together with their decoded lookup values, making it the natural object for investigating default enrollment behavior associated with a life event reason and plan combination.

Underlying Base Objects

The view is defined over the base synonym BEN_LER_CHG_PL_NIP_ENRT_F, which is the "F" (flexfield-enabled) table storing life event reason change plan / non-investment product enrollment rules. The suffix indicates the table carries descriptive flexfield segments that are referenced in this view via the literal string '_DF:BEN:BEN_LER_CHG_PL_NIP_ENRT_F:LPE', which signals to the EBS framework that descriptive flexfield attributes belong to the BEN_LER_CHG_PL_NIP_ENRT_F entity.

In addition to the base table, the view references the HR_BIS package, specifically the function HR_BIS.BIS_DECODE_LOOKUP, which is invoked repeatedly to resolve coded values into their corresponding lookup meanings. The view also draws on HR_BIS.GET_SEC_PROFILE_BG_ID in its WHERE clause, applying business group security by restricting returned rows to the session's security profile business group (with NVL logic that falls back to the row's own BUSINESS_GROUP_ID when no profile is resolved). This combination of a seeded base table plus HR_BIS utilities is typical of Benefits views that must honor both security profiles and lookup decoding.

Key Columns

Common Use Cases and Queries

Typical usage centers on auditing default enrollment rules for a life event reason and plan. The following query returns default enrollment configuration for a given life event reason:

  • SELECT ler_id, pl_id, dflt_enrt_cd, dflt_flag, effective_start_date, effective_end_date FROM apps.benbv_ler_chg_pl_nip_enrt_v WHERE ler_id = :p_ler_id;
  • SELECT pl_id, dflt_enrt_cd, auto_enrt_mthd_rl FROM apps.benbv_ler_chg_pl_nip_enrt_v WHERE dflt_flag = 'Y';
  • Reporting extracts that require both the stored code and the decoded meaning, since the view already returns lookup descriptions, avoiding the need to join FND_LOOKUP_VALUES manually.

Because the view is read-only and secured by business group, it is appropriate for concurrent-program extracts, BI Publisher data models, and OAF/ADF-based inquiries within Oracle EBS 12.1.1 and 12.2.2.