Search Results ben_asnt_set_rt




Overview
Explore in AI Chat

Overview

BEN_ASNT_SET_RT is an APPS-owned, VALID database view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes the date-tracked (datetracked) definition of assignment set runtime rules, which determine how a group of assignments is assembled and evaluated when benefits eligibility, enrollment, or rate processing is executed. The view is classified as Retrofitted, indicating it was introduced into the ETRM repository during a retrofitting exercise to bring legacy or seeded database objects into the documented metadata model; the internal name and view text nonetheless conform to the standard BEN datetracked view pattern used throughout release 12.1.1 and 12.2.2.

Functionally, BEN_ASNT_SET_RT presents the currently effective rows of the assignment set runtime rule entity for the active user session. Rather than returning the full history held in the underlying table, the view applies a datetrack filter so that only rows whose effective date range brackets the session effective date are returned. This makes it suitable for concurrent programs, forms, and integration interfaces that must operate against the business-visible configuration on a given date, and it isolates callers from the underlying _F (date-tracked) table structure.

Underlying Base Objects

The view is defined over two documented referenced objects, both resolved through APPS synonyms:

  • BEN_ASNT_SET_RT_F — the date-tracked base table that stores assignment set runtime rule records with their EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns. The view selects all columns from this table (aliased ASR) without joins or transformations.
  • FND_SESSIONS — the Applications session table, queried twice in correlated subqueries to obtain the effective date for the current session, identified by USERENV('SESSIONID').

The datetrack predicate is expressed as EFFECTIVE_START_DATE <= session effective date AND EFFECTIVE_END_DATE >= session effective date, so the view always reflects the row version valid for the session context. No aggregation, decoding, or outer joins are performed.

Key Columns

Common Use Cases and Queries

Typical scenarios include configuration reporting, migration validation between environments, and diagnostics of eligibility or rate processing where assignment set membership must be inspected. Because the view filters on the session effective date, queries run through a standard EBS connection automatically see the correct datetracked version.

SELECT asnt_set_rt_id, assignment_set_id, vrbl_rt_prfl_id,
       ordr_num, excld_flag, effective_start_date, effective_end_date
FROM   apps.ben_asnt_set_rt
WHERE  business_group_id = :p_business_group_id
ORDER  BY assignment_set_id, ordr_num;

To retrieve the runtime rules linked to a specific variable rate profile:

SELECT r.assignment_set_id, r.ordr_num, r.excld_flag
FROM   apps.ben_asnt_set_rt r
WHERE  r.vrbl_rt_prfl_id = :p_vrbl_rt_prfl_id;

For audit or historical comparison, the base table BEN_ASNT_SET_RT_F should be queried directly, since the view intentionally suppresses rows outside the session effective date. In 12.2.2 the object remains a read-only reporting and lookup view; all maintenance is performed against the underlying date-tracked table through the standard BEN forms and APIs.