Search Results consolidation_inv




Overview
Explore in AI Chat

Overview

OKL_PAY_INVOICES_CONS_PUB is a public PL/SQL API within the Oracle Lease and Finance Management (OLFM) module of Oracle E-Business Suite, owned by the APPS schema. It provides the published entry point for the consolidation of payable invoices generated against lease and loan contracts. In the leasing workflow, disbursements and periodic payables are captured against contract streams and then forwarded to Oracle Payables for supplier settlement. The consolidation process gathers the individual payment records maintained in OLFM and prepares them for transfer to the payables interface, ensuring that amounts due to a vendor for a given contract or supplier grouping are aggregated and validated before they reach the financials sub-ledger.

The package is classified as a PUB (public) API, meaning its procedures form part of the supported programmatic interface for the OLFM application and may be called from other modules, concurrent programs, or custom extensions. The header comment referencing "Disbursement changes for R12B" indicates the package was refactored to support R12 disbursement functionality, and it remains valid across 12.1.1 and 12.2.2.

Key Procedures and Functions

Two procedures are documented in the public specification:

  • CONSOLIDATION — The core programmatic API for invoice consolidation. It follows the standard EBS API convention with an API version parameter, an initialization flag, and the standard return status, message count, and message data OUT parameters. It accepts filter criteria including contract number, vendor, vendor site, VPA number, stream type purpose, and a from/to date range. It is intended to be embedded in custom code or other PL/SQL callers that require consolidation processing within a transaction.
  • CONSOLIDATION_INV — The concurrent-program wrapper for the same consolidation logic. It uses the standard concurrent program signature with errbuf and retcode OUT parameters, followed by the same filter parameters. This procedure is designed to be registered against an Oracle EBS concurrent program so that invoice consolidation can be submitted and monitored from the standard concurrent manager interface.

No parameter lists are reproduced here beyond what the documentation records; both procedures share the same business filter set introduced for the R12B disbursement changes.

Tables Accessed

The documented table reference for this package is OKL_EXT_PAY_INVS_B (accessed via an APPS synonym), the external payables invoices base table that stores payable invoice records generated from lease contracts. The consolidation procedures read and update this table to identify eligible invoice records, aggregate or group them according to the supplied contract, vendor, vendor site, VPA, stream type purpose, and date filters, and prepare them for downstream processing. Because consolidation modifies invoice state and grouping, the table is both read and written during execution.

Usage Notes

OKL_PAY_INVOICES_CONS_PUB is typically invoked in one of two ways. First, through the CONSOLIDATION_INV concurrent program, which is submitted from the Lease Management responsibility or from a scheduled concurrent request to consolidate payable invoices in bulk for a set of contracts or vendors. Second, through the CONSOLIDATION procedure, which may be called directly from custom PL/SQL, forms-based logic, or wrapper programs that require finer transactional control.

Callers should always inspect x_return_status (or retcode for the concurrent version) and the returned message stack, since validation failures and unexpected errors follow the standard OKC_API error-handling conventions (G_UNEXPECTED_ERROR, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN). Direct inserts or updates against OKL_EXT_PAY_INVS_B are not recommended; the public API should be used to preserve the integrity of the disbursement and payables integration.