Search Results okl_cnsld_ar_hdrs_all_b




Overview
Explore in AI Chat

Overview

OKL_CNSLD_AR_HDRS_ALL_B is a transactional header table in the OKL (Leasing and Finance Management) schema that stores consolidated accounts receivable billing records. It represents a single printed report or "bill" that groups together many actual Oracle Receivables invoices into one customer-facing document. This consolidation capability allows leasing operations to present a unified invoice to a lessee rather than issuing multiple discrete AR invoices for individual lease transactions, thereby simplifying customer billing and reconciliation.

Each row in this table corresponds to one consolidated invoice header, identified by a unique consolidated invoice number within a given set of books. The table carries 41 documented columns, capturing financial amounts, status, currency, dates, and the various lease transaction references (IBT, IXX, IRM) that contributed to the consolidated bill.

Based on the foreign key topology and the absence of downstream dependents documented in the ETRM metadata, the heuristic Data Vault classification for this object is satellite-leaning. This suggests that OKL_CNSLD_AR_HDRS_ALL_B functions primarily as a descriptive, attribute-bearing entity that records the state and characteristics of a consolidation event, referencing dimension-like parents such as invoice formats and legal entities rather than acting as a central hub or transaction link.

Key Information Stored

The table's surrogate primary key is ID, enforced through the index OKL_CNSLD_AR_HDRS_ALL_B_PK and the uniqueness constraint OKL_CNSLD_AR_HDRS_ALL_B_U1. Beyond this technical identifier, the business key is composed of SET_OF_BOOKS_ID together with CONSOLIDATED_INVOICE_NUMBER, enforced by the unique index OKL_CNSLD_AR_HDRS_ALL_B_U2. These two columns together distinguish a consolidated bill within a specific ledger context.

The most operationally significant columns include:

  • CONSOLIDATED_INVOICE_NUMBER — the user-visible identifier of the consolidated bill.
  • SET_OF_BOOKS_ID — the ledger (set of books) under which the bill is recorded.
  • TRX_STATUS_CODE — the processing state of the consolidated invoice (for example, draft, printed, or completed).
  • AMOUNT — the total monetary value consolidated into the bill.
  • CURRENCY_CODE — the currency in which the amount is denominated.
  • DUE_DATE — the payment due date of the consolidated invoice.
  • DATE_CONSOLIDATED — the date on which the consolidation was performed.
  • INVOICE_PULL_YN — a flag indicating whether individual invoices were pulled into the consolidated bill.
  • INF_ID — foreign key to the invoice format definition used to render the bill.
  • LEGAL_ENTITY_ID — the legal entity that owns the billing relationship.
  • IBT_ID, IXX_ID, IRM_ID — references to the underlying leasing transaction streams consolidated into this header.
  • OBJECT_VERSION_NUMBER — optimistic locking control for concurrent updates.
  • REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — the concurrent request and program that created the record.
  • ORG_ID — the operating unit context, supporting multi-org access control.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — a standard EBS descriptive flexfield column set for extensibility.

Common Use Cases and Queries

Typical usage centers on billing reconciliation, status reporting, and audit. A common query retrieves consolidated bills for a given ledger and status:

  • Listing all consolidated invoices for a set of books: SELECT CONSOLIDATED_INVOICE_NUMBER, AMOUNT, CURRENCY_CODE, DUE_DATE FROM OKL_CNSLD_AR_HDRS_ALL_B WHERE SET_OF_BOOKS_ID = :p_sob AND TRX_STATUS_CODE = 'COMPLETED';
  • Identifying bills created by a specific concurrent program run: SELECT * FROM OKL_CNSLD_AR_HDRS_ALL_B WHERE REQUEST_ID = :req_id;
  • Currency exposure reporting: aggregating AMOUNT by CURRENCY_CODE for a legal entity.
  • Tracking consolidation trends over time using DATE_CONSOLIDATED.
  • Joining to OKL_INV_FORMATS_ALL_B via INF_ID to determine which print format was applied.

Because the table stores one row per consolidated bill, reporting layers frequently use it as the anchor for drill-down queries into the constituent AR invoices.

Related Objects

The following objects are the most significant related entities, based on the documented foreign key and indexing metadata:

  • OKL_INV_FORMATS_ALL_B — joined via OKL_CNSLD_AR_HDRS_ALL_B.INF_ID = OKL_INV_FORMATS_ALL_B.INF_ID; defines the invoice display format.
  • FV_LEGAL_ENTITIES — joined via OKL_CNSLD_AR_HDRS_ALL_B.LEGAL_ENTITY_ID = FV_LEGAL_ENTITIES.LEGAL_ENTITY_ID; supplies legal entity details.
  • OKL_CNSLD_AR_HDRS_ALL_TL — the translation table (where present) supplying language-specific text.
  • OKL_INVOICES_ALL — the individual lease invoices referenced by consolidation.
  • RA_CUSTOMER_TRX_ALL — the Oracle Receivables transaction headers corresponding to the printed bills.
  • OKL_TRX_HEADERS_ALL — upstream leasing transaction headers feeding the consolidation.
  • GL_SETS_OF_BOOKS / FND_LEGAL_ENTITIES — ledger context for SET_OF_BOOKS_ID and LEGAL_ENTITY_ID.
  • FND_CONCURRENT_REQUESTS — joined via REQUEST_ID for concurrent program traceability.

Together these objects support the end-to-end flow from lease transaction through consolidation to printed receivable bill.