Search Results no_mx_elcn_val_dfnd_flag




Overview
Explore in AI Chat

Overview

BEN_VRBL_RT_PRFL_F is the Variable Rate Profile table within the Oracle Advanced Benefits (BEN) product, a core component of Oracle E-Business Suite Human Resources and Benefits administration. The table stores the definition of variable rate profiles, which determine how benefit rates are calculated when they are not fixed values — for example, rates derived from compensation, age, length of service, hours worked, or other employee attributes. Each profile acts as a reusable calculation template that compensation objects and plan configurations reference when a benefit offering requires a formula-driven rate rather than a flat amount.

The table is date-effectivity enabled, carrying the standard EFFECTIVE_START_DATE and EFFECTIVE_END_DATE pair alongside its surrogate identifier VRBL_RT_PRFL_ID. This conforms to the Oracle EBS date-tracked entity pattern, where each logical profile may have multiple effective-dated versions. From a Data Vault modeling perspective, the metadata suggests a satellite-leaning classification: the table captures descriptive and calculation attributes attached to a rate profile business key, with the primary key acting as a versioned unique identifier rather than a pure hub. The physical schema is substantial, encompassing 136 documented columns in the 12.2.2 ETRM release.

Key Information Stored

The surrogate primary key is VRBL_RT_PRFL_ID, which, combined with the effective dates, forms the unique index BEN_VRBL_RT_PRFL_F_PK. The columns most significant for functional and reporting purposes include:

A broad set of RT_*_FLAG columns (over forty of them, such as RT_AGE_FLAG, RT_LOS_FLAG, and RT_HRS_WKD_FLAG) indicate which employee attributes the profile may draw upon, while the VPF_ATTRIBUTE1 through VPF_ATTRIBUTE30 columns provide the standard EBS descriptive flexfield extension block. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER) are also present.

Common Use Cases and Queries

Functional consultants and developers query this table when troubleshooting why a calculated benefit rate produced an unexpected amount, when auditing which attributes a profile is permitted to consume, or when migrating rate profiles between environments. A typical lookup retrieves the active version of a profile by name and business group:

SELECT vrbl_rt_prfl_id, name, vrbl_rt_trtmt_cd, rt_typ_cd,
      dflt_elcn_val, mn_elcn_val, mx_elcn_val, rndg_cd
FROM ben.ben_vrbl_rt_prfl_f
WHERE business_group_id = :p_bg_id
  AND TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Reporting use cases include generating a catalog of rate profiles for a plan year, verifying that caps and floors are consistent across profiles, and identifying profiles that reference compensation level factors via joins on COMP_LVL_FCTR_ID. Because of the wide flag set, analysts frequently build pivot queries that translate the RT_*_FLAG columns into a readable list of permitted rating attributes for documentation and audit deliverables.

Related Objects

The most directly related object is BEN_COMP_LVL_FCTR, joined through BEN_VRBL_RT_PRFL_F.COMP_LVL_FCTR_ID, which defines compensation level factors used in rate derivation. Plan and option configuration tables reference this profile through columns such as PL_ID, PL_TYP_OPT_TYP_ID, and OIPL_ID, linking the profile to plans and offerings. Rate calculation and eligibility engines in the BEN schema consume the profile identifiers to resolve election values at runtime, and the standard descriptive flexfield views layered over VPF_ATTRIBUTE1–30 support user-defined extensions. Date-tracked join patterns against these dependent tables must always respect the effective date range carried on BEN_VRBL_RT_PRFL_F.