Search Results okl_parameters




Overview
Explore in AI Chat

Overview

OKL_STREAMS_RECON_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and belonging to the Oracle Lease and Finance Management (OKL) module. Its primary business function is to generate the streams reconciliation report, which reconciles the stream amounts recorded against lease and finance contracts. Streams in OKL represent the scheduled financial flows associated with a contract, such as billings, cancellations, and unbilled amounts. The package reconciles total streams, billed streams, cancelled streams, and unbilled streams, then derives the differences between them for reporting purposes.

The reconciliation logic centers on a defined business rule: the difference amount is computed as total billed amount minus billed streams, minus cancelled streams, minus unbilled streams. Where unbilled stream values exist, the report presents amounts broken down by deal type and associated product. Where difference streams exist, the report presents the total billed, unbilled, and cancelled amounts alongside the computed difference. A "PVT" API classification indicates this is an internal, private package not intended for direct external invocation, and it is documented as being referenced by zero other packages, confirming its role as a supporting utility rather than a shared public API.

Key Procedures and Functions

The package exposes two documented procedures:

  • RECON_QRY — The core procedure that generates the streams reconciliation report. It accepts a contract number and an end date as selection criteria and drives the reconciliation of stream amounts across the categories described above. Header comments indicate it was originally created in January 2004 (bug 3344086) and has been versioned through multiple revisions.
  • XML_RECON_QRY — A variant that produces the reconciliation output in XML format, supporting structured or integration-oriented reporting consumption.

No parameter lists are documented in the available metadata, and none should be assumed beyond the documented contract number and end date inputs associated with the reconciliation report.

Tables Accessed

The package reads from and interacts with the following documented tables, accessible via APPS synonyms:

  • OKC_K_HEADERS_B and OKL_K_HEADERS — Contract header data, supplying contract number and authoring organization context.
  • OKC_K_LINES_B — Contract line information for the contracts being reconciled.
  • OKC_STATUSES_B — Status code definitions used to interpret contract and line states.
  • OKL_STREAMS, OKL_STRM_ELEMENTS, and OKL_STRM_TYPE_B — The stream records, their elements, and stream type definitions central to reconciliation.
  • OKL_PRODUCTS — Product information used to associate stream amounts with products.
  • OKL_G_REPORTS_GT — A global temporary table used to stage report results.
  • FND_LOOKUP_VALUES — Lookup codes for decoding enumerated values.
  • UTL_FILE and PLITBLM — Oracle-supplied utilities for file output and PL/SQL table handling, consistent with report generation and XML emission.

Usage Notes

As a private (PVT) package with no documented dependents, OKL_STREAMS_RECON_PVT is not intended for direct invocation by custom code. It is typically invoked indirectly through the streams reconciliation concurrent program, with the report output produced via UTL_FILE or XML procedures. The presence of OUT NOCOPY error buffer and return code parameters in RECON_QRY is consistent with the standard Oracle EBS concurrent program interface (ERRBUF and RETCODE). Because the APPS synonym references contract header, stream, and product tables, the package operates strictly within the OKL leasing data model. Customizations should not call this package directly, as its interface and behavior are internal and subject to change across patch levels.