Search Results okl_cnsld_ar_strms_b




Overview
Explore in AI Chat

Overview

The OKL_CNSLD_AR_STRMS_B table is a core transaction-level data store within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. Its primary function is to represent the lowest-level transaction detail that is aggregated into a consolidated bill. This table serves as a critical junction point in the billing and revenue recognition processes, linking individual financial streams from lease contracts to their consolidated billing lines. It is essential for tracking the granular composition of invoices generated by the system, enabling detailed audit trails and reconciliation between contract line items and final customer statements.

Key Information Stored

While specific column details are not fully enumerated in the provided metadata, the table's structure and relationships reveal its key data elements. The primary key is the ID column, uniquely identifying each consolidated stream record. The table's foreign key relationships are its most defining feature, storing identifiers that link to major leasing entities. The KHR_ID column references the lease contract header (OKL_K_HEADERS), and the KLE_ID column references the specific contract line (OKL_K_LINES). The LLN_ID column links the stream to its parent consolidated billing line in OKL_CNSLD_AR_LINES_B. Finally, the STY_ID column associates the transaction with a specific stream type defined in OKL_STRM_TYPE_B, classifying the nature of the charge (e.g., rent, tax, fee). Collectively, these fields store the essential pointers that map a source contract transaction to its position within a consolidated accounts receivable invoice.

Common Use Cases and Queries

This table is central to inquiries about the detailed makeup of consolidated invoices. A common use case is tracing all underlying lease transactions included on a specific customer invoice for billing verification or dispute resolution. Another is analyzing revenue streams by type across a portfolio. A typical reporting query would join this table to its related master data to produce a detailed invoice breakdown.

  • Sample Query for Invoice Detail: SELECT cns.khr_id, cns.kle_id, cns.sty_id, sty.name stream_type, khr.contract_number, kle.line_number FROM okl_cnsld_ar_strms_b cns JOIN okl_k_headers khr ON cns.khr_id = khr.id JOIN okl_k_lines kle ON cns.kle_id = kle.id JOIN okl_strm_type_b sty ON cns.sty_id = sty.id WHERE cns.lln_id = :consolidated_line_id;
  • Revenue Reconciliation: The table is used to reconcile total billable amounts from contract streams to the totals posted in the AR module, ensuring data integrity between the leasing subledger and the general ledger.

Related Objects

The OKL_CNSLD_AR_STRMS_B table has extensive integration within the OKL schema, acting as a hub for transaction-level data. Its primary relationships are foundational: OKL_K_HEADERS and OKL_K_LINES for contract data, OKL_CNSLD_AR_LINES_B for the parent billing line, and OKL_STRM_TYPE_B for classification. Notably, it is also referenced as a foreign key by several transactional interface and processing tables, including OKL_TXL_RCPT_APPS_B, OKL_TXL_AP_INV_LNS_B, OKL_XTL_CSH_APPS_B, and OKL_XTL_SELL_INVS_B (along with their "_ALL" variants). This indicates that records in OKL_CNSLD_AR_STRMS_B are directly used in downstream processes for cash application, accounts payable invoice matching, and sell-to-third-party transactions, highlighting its pivotal role in the end-to-end leasing financial lifecycle.