Search Results ben_elig_asnt_set_prte_d




Overview
Explore in AI Chat

Overview

BEN_ELIG_ASNT_SET_PRTE_D is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the BEN (Advanced Benefits) product family. The view exposes the assignment set participation criteria that are attached to an eligibility profile, resolving the underlying foreign key identifiers into human-readable names and meanings so that setup and eligibility data can be reviewed without additional joins. The object is marked VALID in the data dictionary, and its documentation carries the "- Retrofitted" designation, indicating that the view predates or was reclassified during the ETRM migration and is retained for backward compatibility with existing reports, forms, and integrations that reference it directly.

The view is defined over the "_F" (frozen/base) variants of the Advanced Benefits eligibility tables, which is the standard EBS convention for presentation views that must not be affected by the date-tracked "_VL" layer. It serves as a convenience interface for administrators configuring eligibility profiles and for functional users auditing which assignment sets an eligibility profile targets or excludes.

Underlying Base Objects

The view text references five base objects plus one package in the documented ETRM metadata for 12.2.2:

All joins to HR_ASSIGNMENT_SETS, BEN_ELIGY_PRFL_F, FND_USER, and HR_LOOKUPS are outer joins, so a participation row is returned even when the referenced assignment set, profile, user, or lookup value is missing or inaccessible.

Key Columns

  • ROW_ID — the ROWID of the underlying BEN_ELIG_ASNT_SET_PRTE_F row, used for direct row addressing.
  • ELIG_ASNT_SET_PRTE_ID — the primary key of the participation criterion record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-tracked effective range of the criterion row.
  • ORDR_NUM — the ordering number applied when evaluating multiple participation criteria.
  • EXCLD_MEANING — decoded from EXCLD_FLAG via HR_LOOKUPS; indicates whether the assignment set is included (No) or excluded (Yes).
  • ASSIGNMENT_SET_NAME — descriptive name of the targeted assignment set.
  • ELIGY_PRFL_NAME — descriptive name of the parent eligibility profile.
  • LAST_UPDATE_DATE / LAST_UPDATED_BY — audit columns; LAST_UPDATED_BY is exposed as the FND_USER user identifier rather than a name.

Common Use Cases and Queries

Typical uses include auditing which assignment sets a profile includes or excludes, troubleshooting eligibility evaluation results, and building ad hoc reports on eligibility configuration. A representative query lists all participation criteria for a given profile:

  • SELECT p.eligy_prfl_name, p.assignment_set_name, p.excld_meaning, p.ordr_num, p.effective_start_date, p.effective_end_date FROM apps.ben_elig_asnt_set_prte_d p WHERE p.eligy_prfl_name = :profile_name ORDER BY p.ordr_num;
  • SELECT assignment_set_name, excld_meaning FROM apps.ben_elig_asnt_set_prte_d WHERE effective_start_date >= :effective_date;
  • SELECT row_id, elig_asnt_set_prte_id, last_updated_by, last_update_date FROM apps.ben_elig_asnt_set_prte_d WHERE elig_asnt_set_prte_id = :id;

Because the view is a non-key-preserved outer-join construct, it should be treated as read-only and not used as the basis for DML. Records should be maintained through the Advanced Benefits eligibility profile setup forms or the corresponding HR_API/benefits APIs, after which the view reflects the changes on the next query.