Search Results okl_cnsld_ap_invs_all




Overview
Explore in AI Chat

Overview

OKL_CNSLD_AP_INVS_ALL is the Payables consolidated invoice header table within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Leasing and Finance Management (OKL) module. It stores the header-level record of an invoice that consolidates multiple payables obligations — typically vendor invoices originating from lease, loan, or financing transactions — so that they may be grouped, validated, and transmitted to Oracle Payables as a single accounting and payment event. The table resides in the OKL schema and is documented as a valid, standalone object.

The Data Vault classification derived from its foreign-key structure is standalone, which is a heuristic modeling suggestion rather than a physical constraint. None of the documented foreign keys point to this table as a parent hub or link, so the table is best treated as a self-contained header entity that depends on external reference data rather than participating in a hub-and-link network.

Key Information Stored

The surrogate primary key is CNSLD_AP_INV_ID, enforced by the OKL_CIN_PK constraint and mirrored by the unique index OKL_CNSLD_AP_INVS_ALL_U1 (CNSLD_AP_INV_ID). This column is the business-key candidate referenced by dependent detail tables. The most significant columns include:

Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), the OBJECT_VERSION_NUMBER used for optimistic locking, and the fifteen ATTRIBUTE flex columns are also present.

Common Use Cases and Queries

Typical reporting covers invoice status tracking, payment-method distribution, currency exposure, and reconciliation between OKL consolidated headers and their Payables counterparts.

  • List invoices by status: SELECT CNSLD_AP_INV_ID, INVOICE_NUMBER, TRX_STATUS_CODE FROM OKL_CNSLD_AP_INVS_ALL WHERE TRX_STATUS_CODE = :status;
  • Aggregate by currency: SELECT CURRENCY_CODE, SUM(AMOUNT) FROM OKL_CNSLD_AP_INVS_ALL GROUP BY CURRENCY_CODE;
  • Join to legal entity: SELECT a.CNSLD_AP_INV_ID, a.VENDOR_ID FROM OKL_CNSLD_AP_INVS_ALL a, FV_LEGAL_ENTITIES b WHERE a.LEGAL_ENTITY_ID = b.LEGAL_ENTITY_ID;
  • Drill from header to lines: SELECT h.INVOICE_NUMBER, l.* FROM OKL_CNSLD_AP_INVS_ALL h, OKL_TXL_AP_INV_LNS_ALL_B l WHERE h.CNSLD_AP_INV_ID = l.CNSLD_AP_INV_ID;

Related Objects

  • OKL_TXL_AP_INV_LNS_ALL_B — consolidated invoice lines; joins on CNSLD_AP_INV_ID.
  • OKL_EXT_PAY_INVS_ALL_B — external payables invoice records referencing the header via CNSLD_AP_INV_ID.
  • FV_LEGAL_ENTITIES — legal entity validation for LEGAL_ENTITY_ID.
  • Oracle Payables (AP_INVOICES_ALL) — downstream destination of the consolidated invoice.
  • OKL_TRX_* transaction tables — source lease/loan transactions identified through TRY_ID and related keys.