Results for “okl_cnsld_ap_invs”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_CNSLD_AP_INVS_V is an Oracle Applications (APPS) view within the Oracle E-Business Suite Enterprise Contracts (formerly Oracle Lease and Finance Management / ETRM) module. Its name denotes "OKL Consolidated Accounts Payable Invoices View," reflecting its purpose: to expose the consolidated accounts payable (AP) invoice records generated by the contracts-to-payables integration flow. In Oracle EBS 12.1.1 and 12.2.2 the view provides a read layer over the underlying consolidated AP invoice entity, allowing reporting, inquiry, and downstream integration processes to retrieve invoicing information produced during contract billing and payable generation without accessing the base table directly.

The view is defined as a simple projection, selecting all columns present in its base object while prepending the ROWID pseudocolumn. Because it is an unfiltered, non-join view, it returns rows identical in content to the base table, embedding no business logic beyond column exposure. Its principal role is to present the consolidated AP invoice data — vendor invoice number, invoice type, currency, amount, vendor, and lease/contract linkage identifiers — in a stable, referenceable form for inquiries, reports, and interfaces.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, the view is defined exclusively over OKL_CNSLD_AP_INVS (SYNONYM). The owner is APPS, and the runtime source is the synonym OKL_CNSLD_AP_INVS, which resolves to the physical base table of the same name in the ETRM product schema. The view text is a direct SELECT ... FROM OKL_CNSLD_AP_INVS, so the view and the base table share an identical column list and row cardinality. No joins, aggregations, or filters are present, confirming the view acts as a synonym-style access wrapper around a single consolidated AP invoice entity.

Key Columns

• CNSLD_AP_INV_ID — Primary identifier for the consolidated AP invoice record.
• TRX_STATUS_CODE — Transaction status indicating the processing state of the invoice.
• VENDOR_INVOICE_NUMBER / INVOICE_NUMBER — External vendor-issued invoice number and the internally generated invoice number.
• CURRENCY_CODE, CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE — Currency and conversion attributes applied to the invoice amount.
• AMOUNT, DATE_INVOICED, DATE_GL — Invoice amount and key accounting dates for invoicing and general ledger posting.
• INVOICE_TYPE, PAYMENT_METHOD_CODE, PAY_GROUP_LOOKUP_CODE — Payables classification and payment attributes used to drive settlement.
• VENDOR_ID, ORG_ID, LEGAL_ENTITY_ID, SET_OF_BOOKS_ID — Supplier, operating unit, legal entity, and ledger context of the invoice.
• TRY_ID, IPVS_ID, IPPT_ID, VPA_ID, ACCTS_PAY_CC_ID — Contract-side linkage identifiers tying the invoice to its originating lease, payment schedule, and payable code combinations.
• FEE_CHARGED_YN, SELF_BILL_YN, SELF_BILL_INV_NUM, MATCH_REQUIRED_YN — Business flags controlling fee assessment, self-billing, and invoice matching behavior.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Concurrency control and standard audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield (DFF) segments.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context that created or last updated the row.

Common Use Cases and Queries

The view is typically queried to reconcile contract-generated invoices before or after they reach Oracle Payables, to validate currency and conversion information, and to audit linkage between lease transactions and AP invoices.

Sample query listing active invoices for a given ledger and vendor:

SELECT cnsld_ap_inv_id,
       invoice_number,
       vendor_invoice_number,
       vendor_id,
       currency_code,
       amount,
       date_invoiced,
       trx_status_code
  FROM apps.okl_cnsld_ap_invs_v
 WHERE set_of_books_id = :p_ledger_id
   AND vendor_id       = :p_vendor_id;

Sample query checking self-billed invoices and their originating contract linkage:

SELECT cnsld_ap_inv_id,
       self_bill_inv_num,
       try_id,
       ippt_id,
       vpa_id,
       amount,
       fee_charged_yn
  FROM apps.okl_cnsld_ap_invs_v
 WHERE self_bill_yn = 'Y';

Because the view mirrors the base table exactly, it supports the same filtering, joins to other ETRM and Payables views, and use in concurrent reporting programs. Access should be granted through the APPS schema in accordance with standard EBS security practices.