Search Results ben_acty_ref_perd




Overview
Explore in AI Chat

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 via BIS_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_PERD lookup. 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_NO lookup.
  • 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.