Search Results okl_billing_util_pvt




Overview
Explore in AI Chat

Overview

OKL_BILLING_UTIL_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle Lease and Finance Management (OKL) billing and invoicing subsystem within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to provide the arithmetic and inquiry utilities required to determine, for a given contract, stream, or invoice, how much has been billed, applied, credited, and remains outstanding. The package is classified as a PVT (private) API, meaning it is intended for internal consumption by other ETRM packages rather than as a published integration point. The metadata confirms that OKL_BILLING_UTIL_PVT is not referenced by any database object directly, but it is referenced by twenty-nine other packages, which confirms its position as a shared, low-level utility layer beneath the public lease billing APIs.

Key Procedures and Functions

The package exposes thirty-five documented procedures and functions, predominantly scalar query helpers that return amounts, dates, or identifiers. They fall into several logical families.

Tables Accessed

Consistent with its calculation role, the package reads and writes a broad set of Oracle Receivables and OKL tables. On the Receivables side it touches AR_ADJUSTMENTS_ALL, AR_DISTRIBUTIONS_ALL, AR_PAYMENT_SCHEDULES_ALL, AR_RECEIVABLE_APPLICATIONS_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUSTOMER_TRX_LINES_ALL to derive applied, adjusted, and credited amounts. On the OKL side it references the billing consolidation tables OKL_CNSLD_AR_HDRS_B, OKL_CNSLD_AR_LINES_B, and OKL_CNSLD_AR_STRMS_B; the invoice and line tables OKL_TRX_AR_INVOICES_B, OKL_TXL_AR_INV_LNS_B, and OKL_TXD_AR_LN_DTLS_B; the contract tables OKC_K_HEADERS_B and OKL_K_HEADERS; the stream type table OKL_STRM_TYPE_B; the selling-invoice tables OKL_EXT_SELL_INVS_B, OKL_XTL_SELL_INVS_B, and OKL_XTL_SELL_INVS_TL; and the governance table OKC_GOVERNANCES. FND_LOG_MESSAGES is used for diagnostic output via FND_LOG and OKL_DEBUG_PUB.

Usage Notes

OKL_BILLING_UTIL_PVT is invoked internally by the ETRM billing and invoicing flow, including the public OKL_API, OKL_DEBUG_PUB, and the twenty-nine dependent packages that call its helpers when assembling invoice balances, adjusting receivables, or reporting remaining amounts. Custom code should generally call the public OKL APIs rather than this private package, but developers extending lease billing logic may reference these utilities when the standard APIs do not expose a required balance. The package is marked VALID in the documented environment and relies on standard dependencies such as FND_API, APP_EXCEPTION, FND_FILE, and FND_PROFILE.