Search Results okl_cin_pk

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:

• CNSLD_AP_INV_ID — unique identifier for the consolidated invoice header.
• VENDOR_INVOICE_NUMBER and INVOICE_NUMBER — supplier-facing and internal invoice references; INVOICE_NUMBER is the value ultimately transmitted to Payables.
• VENDOR_ID — the supplier against whom the consolidated invoice is raised.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, and CURRENCY_CONVERSION_DATE — the currency and conversion attributes used for accounting.
• AMOUNT and DATE_INVOICED — header total and invoice date.
• TRX_STATUS_CODE and INVOICE_TYPE — processing status and invoice classification.
• PAYMENT_METHOD_CODE and PAY_GROUP_LOOKUP_CODE — payment routing shared across the consolidated lines.
• SET_OF_BOOKS_ID, LEGAL_ENTITY_ID, and ORG_ID — ledgers and multi-org context.
• ACCTS_PAY_CC_ID — the accounts payable code combination used for the liability entry.
• DATE_GL — the general ledger accounting date.
• TRY_ID, IPVS_ID, IPPT_ID, and VPA_ID — linkage to the originating leasing transaction, payment schedule, and payables artifacts.

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.