Search Results okl_ext_pay_invs_all_b

Overview

OKL_EXT_PAY_INVS_ALL_B is a core transactional table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. Per the ETRM metadata, it stores the header information about invoices exported to Oracle Payables (AP). The table acts as the staging and control repository for leasing-generated invoices that must be transferred into the AP subsystem for payment processing. Each row represents one invoice header, carrying the vendor, amount, currency, terms, and status details required to create and reconcile a corresponding AP invoice.

The table resides in the OKL schema and is marked VALID across EBS 12.1.1 and 12.2.2. Its primary key, OKL_EXT_PAY_INVS_ALL_B_PK, is defined on the ID column, and a unique index OKL_EXT_PAY_INVS_ALL_B_U1 also enforces uniqueness on ID. Based on the heuristic Data Vault classification derived from its foreign-key structure, the table is hub-leaning. This suggests a modeling approach where OKL_EXT_PAY_INVS_ALL_B functions as a central hub of invoice-export business keys, with descriptive attributes that could be separated into satellite structures and relationships modeled as links.

Key Information Stored

The table contains 54 documented columns. The most significant are summarized below, distinguishing the surrogate key from business-key candidates.

ID — Surrogate primary key (OKL_EXT_PAY_INVS_ALL_B_PK) and the sole documented unique business-key candidate via OKL_EXT_PAY_INVS_ALL_B_U1. It uniquely identifies each exported invoice header.
INVOICE_ID — Reference to the invoice within the OKL invoice framework.
INVOICE_NUM, INVOICE_TYPE, INVOICE_DATE — Core invoice identity and classification fields.
VENDOR_ID, VENDOR_SITE_ID, VENDOR_INVOICE_NUMBER — Payee information required for AP invoice creation.
INVOICE_AMOUNT, INVOICE_CURRENCY_CODE — Monetary value and currency of the exported invoice.
TERMS_ID, PAYMENT_METHOD, PAY_GROUP_LOOKUP_CODE, DOC_CATEGORY_CODE — Payment and document controls.
PAYABLES_INVOICE_ID — The identifier of the invoice once created in Oracle Payables, enabling reconciliation between OKL and AP.
TRX_STATUS_CODE — Workflow/processing status of the export transaction.
LEGAL_ENTITY_ID — Foreign key to FV_LEGAL_ENTITIES, identifying the legal entity under which the invoice is raised.
CNSLD_AP_INV_ID — Foreign key to OKL_CNSLD_AP_INVS_ALL, linking the header to a consolidated AP invoice record.
ORG_ID — Multi-org operating unit context.
REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — Concurrent program audit columns identifying the export process run.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — Standard WHO audit and optimistic locking columns.

Common Use Cases and Queries

Typical scenarios include monitoring invoice exports, reconciling OKL invoices with AP, and auditing failed or pending transfers. A representative query retrieving invoices awaiting AP creation:

SELECT x.INVOICE_NUM, x.INVOICE_AMOUNT, x.INVOICE_CURRENCY_CODE, x.TRX_STATUS_CODE, x.VENDOR_ID FROM OKL.OKL_EXT_PAY_INVS_ALL_B x WHERE x.PAYABLES_INVOICE_ID IS NULL AND x.ORG_ID = :p_org_id;

Reporting by legal entity joins FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID. Reconciliation reports join OKL_CNSLD_AP_INVS_ALL on CNSLD_AP_INV_ID to trace consolidated AP postings. Concurrent program monitoring uses REQUEST_ID and PROGRAM_ID to group results by export run.

Related Objects

OKL_XTL_PAY_INVS_ALL_B — Child/extension table referencing this table via XPI_ID_DETAILS, holding detail-level export data.
OKL_CNSLD_AP_INVS_ALL — Referenced through CNSLD_AP_INV_ID; consolidated AP invoice records.
FV_LEGAL_ENTITIES — Referenced through LEGAL_ENTITY_ID; legal entity definitions.
Oracle Payables invoice tables (AP_INVOICES_ALL) — Populated upon successful export, reconciled via PAYABLES_INVOICE_ID.
OKL invoice and vendor master objects — Provide the source INVOICE_ID and VENDOR_ID context referenced during export.

Table: OKL_EXT_PAY_INVS_ALL_B 12.2.2
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_EXT_PAY_INVS_ALL_B, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID, product: OKL - Lease and Finance Management , description: Header information about invoices exported to AP , implementation_dba_data: OKL.OKL_EXT_PAY_INVS_ALL_B ,
Table: OKL_EXT_PAY_INVS_ALL_B 12.1.1
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_EXT_PAY_INVS_ALL_B, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID, product: OKL - Leasing and Finance Management , description: Header information about invoices exported to AP , implementation_dba_data: OKL.OKL_EXT_PAY_INVS_ALL_B ,
SYNONYM: APPS.OKL_EXT_PAY_INVS_ALL_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID,
SYNONYM: APPS.OKL_EXT_PAY_INVS_ALL_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID,
VIEW: OKL.OKL_EXT_PAY_INVS_ALL_B# 12.2.2
owner:OKL, object_type:VIEW, object_name:OKL_EXT_PAY_INVS_ALL_B#, status:VALID,
SYNONYM: APPS.OKL_EXT_PAY_INVS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OKL_EXT_PAY_INVS_B, status:VALID,
VIEW: OKL.OKL_EXT_PAY_INVS_ALL_B# 12.2.2
Table: OKL_XTL_PAY_INVS_ALL_B 12.2.2
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_XTL_PAY_INVS_ALL_B, object_name:OKL_XTL_PAY_INVS_ALL_B, status:VALID, product: OKL - Lease and Finance Management , description: Stores information used to create invoice distributions , implementation_dba_data: OKL.OKL_XTL_PAY_INVS_ALL_B ,
Table: OKL_XTL_PAY_INVS_ALL_B 12.1.1
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_XTL_PAY_INVS_ALL_B, object_name:OKL_XTL_PAY_INVS_ALL_B, status:VALID, product: OKL - Leasing and Finance Management , description: Stores information used to create invoice distributions , implementation_dba_data: OKL.OKL_XTL_PAY_INVS_ALL_B ,
PACKAGE BODY: APPS.OKL_XPI_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_XPI_PVT, status:VALID,
SYNONYM: APPS.OKL_EXT_PAY_INVS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OKL_EXT_PAY_INVS_B, status:VALID,
PACKAGE BODY: APPS.OKL_VENDORMERGE_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_VENDORMERGE_GRP, status:VALID,
PACKAGE BODY: APPS.OKL_XPI_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_XPI_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_VENDORMERGE_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_VENDORMERGE_GRP, status:VALID,
TABLE: OKL.OKL_EXT_PAY_INVS_ALL_B 12.1.1
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_EXT_PAY_INVS_ALL_B, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID,
PACKAGE BODY: APPS.OKL_PAY_INVOICES_CONS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_PAY_INVOICES_CONS_PVT, status:VALID,
PACKAGE BODY: APPS.OKL_PAY_INVOICES_CONS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKL_PAY_INVOICES_CONS_PVT, status:VALID,
TABLE: OKL.OKL_EXT_PAY_INVS_ALL_B 12.2.2
owner:OKL, object_type:TABLE, fnd_design_data:OKL.OKL_EXT_PAY_INVS_ALL_B, object_name:OKL_EXT_PAY_INVS_ALL_B, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.OKL_VENDORMERGE_GRP SQL Statements 12.1.1
APPS.OKL_XPI_PVT dependencies on OKL_EXT_PAY_INVS_ALL_B 12.2.2
APPS.OKL_XPI_PVT dependencies on OKL_EXT_PAY_INVS_ALL_B 12.1.1
APPS.OKL_VENDORMERGE_GRP SQL Statements 12.2.2
APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_EXT_PAY_INVS_ALL_B 12.1.1
APPS.OKL_VENDORMERGE_GRP dependencies on OKL_EXT_PAY_INVS_ALL_B 12.1.1
APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_EXT_PAY_INVS_ALL_B 12.2.2
APPS.OKL_VENDORMERGE_GRP dependencies on OKL_EXT_PAY_INVS_ALL_B 12.2.2
APPS.OKL_XPI_PVT SQL Statements 12.1.1
PACKAGE BODY: APPS.OKL_VENDORMERGE_GRP 12.1.1
APPS.OKL_XPI_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.OKL_VENDORMERGE_GRP 12.2.2
APPS.OKL_PAY_INVOICES_CONS_PVT SQL Statements 12.2.2
APPS.OKL_PAY_INVOICES_CONS_PVT SQL Statements 12.1.1
APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_CNSLD_AP_INVS 12.1.1
APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_CNSLD_AP_INVS 12.2.2
eTRM - OKL Tables and Views 12.2.2
description: Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards ,
PACKAGE BODY: APPS.OKL_XPI_PVT 12.2.2
PACKAGE BODY: APPS.OKL_XPI_PVT 12.1.1
eTRM - OKL Tables and Views 12.1.1
description: Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards ,
PACKAGE BODY: APPS.OKL_PAY_INVOICES_CONS_PVT 12.1.1
PACKAGE BODY: APPS.OKL_PAY_INVOICES_CONS_PVT 12.2.2