Search Results okl_cnsld_ar_hdrs_b_pk

Overview

The OKL_CNSLD_AR_HDRS_B table is a core data object within the Oracle E-Business Suite (EBS) module OKL (Leasing and Finance Management). It serves as the header table for consolidated invoice reports, also referred to as "bills." Its primary function is to represent a single printed document that aggregates and summarizes multiple underlying Accounts Receivable (AR) invoices. This consolidation is a critical feature for lessors and finance managers who need to present a unified billing statement to customers for multiple lease or finance transactions, rather than issuing numerous individual invoices. The table's structure is designed to capture the overarching metadata and control information for this consolidated billing process.

Key Information Stored

The table stores the essential identifiers and control attributes for a consolidated invoice. The primary unique identifier for each record is the ID column, which forms the primary key (OKL_CNSLD_AR_HDRS_B_PK). A second unique key constraint (CNR_CNR_UK) is defined on the CONSOLIDATED_INVOICE_NUMBER, which is the business-facing reference number for the printed bill. A critical foreign key column is INF_ID, which links the consolidated bill header to a specific invoice format defined in the OKL_INVOICE_FORMATS_B table, thereby controlling the layout and presentation rules for the generated document.

Common Use Cases and Queries

The primary use case revolves around generating and managing customer-facing consolidated billing statements. A common reporting requirement is to list all consolidated bills created within a specific period, along with their associated invoice format. A typical query would join the header to the invoice formats table:

• SELECT cnrh.CONSOLIDATED_INVOICE_NUMBER, cnrh.ID, inf.NAME AS FORMAT_NAME FROM OKL_CNSLD_AR_HDRS_B cnrh, OKL_INVOICE_FORMATS_B inf WHERE cnrh.INF_ID = inf.ID AND cnrh.CREATION_DATE BETWEEN :P_START_DATE AND :P_END_DATE;

Another critical operational query involves identifying the detailed AR invoice lines summarized within a specific consolidated bill, which would require joining through related detail tables not explicitly listed in the provided metadata but logically associated with this header.

Related Objects

The table has defined relationships with several other key objects in the OKL schema. It references the OKL_INVOICE_FORMATS_B table via the INF_ID foreign key to determine the printing format. Conversely, it is referenced by the OKL_TXL_RCPT_APPS_B table (likely representing tax receipt applications) through the foreign key column CNR_ID. This indicates that tax receipts can be applied at the level of a consolidated invoice header. It is important to note the metadata states this table is "Not implemented in this database," which may indicate it is a standard EBS object that requires specific configuration or is not used in all implementations of the OKL module.