Search Results ben_assignment_internal




Overview
Explore in AI Chat

Overview

BEN_ASSIGNMENT_INTERNAL is an internal PL/SQL package owned by the APPS schema in Oracle E-Business Suite Advanced Benefits (Oracle Benefits). Its central business function is to bridge Oracle HRMS assignment records and Benefits enrollment entities. Assignment records in PER_ALL_ASSIGNMENTS_F describe an employee's or dependant's placement within an organization, payroll, and benefits primary care provider setup. Benefits, however, evaluates eligibility and enrollment against its own derived constructs, such as the assignment enrollment information used during life event processing, eligibility determination, and enrollment result generation. BEN_ASSIGNMENT_INTERNAL performs the conversion, derivation, and validation logic required to keep those two worlds synchronized.

The package is classified as an internal (non-public) API, meaning Oracle does not publish it as a supported extension point. It is invoked by other Benefits modules rather than by end users directly, and its procedures are subject to change between releases. The ETRM metadata shows the package is VALID in the APPS schema and is referenced by several higher-level Benefits packages.

Key Procedures and Functions

Three program units are documented in the package specification and body:

  • COPY_EMPASG_TO_BENASG — Copies employee assignment data from the HRMS assignment model into the Benefits assignment representation. This supports the population and refresh of Benefits-side assignment information so that eligibility and enrollment processes operate against a consistent snapshot.
  • DERIVE_AEI_INFORMATION — Derives Assignment Extra Information (AEI) values used by Benefits processing. This routine computes or refreshes the derived attributes that Benefits rules and life event evaluations depend upon.
  • CHECK_BNFT_ASGN — Validates the benefit assignment, returning a check outcome used by callers to determine whether the assignment is eligible or correctly formed for benefits processing.

Parameter lists are not exposed in the documentation metadata and are therefore not reproduced here. In practice, these units operate on a person and assignment identifier pair, together with an effective date, in keeping with the effective-dated design of Oracle HRMS.

Tables Accessed

The package reads from and writes to a broad set of HRMS and Benefits tables, primarily through APPS synonyms:

Usage Notes

BEN_ASSIGNMENT_INTERNAL is an internal library rather than a user-facing API. It is not exposed through a concurrent program or a standard form of its own. Instead it is called by Benefits processing packages, including BEN_DT_TRGR_HANDLE (date-track trigger handling), BEN_EVALUATE_PTNL_LF_EVT (potential life event evaluation), BEN_MAINTAIN_DESIGNEE_ELIG (designee eligibility maintenance), and BEN_MANAGE_LIFE_EVENTS (life event management). These callers execute the package during life event processing, eligibility re-evaluation, and enrollment result maintenance.

Because the package is internal, custom code should not call it directly; doing so risks breakage on patching or upgrade. Integrations that require assignment-to-benefits synchronization should instead use supported public Benefits APIs or the documented open interfaces. When troubleshooting eligibility or enrollment discrepancies in 12.1.1 or 12.2.2, DBAs and developers commonly inspect this package's logic to understand why a derived assignment attribute or enrollment result differs from the HRMS assignment record.