Results for “ben_acty_ref_perd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.BENBV_BNFT_PRVDD_LDGR_V is a business-group-secured reporting view over the benefits activity ledger in Oracle E-Business Suite Advanced Benefits (Oracle Benefits). It exposes the rows of the benefit provided ledger — the record of amounts forfeited, provided, rolled up, used, and received in cash for each participant and benefit pool — in a denormalized, code-decoded form suitable for concurrent programs, Oracle Business Intelligence Publisher reports, and integration extracts across both 12.1.1 and 12.2.2.
The view is defined `WITH READ ONLY`, and it filters rows through the security profile business group (`WHERE BPL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, BPL.BUSINESS_GROUP_ID)`). It therefore returns only the ledger data visible to the session's security profile, and never permits DML. The "BV" prefix identifies it as a Benefits view, and the naming pattern indicates it is a display-oriented view used by the Benefits forms and reporting layer.
Underlying Base Objects
The view is defined over two documented objects:
- BEN_BNFT_PRVDD_LDGR_F (referenced via a synonym) — the benefit provided ledger base table, aliased as
BPL. This is a date-tracked (datetrack) table, supplying the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns and all ledger amount attributes. - HR_BIS (PL/pgSQL package) — invoked for the security profile business group (
GET_SEC_PROFILE_BG_ID) and for code translation viaBIS_DECODE_LOOKUP, which converts stored lookup codes into user-facing meanings.
No joins to other tables are present; the view is essentially a projection of BEN_BNFT_PRVDD_LDGR_F with decode and security predicates applied.
Key Columns
- BNFT_PRVDD_LDGR_ID — primary key of the ledger row; used for joins back to the base table.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity window of the ledger entry.
- FRFTD_VAL, PRVDD_VAL, RLD_UP_VAL, USED_VAL, CASH_RECD_VAL — the core ledger amounts: forfeited, provided, rolled up, used, and cash received values.
- CMCD_* and ANN_* variants — the same five measures expressed on a cumulative (CMCD) and annualized (ANN) basis.
- ACTY_REF_PERD_CD — activity reference period code; decoded through the
BEN_ACTY_REF_PERDlookup. This is the column most often sought via the search term ben_acty_ref_perd, and it identifies the period against which the activity is referenced. - CMCD_REF_PERD_CD — the cumulative reference period code, decoded against the same lookup.
- PRTT_RO_OF_UNUSD_AMT_FLAG — flag indicating whether the unused amount is prorated or rolled over; decoded through the
YES_NOlookup. - PER_IN_LER_ID, ACTY_BASE_RT_ID, BNFT_PRVDR_POOL_ID, PRTT_ENRT_RSLT_ID — foreign keys to the person's life event record, activity base rate, benefit provider pool, and participant enrollment result.
- BUSINESS_GROUP_ID — the owning business group, used for the security predicate.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — standard WHO audit columns.
- _DF:BEN:BEN_BNFT_PRVDD_LDGR_F:BPL — a descriptive flexfield token consumed by the framework to append DFF segments.
Common Use Cases and Queries
Typical uses include reconciliation of forfeited versus provided balances, audit reporting on cash-received amounts, and extracts feeding downstream payroll or general ledger. The following query lists decoded activity reference periods for a business group:
SELECT BNFT_PRVDD_LDGR_ID, PER_IN_LER_ID, ACTY_REF_PERD_CD, FRFTD_VAL, PRVDD_VAL, USED_VAL FROM APPS.BENBV_BNFT_PRVDD_LDGR_V WHERE ACTY_REF_PERD_CD = '&p_period';SELECT ACTY_REF_PERD_CD, SUM(PRVDD_VAL) total_provided FROM APPS.BENBV_BNFT_PRVDD_LDGR_V GROUP BY ACTY_REF_PERD_CD;SELECT * FROM APPS.BENBV_BNFT_PRVDD_LDGR_V WHERE PER_IN_LER_ID = :p_ler ORDER BY EFFECTIVE_START_DATE;
Because the view is read-only and security-filtered, it is safe to expose to report consumers; but consumers must set the correct security profile to see rows for the intended business group.
-
This view identifies the benefit pool ledger details for a participant and a benefit provider pool.
APPS.BENBV_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ HR_BIS·Explore BEN module →
-
This view identifies the benefit pool ledger details for a participant and a benefit provider pool.
APPS.BENBV_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ HR_BIS·Explore BEN module →
-
- Retrofitted
APPS.BEN_FLX_ENRT_UOM_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_PER_IN_LER·↳ BEN_PIL_ELCTBL_CHC_POPL·Explore BEN module →
-
- Retrofitted
APPS.BEN_FLX_ENRT_UOM_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_PER_IN_LER·↳ BEN_PIL_ELCTBL_CHC_POPL·Explore BEN module →
-
VIEW: APPS.BEN_PGM_D 12.1.1
-
View: BENBV_COMP_LVL_FCTR_V 12.1.1
This view identifies how to calculate a person's compensation level, for example, base pay, for such purposes as determining eligibility and calculating rates.
APPS.BENBV_COMP_LVL_FCTR_V·↳ BEN_COMP_LVL_FCTR·↳ HR_BIS·Explore BEN module →
-
View: BENBV_COMP_LVL_FCTR_V 12.2.2
This view identifies how to calculate a person's compensation level, for example, base pay, for such purposes as determining eligibility and calculating rates.
APPS.BENBV_COMP_LVL_FCTR_V·↳ BEN_COMP_LVL_FCTR·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.BENBV_ACTL_PREM_V 12.1.1
-
VIEW: APPS.BENBV_ACTL_PREM_V 12.2.2
-
VIEW: APPS.BEN_PGM_D 12.2.2
-
View: BEN_BNFT_PRVDD_LDGR_D 12.2.2
- Retrofitted
APPS.BEN_BNFT_PRVDD_LDGR_D·↳ BEN_ACTY_BASE_RT_F·↳ BEN_BNFT_PRVDD_LDGR_F·↳ BEN_BNFT_PRVDR_POOL_F·Explore BEN module →
-
View: BEN_BNFT_PRVDD_LDGR_D 12.1.1
- Retrofitted
APPS.BEN_BNFT_PRVDD_LDGR_D·↳ BEN_ACTY_BASE_RT_F·↳ BEN_BNFT_PRVDD_LDGR_F·↳ BEN_BNFT_PRVDR_POOL_F·Explore BEN module →
-
VIEW: APPS.BEN_ACTL_PREM_D 12.2.2
-
View: BEN_PGM_D 12.1.1
- Retrofitted
APPS.BEN_PGM_D·↳ BEN_PGM_F·↳ FND_GLOBAL·↳ FND_USER·Explore BEN module →
-
VIEW: APPS.BEN_ACTL_PREM_D 12.1.1
-
VIEW: APPS.BENBV_PGM_V 12.1.1
-
View: BEN_ACTL_PREM_D 12.2.2
APPS.BEN_ACTL_PREM_D·↳ BEN_ACTL_PREM_F·↳ BEN_OIPL_F·↳ BEN_OPT_F·Explore BEN module →
-
View: BENBV_PRTT_RT_VAL_V 12.1.1
This view identifies the information about standard rates, total flex credits, and imputed income calculated for a person enrolled in a plan or option in plan.
APPS.BENBV_PRTT_RT_VAL_V·↳ BEN_PRTT_RT_VAL·↳ HR_BIS·Explore BEN module →
-
View: BEN_PGM_D 12.2.2
- Retrofitted
APPS.BEN_PGM_D·↳ BEN_PGM_F·↳ FND_USER·↳ HR_API·Explore BEN module →
-
This view identifies the persons and the programs or plans not in program for which they have electable choices as a result of a life event.
APPS.BENBV_PIL_ELCTBL_CHC_POPL_V·↳ BEN_PIL_ELCTBL_CHC_POPL·↳ HR_BIS·Explore BEN module →
-
View: BENBV_ACTL_PREM_V 12.1.1
APPS.BENBV_ACTL_PREM_V·↳ BEN_ACTL_PREM_F·↳ BEN_BIS_UTILS·↳ HR_BIS·Explore BEN module →
-
View: BENBV_ACTL_PREM_V 12.2.2
APPS.BENBV_ACTL_PREM_V·↳ BEN_ACTL_PREM_F·↳ BEN_BIS_UTILS·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PRTT_RT_VAL_V 12.2.2
This view identifies the information about standard rates, total flex credits, and imputed income calculated for a person enrolled in a plan or option in plan.
APPS.BENBV_PRTT_RT_VAL_V·↳ BEN_PRTT_RT_VAL·↳ HR_BIS·Explore BEN module →
-
VIEW: APPS.BENBV_PGM_V 12.2.2
-
This view identifies the persons and the programs or plans not in program for which they have electable choices as a result of a life event.
APPS.BENBV_PIL_ELCTBL_CHC_POPL_V·↳ BEN_PIL_ELCTBL_CHC_POPL·↳ HR_BIS·Explore BEN module →