Search Results vrbl_rt_prfl

Overview

APPS.BEN_ACTL_PREM_VRBL_RT_D is a dictionary-style (denormalized) view in the Oracle E-Business Suite Benefits module. It presents the relationship between actual premium records and the variable rate profiles assigned to them, resolving the underlying foreign key identifiers into human-readable names. The view exposes the surrogate identifier ACTL_PREM_VRBL_RT_ID alongside the descriptive VRBL_RT_PRFL_NAME and ACTL_PREM_NAME, which makes it particularly suitable for reporting, data extraction, and integration scenarios where business users or downstream systems require meaningful labels rather than internal numeric keys.

The object is registered in FND Design Data as BEN.BEN_ACTL_PREM_VRBL_RT_D and carries a status of VALID. It is flagged as Oracle Internal Use Only: Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. The view type is documented as Internal. Consequently, the view should be treated as a read-only reporting and diagnostic aid rather than a supported integration interface, and any custom code should account for the possibility that its definition may change between releases and patch levels.

Underlying Base Objects

The view is defined over four referenced objects:

• BEN_ACTL_PREM_VRBL_RT_F — the primary base table holding the association between an actual premium and a variable rate profile, keyed by ACTL_PREM_VRBL_RT_ID with effective dating.
• BEN_ACTL_PREM_F — the actual premium definition, supplying the ACTL_PREM_NAME.
• BEN_VRBL_RT_PRFL_F — the variable rate profile definition, supplying the VRBL_RT_PRFL_NAME requested in the user's search.
• FND_USER — the standard Oracle Applications user table, referenced for the LAST_UPDATED_BY who-column.

All referenced base objects are exposed to APPS as synonyms. The view is not referenced by any other database object, confirming it is a terminal reporting construct.

Key Columns

• ROW_ID (ROWID) — the physical row identifier of the underlying record.
• ACTL_PREM_VRBL_RT_ID (NUMBER 15) — the surrogate primary key linking an actual premium to a variable rate profile.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE (DATE) — the effective dating window for the association; queries should filter on SYSDATE to retrieve the currently effective row.
• ACTL_PREM_NAME (VARCHAR2 240) — the descriptive name of the actual premium.
• VRBL_RT_PRFL_NAME (VARCHAR2 240) — the descriptive name of the variable rate profile associated with the premium; this is the column matching the user's search term.
• LAST_UPDATE_DATE (DATE) — standard who-column recording the last update timestamp.
• LAST_UPDATED_BY (VARCHAR2 100) — the user who last updated the row, resolvable to FND_USER.USER_ID.
• ORDR_NUM (NUMBER 15) — the display or ordering sequence number for the association.

Common Use Cases and Queries

Typical use cases include auditing which variable rate profiles are attached to actual premiums, validating configuration during implementations, and building ad-hoc reports that expose profile names without joining the base tables directly.

Listing all associations for a given profile name:

SELECT actl_prem_name, vrbl_rt_prfl_name,
       effective_start_date, effective_end_date
FROM   apps.ben_actl_prem_vrbl_rt_d
WHERE  vrbl_rt_prfl_name = :p_profile_name
AND    TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date;

Auditing recently modified rows:

SELECT actl_prem_vrbl_rt_id, actl_prem_name, vrbl_rt_prfl_name,
       last_update_date, last_updated_by
FROM   apps.ben_actl_prem_vrbl_rt_d
WHERE  last_update_date >= TRUNC(SYSDATE) - 30
ORDER BY last_update_date DESC;

Because the view is documented as internal and unsupported for direct access, these queries are best confined to reporting and diagnostic purposes, executed under a read-only responsibility or in a reporting schema, and reviewed whenever the EBS release or patch level changes.