Search Results okl_lrf_interface_pvt




Overview
Explore in AI Chat

Overview

OKL_LRF_INTERFACE_PVT is an Oracle E-Business Suite Oracle Lease and Finance Management (OLFM) private PL/SQL package owned by the APPS schema. The API classification "PVT" indicates that this is an internal, private-layer package rather than a public API intended for direct third-party consumption. Its name derives from "LRF," which within OLFM terminology refers to Lease Rate Factor, and "INTERFACE," indicating that the package manages the staging and processing of rate factor data as it moves between external or bulk data sources and the core OLFM rate factor tables. In Release 12.1.1 and 12.2.2, OLFM relies on rate factor sets and their associated entries to drive lease pricing, interest calculations, and yield computations. This package provides the programmatic bridge that accepts rate factor interface records, validates them, and ultimately persists them into the permanent rate factor set and entry structures. Because it is a private package, its procedures are typically invoked by other OLFM internal packages or by concurrent programs rather than by customer-written code, though the metadata shows it is self-referenced, implying internal recursion or wrapper calls within the same package body.

Key Procedures and Functions

The ETRM documentation identifies three procedures or functions within this package:

  • PURGE_RECORD — Removes processed or invalid records from the LRF interface staging area. This is typically used after a successful load to clean up interface rows so that subsequent runs do not reprocess stale data.
  • PROCESS_RECORD — Handles the validation and transformation of an individual interface record, mapping the staged data into the target rate factor set and entry tables. It applies OLFM business rules through calls to OKL_API before committing the record.
  • GENERATE_LRF — Drives the generation or population of lease rate factor data, orchestrating the creation of rate factor sets and their associated entities. This procedure likely coordinates the bulk processing of interface rows into the definitive LRF structures.

Parameter lists are not documented in the available metadata and should not be assumed.

Tables Accessed

The package reads from and writes to several OLFM tables through APPS synonyms:

  • OKL_LS_RT_FCTR_SETS_B — The base table storing rate factor set headers, including set identifiers and effective dating.
  • OKL_LS_RT_FCTR_SETS_TL — The translation table holding language-specific descriptions for each rate factor set.
  • OKL_LS_RT_FCTR_ENTS — The rate factor set entries table, which stores the individual rate factor values belonging to each set.
  • OKL_LRF_INTERFACE — The staging/interface table that holds incoming rate factor data prior to validation and promotion into the permanent tables.

The package depends on FND_API for standard API error handling and on OKL_API for OLFM-specific validation and utility routines.

Usage Notes

Because OKL_LRF_INTERFACE_PVT is a private package, it is not intended to be called directly from customer extensions. It is normally invoked indirectly through OLFM concurrent programs or internal OLFM processing logic that loads rate factor data, such as rate factor interface import or generation routines. The metadata reports that no other packages reference it, but the package itself references OKL_API, FND_API, and the standard Oracle STANDARD package, confirming that it participates in standard OLFM API error-handling conventions. When debugging rate factor load issues in 12.1.1 or 12.2.2, DBAs and developers commonly search for this package to trace how OKL_LRF_INTERFACE rows are processed, validated, and purged. Custom integrations requiring rate factor loading should prefer the corresponding public OLFM APIs rather than invoking this private package directly, since private packages are subject to change without notice across patches and upgrades.