Results for “per_in_ler_id”

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

Overview

BEN_FLX_ENRT_UOM_INFO_V is a valid Oracle E-Business Suite view owned by the APPS schema and delivered under the BEN (Advanced Benefits) product family. It is documented in ETRM for both 12.1.1 and 12.2.2 and is described as "Retrofitted," indicating it was introduced or reworked during the OAF/HTML-based Benefits enrollment redesign introduced in Release 12. The view exposes the unit of measure (UOM) and activity reference period information associated with election choices available to a participant within a specific program and life event. Its primary role is to support the Flex Enrollment user interface and associated reporting by resolving the list of eligible elective choices and their associated UOM and period code context for the currently connected session.

Underlying Base Objects

The view is defined over several base objects in the APPS schema, all surfaced as synonyms at runtime:

• BEN_ELIG_PER_ELCTBL_CHC (EPE) — the eligibility record linking a program to the elective choices a participant may elect.
• BEN_PIL_ELCTBL_CHC_POPL (PEL) — the participant-level population records carrying the UOM and ACTY_REF_PERD_CD attributes.
• BEN_PER_IN_LER (PIL) — the person-in-life-event record that anchors the individual to a life event.
• HR_LOOKUPS (HL1) — the lookup view supplying the MEANING for the period code from the lookup type BEN_ACTY_REF_PERD.
• FND_SESSIONS (SE) — used to obtain the effective date for the active session.
• HR_API — referenced as a package dependency.

Joins link PIL.PER_IN_LER_ID to PEL.PER_IN_LER_ID and PGM_ID/ PER_IN_LER_ID to EPE respectively, so the view effectively projects only those elective choices whose eligibility, population, and person-in-life-event records are consistent and current.

Key Columns

• UOM — the unit of measure associated with the participant's election choice population.
• ACTY_REF_PERD_CD — the activity reference period code. This is the column of interest to users searching on this term; it identifies the reference period (e.g. plan year, month) applicable to the election activity.
• MEANING — the lookup meaning for ACTY_REF_PERD_CD, retrieved from HR_LOOKUPS via LOOKUP_TYPE = 'BEN_ACTY_REF_PERD'.
• PERSON_ID, LER_ID, PER_IN_LER_ID, PGM_ID, BUSINESS_GROUP_ID — the identity and context keys linking the record to the person, life event, program, and operating unit.

Common Use Cases and Queries

Because the view is session-driven (it joins FND_SESSIONS and filters on USERENV('SESSIONID')), it is most useful when called from within an active Applications session or from a report that has established an effective date. A typical query to view the period codes and their meanings is:

SELECT uom, acty_ref_perd_cd, meaning, person_id, pgm_id
FROM   apps.ben_flx_enrt_uom_info_v
WHERE  acty_ref_perd_cd IS NOT NULL;

Common scenarios include validating that the correct activity reference period is applied to a participant's open enrollment record, debugging enrollment display issues where the UOM appears incorrect, and reconciling the period codes returned by the UI against the BEN_ACTY_REF_PERD lookup. Because the view depends on FND_SESSIONS, it is important to note that it will return no rows outside an established session context; for batch or extract reporting, the underlying BEN_PIL_ELCTBL_CHC_POPL table joined directly to HR_LOOKUPS is typically a more reliable source.