Search Results okl_cons_bill_pub




Overview
Explore in AI Chat

Overview

The APPS.OKL_CONS_BILL_PUB package is a public (PUB-classified) Oracle E-Business Suite PL/SQL API belonging to the Oracle Lease and Finance Management (OLFM) module, which is part of the ETRM family of applications. Its name is derived from "OKL" (the OLFM schema prefix) and "CONS BILL" (consolidated billing), indicating that the package supports the consolidation and generation of billing transactions for lease and finance contracts. In Oracle Lease Management, billing schedules on individual contracts can be grouped or consolidated prior to invoice generation, and this package provides the application programming interface that drives that consolidation billing logic.

The package is owned by the APPS schema and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2 environments. Its dependency on OKL_API indicates it leverages the shared OLFM API utility layer for common error handling, message retrieval, and logging conventions.

Key Procedures and Functions

The documented public interface exposes two program units, of which the primary named procedure is CREATE_CONS_BILL.

  • CREATE_CONS_BILL — Creates consolidated billing records for lease contracts. This procedure encapsulates the logic required to group contract billing lines and generate the consolidated bill output used downstream by the OLFM billing and invoicing processes. It is the main entry point external programs call to initiate consolidated billing for a contract or set of contracts.
  • Additional documented unit — The package metadata records a total of two procedures/functions; the second is a supporting program unit that accompanies CREATE_CONS_BILL in completing the consolidated billing workflow. Parameter lists are not reproduced here, as the ETRM metadata does not document them.

Tables Accessed

ETRM documents the following table reference for this package:

  • OKL_PARALLEL_PROCESSES — accessed via an APPS synonym. This table tracks parallel processing runs within OLFM. The package reads and/or writes here to coordinate consolidated billing execution with Oracle's parallel concurrent processing framework, enabling large volumes of contract bills to be generated in parallel worker sets rather than serially. This is significant because consolidated billing is often run as a high-volume batch operation across many contracts, and parallelism is essential for performance.

In practice, the package also interacts indirectly with the standard OLFM contract and billing tables (contract headers, billing schedules, and billing lines) through the OKL_API layer and other dependent objects; these are inferred from the business function rather than explicitly enumerated in the ETRM extract.

Usage Notes

Because it is classified as a PUB API, OKL_CONS_BILL_PUB is intended for external invocation — from concurrent programs, Oracle Forms, or custom extensions — rather than being restricted to internal use. The most common invocation pattern is through an OLFM concurrent program responsible for consolidated billing, which resolves and calls CREATE_CONS_BILL for each contract in scope. Custom code should reference it as APPS.OKL_CONS_BILL_PUB and respect the standard OLFM error-handling conventions inherited from OKL_API. The ETRM metadata records that the package is referenced by no other packages, confirming it sits at the top of its call hierarchy rather than being a shared internal utility. Direct SQL manipulation of the underlying billing tables should be avoided in favor of this API to preserve data integrity and support future upgrades.