Results for “ben_vrbl_usg”

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

Overview

The APPS.BEN_VRBL_RT_PRFL_D view is a reporting and integration object within the Oracle EBS Advanced Benefits (BEN) module. It exposes the definition of variable rate profiles, which are the configurable structures that drive how rates, amounts, and contributions are calculated for benefits plans and plan types. The view is owned by the APPS schema, carries an FND Design Data reference of BEN.BEN_VRBL_RT_PRFL_D, and is classified as an internal view type with VALID status in the E-Business Suite data dictionary. Oracle Corporation expressly designates this object as Internal Use Only, meaning it is not a supported integration point for external access and should only be referenced through standard Oracle Applications programs.

The object is a view rather than a base table, so it presents denormalized, join-derived data rather than raw transactional rows. It supports reporting on the effective-dated configuration of rate profiles, including calculation methods, value rules, rounding rules, and both base and ultimate limit thresholds. Because the view exposes user-facing names for plans, options, and plan types in addition to numeric identifiers, it is suited for descriptive reporting where business users require readable context.

Underlying Base Objects

BEN_VRBL_RT_PRFL_D is defined over a set of synonyms that resolve to the core Advanced Benefits tables and supporting objects. The documented base objects include BEN_VRBL_RT_PRFL_F, which holds the primary variable rate profile definition records and supplies the primary key VRBL_RT_PRFL_ID together with the effective dates and calculation attributes. BEN_PL_F provides plan information, BEN_OPT_F supplies option information, and BEN_PL_TYP_F provides plan type information; these are joined to the rate profile to deliver plan and option context. BEN_PL_TYP_OPT_TYP_F and BEN_OIPL_F contribute the plan type to option type relationships used in benefits configuration.

The view also references FF_FORMULAS_F for formula-based value rules, FND_USER for the standard who column LAST_UPDATED_BY, and the HR_GENERAL package, which is commonly used within BEN views to resolve effective date and business group context. This composition confirms that the view is a consolidated presentation layer spanning rate profile definitions, benefits plan structures, and formula metadata.

Key Columns

• VRBL_RT_PRFL_ID — system-generated primary key for the variable rate profile.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — effective dating that governs the validity window of each profile definition row.
• CALCULATION_METHOD, OPERATOR, COVERAGE_OPERATOR, ACTIVITY_TYPE — control how the rate or amount is derived and applied.
• DEFAULT_VALUE, MIN_VALUE, MAX_VALUE, INCREMENT_VALUE, VALUE — numeric bounds and defaults used in rate computation.
• VALUE_RULE, ROUNDING_CODE, ROUNDING_RULE — rules governing value selection and rounding behavior.
• REFERENCE_PERIOD, TREATMENT, TAX_TYPE, USAGE — contextual attributes affecting how the rate is treated.
• ULTIMATE_LOW_LIMIT_VALUE — the ultimate floor applied to the calculated rate or amount.
• ULTIMATE_HIGH_LIMIT_VALUE — the ultimate ceiling applied to the calculated rate or amount.
• ULTIMATE_LOW_LIMIT_RULE / ULTIMATE_HIGH_LIMIT_RULE — references to the formula or rule that determines the ultimate limits.
• PL_TYP_OPT_TYP_NAME and OPT_PL_NAME — descriptive names for the plan type/option type and option/plan combinations.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — standard who columns for audit tracking.

Common Use Cases and Queries

A frequent requirement is to identify all rate profiles whose ultimate low limit is configured, or to compare base limits against ultimate limits. The following query returns the effective profile, its limit values, and audit information:

• SELECT vrbl_rt_prfl_id, name, effective_start_date, effective_end_date, ultimate_low_limit_value, ultimate_high_limit_value, ultimate_low_limit_rule FROM apps.ben_vrbl_rt_prfl_d WHERE ultimate_low_limit_value IS NOT NULL;
• Filtering by SYSDATE BETWEEN effective_start_date AND effective_end_date isolates currently active configurations.
• Joining on VRBL_RT_PRFL_ID to BEN_VRBL_RT_PRFL_F retrieves the underlying flexfield or descriptive flexfield attributes not exposed by the view.
• Aggregating by CALCULATION_METHOD and ROUNDING_CODE supports validation and audit of rate configuration consistency across plans.

Because the object is flagged Internal Use Only, these queries should be treated as read-only diagnostic or reporting access, and any integration should be routed through supported Oracle Applications interfaces.