Results for “vrbl_rt_prfl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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_IDwith 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_NAMErequested in the user's search. - FND_USER — the standard Oracle Applications user table, referenced for the
LAST_UPDATED_BYwho-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
SYSDATEto 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.
-
VIEW: APPS.BEN_AGE_RT_D 12.2.2
-
VIEW: APPS.BEN_TBCO_USE_RT_D 12.2.2
-
VIEW: APPS.BEN_PY_BSS_RT_D 12.1.1
-
VIEW: APPS.BEN_LOS_RT_D 12.1.1
-
VIEW: APPS.BEN_LOS_RT_D 12.2.2
-
VIEW: APPS.BEN_PY_BSS_RT_D 12.2.2
-
VIEW: APPS.BEN_GNDR_RT_D 12.1.1
-
VIEW: APPS.BEN_SVC_AREA_RT_D 12.2.2
-
VIEW: APPS.BEN_GRADE_RT_D 12.1.1
-
VIEW: APPS.BEN_GRADE_RT_D 12.2.2
-
VIEW: APPS.BEN_COMP_LVL_RT_D 12.2.2
-
VIEW: APPS.BEN_LBR_MMBR_RT_D 12.1.1
-
View: BEN_COMP_LVL_RT_D 12.2.2
- Retrofitted
APPS.BEN_COMP_LVL_RT_D·↳ BEN_COMP_LVL_FCTR·↳ BEN_COMP_LVL_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BEN_ACTY_VRBL_RT_D 12.1.1
- Retrofitted - Retrofitted
APPS.BEN_ACTY_VRBL_RT_D·↳ BEN_ACTY_BASE_RT_F·↳ BEN_ACTY_VRBL_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
VIEW: APPS.BEN_PPL_GRP_RT_D 12.2.2
-
VIEW: APPS.BEN_SVC_AREA_RT_D 12.1.1
-
View: BEN_SVC_AREA_RT_D 12.1.1
- Retrofitted
APPS.BEN_SVC_AREA_RT_D·↳ BEN_SVC_AREA_F·↳ BEN_SVC_AREA_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BEN_AGE_RT_D 12.1.1
- Retrofitted
APPS.BEN_AGE_RT_D·↳ BEN_AGE_FCTR·↳ BEN_AGE_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BEN_TBCO_USE_RT_D 12.2.2
- Retrofitted
APPS.BEN_TBCO_USE_RT_D·↳ BEN_TBCO_USE_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_USER·Explore BEN module →
-
View: BEN_PPL_GRP_RT_D 12.1.1
APPS.BEN_PPL_GRP_RT_D·↳ BEN_PPL_GRP_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
View: BEN_LBR_MMBR_RT_D 12.1.1
- Retrofitted
APPS.BEN_LBR_MMBR_RT_D·↳ BEN_LBR_MMBR_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
View: BEN_LOS_RT_D 12.1.1
- Retrofitted
APPS.BEN_LOS_RT_D·↳ BEN_LOS_FCTR·↳ BEN_LOS_RT_F·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BEN_BRGNG_UNIT_RT_D 12.2.2
- Retrofitted
APPS.BEN_BRGNG_UNIT_RT_D·↳ BEN_BRGNG_UNIT_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_USER·Explore BEN module →
-
View: BEN_HRLY_SLRD_RT_D 12.1.1
- Retrofitted
APPS.BEN_HRLY_SLRD_RT_D·↳ BEN_HRLY_SLRD_RT_F·↳ BEN_VRBL_RT_PRFL_F·↳ FND_GLOBAL·Explore BEN module →
-
VIEW: APPS.BEN_COMP_LVL_RT_D 12.1.1
-
VIEW: APPS.BEN_AGE_RT_D 12.1.1
-
VIEW: APPS.BEN_TBCO_USE_RT_D 12.1.1
-
VIEW: APPS.BEN_GNDR_RT_D 12.2.2
-
VIEW: APPS.BEN_LBR_MMBR_RT_D 12.2.2