Search Results eligy_prfl_name




Overview
Explore in AI Chat

Overview

APPS.BEN_VRBL_RT_ELIG_PRFL_D is a descriptive (non-hooked) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the association between variable rate profiles and eligibility profiles within the Oracle Advanced Benefits (BEN) module. The suffix "D" designates a descriptive view, meaning it is intended for read-only reporting and inquiry rather than for transactional data entry; the ETRM documentation explicitly flags the object as Oracle Internal Use Only and notes that Oracle Corporation does not support direct access to this object except from standard Oracle Applications programs.

The view serves as the primary reporting and integration surface for answering the question "which eligibility profile is attached to a given variable rate profile, and is that attachment mandatory?" Because it is denormalized to carry the textual names of both profiles, it eliminates the need for downstream queries to join repeatedly against the base tables simply to render human-readable output. This is the object most commonly reached when a user searches on the term eligy_prfl_name, since that column is one of the view's identifying descriptive attributes.

Underlying Base Objects

The view is defined over three BEN synonyms and two supporting objects, consistent with the documented dependency list:

The view is not referenced by any other database object in the documented dependency tree, confirming it is a leaf-level reporting object.

Key Columns

  • VRBL_RT_ELIG_PRFL_ID (NUMBER 15) — Primary identifier of the variable rate / eligibility profile association row.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE (DATE) — Date-tracked validity window for the association.
  • VRBL_RT_PRFL_NAME (VARCHAR2 240) — Name of the variable rate profile.
  • ELIGY_PRFL_NAME (VARCHAR2 240) — Name of the eligibility profile; the column matching the user's search term.
  • MNDTRY_FLAG_MEANING (VARCHAR2 80) — Quickcode meaning indicating whether the eligibility profile is mandatory for the variable rate profile.
  • LAST_UPDATE_DATE (DATE) — Audit timestamp of the most recent modification.
  • LAST_UPDATED_BY (VARCHAR2 100) — User who last modified the record, resolved via FND_USER.

Common Use Cases and Queries

Typical scenarios include auditing which eligibility profiles constrain a variable rate plan, validating mandatory eligibility configuration before a payroll or benefits run, and reconciling benefits setup during upgrades from 12.1.1 to 12.2.2. A simple lookup by eligibility profile name follows:

SELECT vrbl_rt_prfl_name, eligy_prfl_name, mndtry_flag_meaning, effective_start_date, effective_end_date FROM apps.ben_vrbl_rt_elig_prfl_d WHERE eligy_prfl_name = :p_eligy_prfl_name AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

To list all eligibility profiles attached to a specific variable rate profile, query on VRBL_RT_PRFL_NAME instead. For auditing recent configuration changes, filter on LAST_UPDATE_DATE and join LAST_UPDATED_BY to FND_USER via the standard user-name lookup, restricting MNDTRY_FLAG_MEANING where the mandatory designation is material to the analysis.