Results for “okl_xtl_pay_invs_all_b”

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

Overview

OKL_XTL_PAY_INVS_ALL_B is a transactional table owned by the OKL schema within the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its documented purpose is to store information used to create invoice distributions. In practical terms, the table operates as the staging and detail layer that bridges lease payment and billing activity and the Accounts Receivable invoice generation logic in EBS 12.1.1 and 12.2.2. Each row represents a payment invoice detail record that carries the amounts, accounting attributes, and distribution account assignments required for downstream invoice creation.

Under a heuristic Data Vault classification derived from its foreign key structure, this table is best modeled as a link entity. It sits between the external payment invoice data referenced through OKL_EXT_PAY_INVS_ALL_B and the invoice lines in FTE_INVOICE_LINES, and it also references a template identifier (TPL_ID). This classification is a modeling suggestion rather than a documented Oracle design statement; the physical implementation remains a standard EBS transactional table with a single-column surrogate primary key.

Key Information Stored

The table contains 40 documented columns. The most significant are:

• ID — the surrogate primary key, enforced by OKL_XTL_PAY_INVS_ALL_B_PK and reinforced by the unique index OKL_XTL_PAY_INVS_ALL_B_U1. It uniquely identifies each distribution record.
• XPI_ID_DETAILS — foreign key to OKL_EXT_PAY_INVS_ALL_B, tying the record to the external payment invoice header/detail source.
• INVOICE_LINE_ID — foreign key to FTE_INVOICE_LINES, linking the distribution to the generated invoice line in the financials schema.
• TPL_ID — template reference used in the invoice creation process.
• PID_ID, IBI_ID, TAP_ID — related lease/billing identifiers that connect the distribution to payment, billing, and adjustment context within OKL.
• LINE_NUMBER and LINE_TYPE — the sequence and category of the distribution line.
• AMOUNT — the monetary value to be distributed and posted.
• ACCOUNTING_DATE — the date used for accounting and period assignment.
• DIST_CODE_COMBINATION_ID — the accounting flexfield combination to which the amount is distributed.
• TAX_CODE — tax classification applied to the line.
• ORG_ID — the operating unit that owns the transaction, enabling multi-org reporting.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program audit columns identifying which process generated the row.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the EBS framework.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns for auditability.

Common Use Cases and Queries

Typical usage centers on reconciliation and reporting of lease invoice distributions. A common pattern joins the table to its parent external invoice and to the invoice line:

• Reconciling OKL distributions to AR invoice lines by joining on INVOICE_LINE_ID to FTE_INVOICE_LINES.
• Auditing amounts and account combinations for a given operating unit: SELECT id, amount, accounting_date, dist_code_combination_id FROM okl.okl_xtl_pay_invs_all_b WHERE org_id = :org_id;
• Identifying the concurrent request that produced records for troubleshooting: SELECT id, request_id, program_id FROM okl.okl_xtl_pay_invs_all_b WHERE request_id = :req;
• Reporting by template or payment invoice source using TPL_ID and XPI_ID_DETAILS.
• Tracking accounting periods through ACCOUNTING_DATE for subledger period-close analysis.

Because the table carries flexfield and Who columns, it is frequently queried directly rather than through a translated view. Filtering on ORG_ID and ACCOUNTING_DATE is essential for performance in multi-org environments.

Related Objects

• OKL_EXT_PAY_INVS_ALL_B — referenced via XPI_ID_DETAILS; holds the external payment invoice data from which distributions are derived.
• FTE_INVOICE_LINES — referenced via INVOICE_LINE_ID; the financials invoice line that receives the distribution.
• OKL_XTL_PAY_INVS_ALL_B_PK / _U1 — the primary key constraint and unique index on ID.
• OKL_XTL_PAY_INVS_ALL_TL and related _ALL tables — sibling tables in the OKL extensibility (XTL) family that carry translated or supplementary content.
• Lease payment (PID), billing (IBI), and adjustment (TAP) transactional tables referenced through PID_ID, IBI_ID, and TAP_ID.
• AR invoice distribution interfaces — downstream consumers that read these rows to generate Accounts Receivable invoice distributions.