Search Results okl_xtl_pay_invs_b

Overview

The table OKL_XTL_PAY_INVS_B is a core data object within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to store transactional information that is specifically used for creating invoice distributions. This table acts as a critical staging or detail table within the procure-to-pay or lease payment processing flows, holding the granular data necessary for generating accounting distributions for invoices. It serves as a key integration point between lease transaction processing and the Accounts Payable financial engine.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the foreign keys, the table's structure is defined by its relationships and purpose. The primary key column is ID, which uniquely identifies each record. The table holds foreign key references that link it to two primary parent entities. The column TPL_ID links to the transaction line detail (OKL_TXL_AP_INV_LNS_B), connecting the invoice distribution data to its originating lease transaction line. The column XPI_ID_DETAILS links to the external payment invoice header (OKL_EXT_PAY_INVS_B), connecting the distribution details to a higher-level invoice record. Other columns in the table would typically store amounts, accounting codes, distribution types, and other attributes required to successfully create an invoice distribution in the general ledger.

Common Use Cases and Queries

This table is central to processes that generate payable invoices from lease transactions, such as lease payments, maintenance charges, or other billable events. Common operational and reporting use cases include troubleshooting invoice generation errors by examining the prepared distribution data, auditing the linkage between a lease contract line item and its resulting AP invoice distributions, and reconciling amounts between the lease management and payables subledgers. A typical analytical query would join this table to its parent entities to trace the financial lifecycle of a transaction.

SELECT xtl.*, txl.source_line_ref, xpi.invoice_number
FROM OKL_XTL_PAY_INVS_B xtl,
     OKL_TXL_AP_INV_LNS_B txl,
     OKL_EXT_PAY_INVS_B xpi
WHERE xtl.tpl_id = txl.id
AND   xtl.xpi_id_details = xpi.id
AND   xpi.invoice_number = 'INV-12345';

Related Objects

The table maintains documented foreign key relationships with two other key OKL tables, forming a clear data hierarchy:

• OKL_TXL_AP_INV_LNS_B: This table is referenced via the column OKL_XTL_PAY_INVS_B.TPL_ID. It contains the transaction line details that are the source for the payable invoice distributions.
• OKL_EXT_PAY_INVS_B: This table is referenced via the column OKL_XTL_PAY_INVS_B.XPI_ID_DETAILS. It serves as the header record for external payment invoices, to which these distribution details belong.

These relationships indicate that OKL_XTL_PAY_INVS_B is a child table, containing the detailed distribution records for a specific invoice line that is part of a larger external payment invoice.