Search Results ben_elig_asnt_set_prte




Overview
Explore in AI Chat

Overview

BEN_ELIG_ASNT_SET_PRTE is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, belonging to the BEN (Advanced Benefits) product family. It exposes the assignment set participation rules that govern how eligibility profiles are constrained by assignment sets within Oracle Advanced Benefits. The view is classified in the ETRM repository as "Retrofitted," indicating it was introduced or standardized as part of a later maintenance or retrofit effort rather than from the original release. Its status is VALID in both 12.1.1 and 12.2.2.

Functionally, the view presents date-effective rows that link an eligibility profile (ELIGY_PRFL_ID) to an assignment set (ASSIGNMENT_SET_ID), with flags controlling whether the assignment set participates in an inclusion or exclusion ("excluded") capacity. Because the view resolves the effective date range against the current FND_SESSIONS context, it presents only the rows effective for the logged-in session's effective date — effectively behaving as a "current view" over a date-tracked ("_F") table. This makes the view directly usable in reports, extracts, integrations, and concurrent programs where the caller requires the currently effective participation rule set without writing explicit date-range predicates.

Underlying Base Objects

The view is defined over two documented base objects:

  • BEN_ELIG_ASNT_SET_PRTE_F (SYNONYM) — the date-effective ("_F" = "full"/datetracked) base table storing the assignment set participation rules, including the object version number, WHO columns, and 30 descriptive flexfield attribute columns.
  • FND_SESSIONS (SYNONYM) — the session context table that supplies the effective date used in the view's filter predicate.

The view's WHERE clause restricts output to rows where EFFECTIVE_START_DATE <= session effective date AND EFFECTIVE_END_DATE >= session effective date. Both comparisons are resolved via a scalar subquery against FND_SESSIONS.EFFECTIVE_DATE using USERENV('SESSIONID'). Consequently every session sees only its own currently effective interval — the intersection of the rule's datetrack range with the session effective date. Non-effective rows and rows datetracked for other dates are excluded transparently.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing which assignment sets are excluded from a given eligibility profile, building eligibility extracts for benefit plan enrolment, troubleshooting Advanced Benefits eligibility results, and feeding integration pipelines that reconcile assignment set scoping. Because the view is already date-filtered, sessions must run with the correct effective date to obtain meaningful results.

A representative query joins to the eligibility profile:

  • SELECT prte.ELIG_ASNT_SET_PRTE_ID, prte.ELIGY_PRFL_ID, prte.ASSIGNMENT_SET_ID, prte.EXCLD_FLAG, prte.ORDR_NUM, prte.EFFECTIVE_START_DATE, prte.EFFECTIVE_END_DATE FROM APPS.BEN_ELIG_ASNT_SET_PRTE prte WHERE prte.ELIGY_PRFL_ID = :p_profile_id ORDER BY prte.ORDR_NUM;
  • Filter with AND prte.EXCLD_FLAG = 'Y' to isolate excluded assignment sets.

In summary, BEN_ELIG_ASNT_SET_PRTE is a thin, session-aware reporting view over the datetracked assignment set participation table, exposing the currently effective scoping rules that Oracle Advanced Benefits applies when evaluating eligibility profiles.