Results for “ben_prtl_mo_det_mthd”

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

Overview

APPS.BENBV_ACTL_PREM_V is a Business Intelligence (BI) reporting view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes the "Actual Premium" entity (BEN_ACTL_PREM_F) in a denormalized, presentation-ready form suitable for operational reporting, XML Publisher extracts, discoverer workbooks, and OBIEE/BIP integration. The "BV" prefix denotes a Business View, and the view is designed to be consumed directly by end-user reporting tools rather than by application transaction logic.

The view flattens the underlying premium definition into a single row per effective-dated record, and — critically for analytical consumption — decodes every code column into its human-readable lookup meaning. It also resolves the associated compensation object (either a Plan or an Option in Plan) into a display name, and injects a descriptive flexfield token (_DF:BEN:BEN_ACTL_PREM_F:APR) so that reporting engines can render the DFF segment values without an additional join.

The user's search term ben_prspctv_r_rtspctv corresponds to the lookup BEN_PRSPCTV_R_RTSPCTV, which is decoded in this view via the column PRSPTV_R_RTSPTV_CD. This lookup governs the perspective and retro-perspective relationship used when calculating and reporting premiums.

Underlying Base Objects

The view is defined over three documented referenced base objects:

• BEN_ACTL_PREM_F (SYNONYM) — the actual premium definition table. The view aliases this as APR and selects nearly all of its columns, including effective dating, value/rounding rules, limits, and WHO columns.
• BEN_BIS_UTILS (PACKAGE) — provides the helper functions GET_PL_NAME and GET_OIPL_NAME, used in a CASE expression to return the name of the Plan (PL_ID) or Option in Plan (OIPL_ID) that the premium is attached to.
• HR_BIS (PACKAGE) — provides the BIS_DECODE_LOOKUP function, which translates each stored lookup code into its meaning using the Oracle HR lookup framework.

The view performs no joins to child tables in the visible excerpt; relationships to plans, options, organizations, and cost allocation keyflexes are surfaced only as foreign-key ID columns plus the resolved COMP_OBJECT name. The BUSINESS_GROUP_ID scopes every row to a specific business group, which is the standard multi-tenancy segregation in BEN.

Key Columns

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — effective dating for the premium definition; used for date-tracked reporting.
• NAME, UOM, VAL — the premium's name, unit of measure, and value.
• PRTL_MO_DET_MTHD_RL / PRTL_MO_DET_MTHD_CD — partial-month determination method rule and its decoded lookup (BEN_PRTL_MO_DET_MTHD).
• VAL_CALC_RL, RNDG_RL, RNDG_CD — value calculation rule and rounding rule/code (BEN_RNDG).
• UPR_LMT_VAL / LWR_LMT_VAL with corresponding calculation rules — upper and lower premium limits.
• CR_LKBK_VAL, CR_LKBK_UOM, CR_LKBK_CRNT_PY_ONLY_FLAG — credit lookback value and the yes/no indicator decoded via YES_NO.
• VRBL_RT_ADD_ON_CALC_RL — variable rate add-on calculation rule.
• COMP_OBJECT — resolved plan or option-in-plan name.
• PRSPTV_R_RTSPTV_CD — decoded via BEN_PRSPCTV_R_RTSPCTV; this is the lookup the user searched for, controlling perspective/retro-perspective treatment.
• ACTL_PREM_TYP_CD, PREM_ASNMT_CD, PREM_ASNMT_LVL_CD, PREM_PYR_CD, PRDCT_CD, MLT_CD, RT_TYP_CD, BNFT_RT_TYP_CD, ACTY_REF_PERD_CD — each exposed with its BIS_DECODE_LOOKUP meaning.
• ID columns: ACTL_PREM_ID, BUSINESS_GROUP_ID, COST_ALLOCATION_KEYFLEX_ID, ORGANIZATION_ID, OIPL_ID, PL_ID, COMP_LVL_FCTR_ID, plus WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY).

Common Use Cases and Queries

Typical uses include auditing premium definitions, verifying rounding and limit configuration, and driving premium calculation extracts. A basic listing by effective date and perspective/retro-perspective:

SELECT actl_prem_id, name, effective_start_date, effective_end_date,
       uom, val, val_calc_rl, rndg_cd,
       prspvt_r_rtspvt_cd
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date
ORDER BY name;

To compare premiums by their decoded perspective/retro-perspective meaning and view the compensation object they attach to:

SELECT name, comp_object, val, uom,
       bis_decode_lookup('BEN_PRSPCTV_R_RTSPCTV', prspvt_r_rtspvt_cd) meaning
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    pl_id IS NOT NULL;

For a limit-and-rounding audit:

SELECT name, val, rndg_cd, upr_lmt_val, lwr_lmt_val,
       upr_lmt_calc_rl, lwr_lmt_calc_rl
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    val IS NOT NULL;

Because every lookup is pre-decoded, reports built on BENBV_ACTL_PREM_V avoid the need to join FND lookups directly, simplifying SQL and reducing maintenance. The view is best used for query/reporting only; DML against it is not supported, and all updates must be made against the base table BEN_ACTL_PREM_F through the standard Benefits forms or concurrent processes.