Search Results ben_ext_bnf




Overview
Explore in AI Chat

Overview

BEN_EXT_BNF is a PL/SQL package in the APPS schema that forms part of the Oracle Advanced Benefits (OAB) extract infrastructure—the framework used to pull participant, plan, and beneficiary data out of the BEN (Benefits) module and stage it for downstream processing, interfaces, or reporting. The "EXT" prefix denotes "extract," while "BNF" refers to beneficiary data. In this design, extract packages such as BEN_EXT_BNF are responsible for collecting a specific slice of benefits data (in this case, beneficiary and related person/contact records) and writing it into a benefits extract staging table for consumption by an extract run, typically driven through the concurrent manager via an extract definition and the BEN_EXT_ENRT engine.

The package is classified as OTHER in the ETRM catalog and is VALID in both Oracle EBS 12.1.1 and 12.2.2. It sits within the broader extract object family and is referenced by the BEN_EXT_ENRT package, which orchestrates the enrollment/extract process.

Key Procedures and Functions

  • MAIN — The single documented entry point for the package. MAIN is the standard naming convention used across BEN extract packages; it encapsulates the package's extract logic and is invoked by the extract engine (BEN_EXT_ENRT) when a benefits extract definition that includes this beneficiary extract is run. Its purpose is to select and stage beneficiary-related data for the defined extract population and write the results to the corresponding extract output/staging structures. As with all extract MAIN procedures, it is not intended to be called directly by end users or custom application code; it is driven by the extract framework configuration.

No other procedures or functions are documented in the ETRM metadata for this package. The package body is categorized alongside a "Package" specification, consistent with the extract architecture in which MAIN is defined in the body and exposed for framework invocation.

Tables Accessed

Per the documented metadata, BEN_EXT_BNF references the following tables through APPS synonyms:

  • BEN_PER_IN_LER — The person-in-life-event/eligibility relationships table, used to identify which persons are included in the extract based on their life event and eligibility records.
  • BEN_PL_BNF_F — The benefit plan beneficiary table, the primary source of beneficiary designation data (who is named as a beneficiary under a given plan/enrollment). This is the core table the package extracts.
  • PER_ADDRESSES — Supplies address details for the identified persons or beneficiaries.
  • PER_ALL_PEOPLE_F — The date-tracked core person record, providing person identity and effective-dated attributes.
  • PER_CONTACT_RELATIONSHIPS — Provides the relationship between the participant and the named beneficiary/contact (for example, spouse, child), which is essential beneficiary context.
  • PER_PHONES — Supplies telephone contact information for the persons involved.

Together these tables allow the package to assemble a complete beneficiary extract record: identity, relationship, contact details, and plan-level beneficiary designation.

Usage Notes

BEN_EXT_BNF is invoked indirectly as part of a configured benefits extract. The typical flow is: a benefits extract definition is set up in the OAB extract setup, an extract run is submitted as a concurrent program, and the BEN_EXT_ENRT engine calls the MAIN procedure of each extract package in the definition—including BEN_EXT_BNF—to stage the relevant data. Because it is an internal framework package, it should not be modified or called directly from custom code; any customization should be performed through the supported extract definition and mapping configuration. It is referenced by BEN_EXT_ENRT and, per the dependency documentation, references itself within the extract object family.