Results for “ben_asnt_set_rt_x”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BEN_ASNT_SET_RT_X is an Oracle E-Business Suite Advanced Benefits (BEN) view owned by the APPS schema. Its name denotes an "assignment set / variable rate" intersection entity with the trailing "_X" signifying the date-effective (or "date-tracked") variant of the underlying object. In EBS 12.1.1 and 12.2.2, Advanced Benefits maintains many such interface objects where a base "_F" table holds the full, un-bounded set of date-effective rows, and a corresponding view exposes only the rows whose effective date window contains the current system date. BEN_ASNT_SET_RT_X performs exactly this function.

The view is described in the ETRM repository simply as "Retrofitted" and carries the persistent "Oracle Proprietary, Conf" access classification. Its practical role is to give report writers, Fast Formulas, OAF pages, and interface programs a stable, single-row-per-active-key read surface over the assignment-set-to-variable-rate-profile relationship, without requiring callers to hand-code effective-date predicates. Because the view is date-filtered on TRUNC(SYSDATE), it presents the "as of today" state of the mapping and is well suited to real-time eligibility and reporting logic.

The view is also significant to users searching on asr_attribute1. The distinguishing feature of this retrofitted object is that it exposes the full block of 30 developer-defined descriptive flexfield (DFF) columns, ASR_ATTRIBUTE_CATEGORY through ASR_ATTRIBUTE30, in addition to the standard business columns.

Underlying Base Objects

The view is defined over a single documented base object:

• BEN_ASNT_SET_RT_F (accessed via a synonym) — the date-effective, non-translated base table that stores all assignment set / variable rate profile mappings. The "_F" suffix marks it as the "full" date-tracked table, retaining historical rows.

No joins are present. The view is a projection of the base table with one filter, so it is a thin, non-updatable-by-default view that behaves as a subset of BEN_ASNT_SET_RT_F. Insert, update, and delete operations must be directed at the base table, not the view, unless a custom INSTEAD-OF trigger is deployed. The APPS synonym BEN_ASNT_SET_RT_F resolves the object in the runtime environment.

Key Columns

The view exposes the primary key and the descriptive flexfield block alongside the driving keys:

• ASNT_SET_RT_ID — primary key of the assignment-set-to-rate relationship.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the date-effective window; the view's filter guarantees SYSDATE falls inside this range.
• VRBL_RT_PRFL_ID — foreign key to the variable rate profile used by the assignment set.
• ASSIGNMENT_SET_ID — foreign key to the assignment set to which the rate profile is bound.
• ORDR_NUM — sequencing order for the mapping.
• EXCLD_FLAG — indicates whether the mapping is excluded (Y/N semantics).
• BUSINESS_GROUP_ID — the HR business group owning the row.
• ASR_ATTRIBUTE_CATEGORY — the DFF context (structure name) that governs which attribute columns are meaningful.
• ASR_ATTRIBUTE1 … ASR_ATTRIBUTE30 — the thirty generic descriptive flexfield segments, where ASR_ATTRIBUTE1 ("asr_attribute1") is the first configurable segment.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard Who columns and optimistic-locking version number.

Common Use Cases and Queries

Typical uses include eligibility checks, reporting on rate-profile assignments as of today, and extracting DFF values keyed on ASR_ATTRIBUTE1 for downstream integration. Because the view already applies the effective-date predicate, queries need not add one — but they should still constrain by BUSINESS_GROUP_ID and join keys.

List active mappings for a specific assignment set:

SELECT ASNT_SET_RT_ID, ASSIGNMENT_SET_ID, VRBL_RT_PRFL_ID, EXCLD_FLAG
FROM   APPS.BEN_ASNT_SET_RT_X
WHERE  ASSIGNMENT_SET_ID = :p_assignment_set_id
ORDER  BY ORDR_NUM;

Extract rows carrying a specific descriptive flexfield value in ASR_ATTRIBUTE1:

SELECT ASNT_SET_RT_ID, ASSIGNMENT_SET_ID, VRBL_RT_PRFL_ID,
       ASR_ATTRIBUTE_CATEGORY, ASR_ATTRIBUTE1
FROM   APPS.BEN_ASNT_SET_RT_X
WHERE  ASR_ATTRIBUTE1 = :p_attr1_value
AND    BUSINESS_GROUP_ID = :p_business_group_id;

Join to the rate profile and assignment set to resolve names for a report:

SELECT x.ASSIGNMENT_SET_ID, x.VRBL_RT_PRFL_ID, x.ORDR_NUM, x.ASR_ATTRIBUTE1
FROM   APPS.BEN_ASNT_SET_RT_X x
WHERE  TRUNC(SYSDATE) BETWEEN x.EFFECTIVE_START_DATE AND x.EFFECTIVE_END_DATE;

Where historical or future-dated rows are required — for audit or what-if analysis — query BEN_ASNT_SET_RT_F directly and supply explicit effective-date predicates. Doing so is the standard workaround when BEN_ASNT_SET_RT_X returns only the current-dated slice.