Search Results ben_eligy_prfl_rl




Overview
Explore in AI Chat

Overview

BEN_ELIGY_PRFL_RL is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the Advanced Benefits (BEN) product. It exposes row-level eligibility profile rule data — specifically the criteria that determine whether a person satisfies a given eligibility profile. As a "retrofitted" object, it exists primarily to preserve backward compatibility, presenting a stable, date-effective interface over the underlying transactional table. The view is marked VALID in ETRM for both 12.1.1 and 12.2.2.

The critical design characteristic of this view is that it is effective-date filtered at runtime. Rather than returning all rows from the base table, it restricts output to records whose effective date range brackets the session effective date obtained from FND_SESSIONS. This makes it a session-aware view: two users querying concurrently under different effective dates will see different result sets. The view is therefore intended for use inside the EBS application runtime, where an FND_SESSIONS row exists for the active session, and is not generally suitable for direct external SQL or BI extraction outside that context.

Underlying Base Objects

ETRM documents two referenced objects:

  • BEN_ELIGY_PRFL_RL_F (SYNONYM) — the primary base object. The "_F" suffix denotes a date-tracked (date-effective) entity. The view selects all columns from this object using the alias ERL and applies the effective date predicate against it.
  • FND_SESSIONS (SYNONYM) — the Oracle Application Object Library session table, accessed twice in subqueries to retrieve SS.EFFECTIVE_DATE for the current USERENV('SESSIONID').

Because the filter depends on FND_SESSIONS, any query executed without a valid EBS session context returns no rows, since the scalar subquery yields no effective date. This relationship to the base object is read-only; the view is a filtered projection and carries no additional derivation logic.

h4>Key Columns

The view exposes the complete set of columns from BEN_ELIGY_PRFL_RL_F, including standard date-tracked attributes:

Common Use Cases and Queries

Typical uses include diagnosing why a participant was or was not enrolled, verifying rule ordering, and auditing formula assignments. Because the view is session-filtered, it must be queried from within an EBS session (for example, via a concurrent program, OAF page, or SQL*Plus session after initializing an applications context).

  • Retrieve active rules for a profile in the current session:

SELECT eligy_prfl_rl_id, ordr_to_aply_num, formula_id, drvbl_fctr_apls_flag
FROM apps.ben_eligy_prfl_rl
WHERE eligy_prfl_id = :p_profile_id
ORDER BY ordr_to_aply_num;

  • Inspect flexfield data for a rule line:

SELECT eligy_prfl_rl_id, erl_attribute_category, erl_attribute1, erl_attribute2
FROM apps.ben_eligy_prfl_rl
WHERE eligy_prfl_rl_id = :p_rule_id;

For historical or as-of-date reporting outside a live session, query the base table BEN_ELIGY_PRFL_RL_F directly and supply explicit effective date predicates, since the view intentionally hides non-current-dated rows and cannot be redirected to an arbitrary effective date.