Search Results ben_prem_pl_oipl_monthly




Overview
Explore in AI Chat

Overview

The APPS.BEN_PREM_PL_OIPL_MONTHLY package is a server-side PL/SQL unit within the Oracle Advanced Benefits (OLTP) schema of Oracle E-Business Suite. Its designation combines several abbreviated concepts: PREM (premium), PL (plan), OIPL (Other Insurance Plan / imputed income processing), and MONTHLY (monthly-basis calculations). The package therefore serves as the monthly premium and imputed-income processing engine for benefit plans, particularly those involving other insurance plans (OIPL) and dependent or imputed coverage valuation.

In functional terms, the package drives the recalculation of premiums and coverage volumes on a monthly cadence, writing the resulting values into the participation and premium tables that underpin benefits enrollment results. It is classified in the ETRM as an OTHER API rather than a public business API, indicating it is primarily intended for internal use by Oracle’s concurrent processing architecture rather than by external integrating applications.

Key Procedures and Functions

ETRM documents two callable units within the package:

  • MAIN — The primary driver procedure. It orchestrates the monthly premium processing cycle, coordinating the retrieval of plan, participation, and rate information and performing the month-by-month premium and volume derivations. It is the entry point from which dependent logic is executed during a concurrent run.
  • GET_COMP_OBJECT_INFO — A supporting function that supplies compensation-related object metadata to the processing logic. It resolves the compensation object information required for premium and imputed-income determination without exposing a public parameter interface.

Consistent with the ETRM classification as an OTHER API, no public parameter lists are published. These routines are implementation-level entry points accessed by Oracle’s own concurrent programs.

Tables Accessed

The package reads and writes a broad set of Advanced Benefits base and result tables, including:

The dependency listing also confirms a reference to APPS.BEN_TYPE, the benefits type definition structure.

Usage Notes

BEN_PREM_PL_OIPL_MONTHLY is invoked indirectly. ETRM shows it is referenced by the packages BEN_FORFEITURE_CONCURRENT and BEN_PREMIUM_PLAN_CONCURRENT, both of which are wrappers for Oracle Advanced Benefits concurrent programs. Practically, the package runs when administrators launch premium recalculation or other-insurance-plan processing concurrent requests, typically during monthly benefits cycles or the annual open enrollment close.

Because it is not a public API, direct invocation from custom code is discouraged; customers requiring premium data should consume the persisted results in the BEN_*_PREM* and enrollment result tables rather than calling MAIN directly. Any change to associated plan or rate configurations should be validated by re-running the standard concurrent programs, which trigger this package through the documented referencing packages.