Search Results okl_formulaevaluate_pvt




Overview
Explore in AI Chat

Overview

OKL_FORMULAEVALUATE_PVT is a private PL/SQL package body in the Oracle E-Business Suite Applications (APPS) schema, belonging to the Oracle Lease and Finance Management (OKL) product family. Its role is to provide the runtime evaluation engine for pricing and calculation formulae that drive lease and finance contracts. In Oracle Lease Management, contract terms such as rentals, residuals, interest calculations, and fee assessments are frequently expressed as user-defined formulae rather than fixed values. The OKL_FORMULAEVALUATE_PVT package is the private implementation layer that resolves a formula identifier into its constituent functions, parameters, and operand values, then evaluates those expressions at transaction time.

The package is classified as a PVT (private) API, meaning it is not intended for direct invocation by external integrators. Instead, it is consumed internally by other public OKL packages and by the contract authoring and pricing engines. The documented metadata records six dependent packages that reference OKL_FORMULAEVALUATE_PVT, confirming that it functions as a shared internal service underpinning the broader formula-driven calculation framework.

Key Procedures and Functions

The 12.2.2 documentation lists three documented procedures or functions in this package. The user's search term, eva_getparameterids, corresponds directly to the first of these.

  • EVA_GETPARAMETERIDS — Returns the set of parameter identifiers associated with a given formula. This routine establishes which parameters a formula requires before evaluation can proceed, allowing callers to supply or resolve the corresponding values.
  • EVA_GETPARAMETERVALUES — Retrieves the runtime values for the parameters identified by EVA_GETPARAMETERIDS. It resolves each parameter to its current value so the formula expression can be computed.
  • EVA_GETFUNCTIONVALUE — Evaluates a named or coded formula function and returns its computed result. This is the arithmetic core of the package, applying the resolved parameters and functions to produce a numeric outcome.

Implementation comments in the package body also disclose supporting private functions such as EVA_IsFormulaExists, which validates that a formula identifier exists in the system, and EVA_GetAllFunctions, which populates a function table with function identifier, name, source, and type for a given formula. These private helpers support the evaluation workflow but are not part of the externally documented procedure list.

Tables Accessed

The documented metadata identifies a single table reference accessed through an APPS synonym: PLITBLM. PLITBLM is a standard Oracle EBS PL/SQL table (index-by table) utility object commonly used to exchange or buffer collections between PL/SQL program units. In this package it is most likely used to shuttle parameter identifier and value collections between the evaluation routines and their callers during formula resolution.

The package body comments reference additional formula metadata views — okl_formulae_v, okl_data_src_fnctns_v, okl_operands_v, and okl_fmla_oprnds_v — which supply formula definitions, data source functions, operands, and formula-to-operand relationships respectively. These views are the metadata source that the evaluation routines read to determine which parameters and functions apply to a formula.

Usage Notes

OKL_FORMULAEVALUATE_PVT is invoked internally whenever a lease or finance formula must be priced or recalculated. Typical entry points include the Oracle Lease Management contract authoring forms, where a user selects a formula and the application evaluates it on the fly, and pricing or billing concurrent programs that process contract streams and need to recalculate formula-derived amounts in batch.

Because this is a private (PVT) package, custom code should not call it directly. Developers who need formula evaluation should use the corresponding public OKL APIs, which in turn delegate to OKL_FORMULAEVALUATE_PVT. The dependency of six other packages on this object indicates that any modification or recompilation affects a broad set of dependent program units, so changes must be regression-tested across the OKL pricing and contract modules. In EBS 12.1.1 and 12.2.2 the package is delivered as an Oracle-owned object, and its logic should be treated as closed to customization.