Search Results ben_prtl_mo_rt_prtn_val




Overview
Explore in AI Chat

Overview

BEN_PRTL_MO_RT_PRTN_VAL is a seeded, read-only Oracle EBS view owned by the APPS schema and registered against the BEN (Advanced Benefits) product module. It presents effective-dated rows describing partial-month rate proration values used by the Oracle Advanced Benefits rating and premium calculation engine. In ETRM 12.1.1 and 12.2.2 the object carries a VALID status and is explicitly annotated as "Retrofitted," indicating it was reconciled into the current release through the standard ETRM retrofit mechanism rather than authored as new functionality.

The view implements a date-tracked (effective-date) filter against the underlying _F table. Rather than exposing every physical row, it returns only the record whose EFFECTIVE_START_DATE and EFFECTIVE_END_DATE bracket the effective date of the current FND_SESSIONS session. This design is characteristic of Oracle Benefits datetracked entities and ensures that concurrent users, each operating under a distinct session effective date, see the correct historical or future-dated version of the proration value.

Underlying Base Objects

ETRM documents two referenced base objects, both resolved through APPS synonyms:

  • BEN_PRTL_MO_RT_PRTN_VAL_F — the physical, datetracked table storing partial-month rate proration value definitions. The view is a direct projection of this table's columns, aliased as PPV.
  • FND_SESSIONS — the Applications session table, queried twice in the view predicate to supply the effective date (SS.EFFECTIVE_DATE) bound to the active USERENV('SESSIONID').

Because the predicate is expressed against the _F table, the view is the query-side counterpart to the maintenance-side ( _B / _TL ) objects that Applications forms use when users define proration rules. No joins to lookup or reference tables are performed inside the view; decode logic and foreign-key resolution are left to the calling report or form.

Key Columns

Common Use Cases and Queries

The view is typically consumed by Benefits reports, proration audits, and custom extracts that need the currently effective proration definition for a business group. A representative query:

  • SELECT prtl_mo_rt_prtn_val_id, from_dy_mo_num, to_dy_mo_num, pct_val, rndg_cd FROM apps.ben_prtl_mo_rt_prtn_val WHERE business_group_id = :p_bg_id ORDER BY from_dy_mo_num;
  • Reconciliation: compare proration percentages against ACTL_PREM_ID or ACTY_BASE_RT_ID to validate premium amounts produced during a payroll or billing run. Because the view is session-date sensitive, such a query returns the version in force at the session effective date; to compare historical versions, the _F table must be queried directly with an explicit AS OF or date filter.
  • DFF inspection: select PMRPV_ATTRIBUTE_CATEGORY with the relevant PMRPV_ATTRIBUTEn columns to surface flexfield values captured on each proration definition.

As with all Benefits datetracked views, direct DML against BEN_PRTL_MO_RT_PRTN_VAL is not supported; changes must be made through the Advanced Benefits setup forms or the corresponding _F table APIs.