Search Results ben_eligy_crit_values




Overview
Explore in AI Chat

Overview

BEN_ELIGY_CRIT_VALUES is an APPS-owned database view within the BEN (Advanced Benefits) product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes eligibility criteria values configuration data used by the Oracle Advanced Benefits (OAB) eligibility engine to determine whether a participant or dependent qualifies for a given program, plan, or option. In EBS, eligibility is modeled through eligibility profiles (BEN_ELIG_PRFL_F) that group one or more eligibility criteria (BEN_ELIG_CRITERIA_F), and each criterion is further qualified by one or more criteria values — the records surfaced by this view. Each row therefore represents a single value (or value range) assigned to a criterion attached to an eligibility profile.

Functionally, the view is a session-effective (date-tracked) reporting layer. Rather than querying the underlying _F table directly, the view restricts results to records valid as of the current FND session effective date, so reports and integrations return configuration state as the E-Business Suite session "sees" it. This makes it suitable for point-in-time reporting, data extraction, and troubleshooting of eligibility rule configuration.

Underlying Base Objects

The documented ETRM metadata identifies the view as defined over two synonyms: BEN_ELIGY_CRIT_VALUES_F (the base date-tracked table) and FND_SESSIONS (used to derive the session effective date). The view logic is date-effective filtering: rows from BEN_ELIGY_CRIT_VALUES_F are returned only where EFFECTIVE_START_DATE <= session effective date and EFFECTIVE_END_DATE >= session effective date. The session effective date is obtained via USERENV('SESSIONID') joined to FND_SESSIONS. Because it is a view, no separate storage exists; all columns are projections of the underlying table, prefixed internally with the alias ECV.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing eligibility configuration, verifying which value ranges an eligibility profile applies, and extracting criteria values for conversion or reconciliation against legacy systems. Because the view already enforces session-effective filtering, queries automatically return the current configuration without manual date predicates.

  • Listing values for a specific eligibility profile: 
    SELECT ecv.eligy_crit_values_id, ecv.eligy_criteria_id,
       ecv.ordr_num, ecv.number_value1, ecv.char_value1
FROM   apps.ben_eligy_crit_values ecv
WHERE  ecv.eligy_prfl_id = :p_profile_id
ORDER  BY ecv.eligy_criteria_id, ecv.ordr_num;
  • Identifying exclusion-type values: WHERE ecv.excld_flag = 'Y'.
  • Reporting criteria values by business group and legislation for regional analysis.
  • Joining to BEN_ELIG_CRITERIA_F and BEN_ELIG_PRFL_F to resolve criterion and profile names for reporting.

As with all date-effective BEN views, the returned dataset reflects the session effective date, so care should be taken in integrations that run outside a normal EBS session context. The view is read-only and should not be used for direct DML.