Results for “ler_id”

50+ results




Overview
Explore in AI Chat

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:

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.