Search Results ghr_fehb_plan_design




Overview
Explore in AI Chat

Overview

The APPS.GHR_FEHB_PLAN_DESIGN package is a PL/SQL database object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that supports the configuration and migration of Flexible Benefits (FEHB) plan designs. In the context of Oracle Advanced Benefits (OAB) and the broader Oracle Human Resources (HR) suite, this package operates as a backend utility that programmatically constructs the foundational data structures required to define benefit programs, plans, and their associated eligibility and processing rules.

The package is classified as an "OTHER" API type within the ETRM (E-Business Suite Technical Reference Manual) metadata, indicating that it is not a public, supported API intended for direct external invocation, but rather an internal component used by application flows or migration routines. Its primary business function is to automate the creation and population of benefit plan design records, thereby reducing manual setup effort during implementation or data migration projects. This is particularly relevant for organizations adopting Oracle's Flexible Benefits module, where complex plan hierarchies and life event rules must be established. The package encapsulates the logic needed to transform source data into the specific table structures required by Oracle Advanced Benefits.

Key Procedures and Functions

The package exposes six documented procedures, each fulfilling a distinct role in the plan design and migration process:

  • CREATE_PERSON_TYPE_USAGES: Establishes the relationship between person types and the benefit plans or programs they are eligible for, ensuring that the correct populations are associated with the relevant offerings.
  • CREATE_PROGRAM_AND_PLANS: Generates the core benefit program and plan records, forming the hierarchical structure that defines what benefits are available to employees.
  • POPULATE_FEHB_PLAN_DESIGN: Serves as the central driver that populates the plan design tables with data, likely orchestrating the other procedures to complete the design setup.
  • CREATE_SUB_LIFE_EVENTS: Defines subordinate life events that can trigger changes in benefit elections, supporting the complex event-driven logic of Flexible Benefits.
  • CREATE_COLLAPSE_RULE: Establishes rules that determine how multiple life events are collapsed or prioritized, preventing conflicting elections and ensuring consistent processing.
  • GET_RECS_FOR_FEHB_MIGRATION: Retrieves records specifically for FEHB migration purposes, acting as a data extraction or validation step prior to loading legacy data into the new plan design.

No parameter lists are documented in the ETRM metadata, and the procedures should be assumed to rely on context established by the calling process or session.

Tables Accessed

The package interacts with a range of benefit and HR tables via APPS synonyms. Key tables include BEN_PGM_F (benefit programs), BEN_OPT_F (benefit options), and BEN_LER_F (life event reasons), which are directly written to when creating programs, plans, and life events. Configuration tables such as BEN_CLPSE_LF_EVT_F (collapse life events) and the BEN_LER_PER_INFO_CS_LER_F / BEN_PER_INFO_CHG_CS_LER_F tables support the creation of collapse rules and life event triggers based on person information changes. Payroll integration is facilitated through PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_TYPES_F, linking benefit plans to payroll elements. The package also references PER_ALL_ASSIGNMENTS_F for assignment data, FF_FORMULAS_F for formula definitions, FND_LOOKUP_VALUES for lookup codes, and the PQH_COPY_ENTITY_TXNS and PQH_TRANSACTION_CATEGORIES tables, which are associated with the Public Sector HR (PQH) module and suggest a copy or transaction-based migration mechanism.

Usage Notes

As an internal, non-public package, GHR_FEHB_PLAN_DESIGN is not intended for direct invocation from custom forms or concurrent programs. It is typically executed by Oracle's own setup or migration flows within the Advanced Benefits module, particularly during the implementation of FEHB plan designs or when upgrading between EBS releases. The presence of the GET_RECS_FOR_FEHB_MIGRATION procedure indicates that the package may be called by a concurrent program or a one-time migration script to extract and transform legacy data. Developers should not rely on this package as a stable API; instead, they should use supported Oracle APIs for benefits configuration. Any custom code referencing this package should be thoroughly tested during patching or upgrades, as internal packages may change without notice. The package is marked VALID in the ETRM, indicating that it is compiled and operational in the documented environment.