Search Results ap_payment_distributions_pk

Overview

The AP_PAYMENT_DISTRIBUTIONS_ALL table is a core Payables (AP) transaction table that stores the accounting distribution information generated when an invoice payment is created, formatted, or accounted. Each row represents a single distribution line associated with a payment line, capturing how the payment amount is distributed across accounting flexfield combinations and how it is recorded in both entered and functional currency. In Oracle EBS 12.1.1 and 12.2.2, this table is owned by the AP schema and is the primary repository that drives the accounting entries passed to General Ledger for the payment side of the payables cycle.

From a heuristic Data Vault modeling perspective, the table exhibits the characteristics of a link entity. Its primary key, AP_PAYMENT_DISTRIBUTIONS_PK, is composed of the two foreign-key-like business columns INVOICE_PAYMENT_ID and PAYMENT_LINE_NUMBER, which together connect a payment record to its distribution lines. This composite structure — rather than a single surrogate identifier — is the hallmark of a relationship (link) object that resolves the association between an invoice payment and the underlying accounting distributions.

Key Information Stored

The documented physical schema contains 18 columns. The most significant are described below.

• INVOICE_PAYMENT_ID — Identifier linking the distribution to its parent payment record in AP_INVOICE_PAYMENTS_ALL. This column is also part of the primary key.
• PAYMENT_LINE_NUMBER — The line number within the payment; combined with INVOICE_PAYMENT_ID it forms the primary key and the unique business key.
• DIST_CODE_COMBINATION_ID — The distribution account (charge account) to which the payment amount is posted; references GL_CODE_COMBINATIONS.
• ACCTS_PAY_CODE_COMBINATION_ID — The Accounts Payable liability account used on the payment distribution; also references GL_CODE_COMBINATIONS.
• LINE_TYPE_LOOKUP_CODE — Identifies the type of distribution line (for example, the accounting line category).
• AMOUNT / BASE_AMOUNT — The distribution amount in the entered currency and its equivalent in the functional (base) currency.
• INV_CURR_AMOUNT / INV_CURR_BASE_AMOUNT — The invoice-currency amount and its base-currency equivalent, supporting multi-currency reconciliation between the invoice and the payment.
• INVOICE_DISTR_LINE_NUMBER — Cross-reference to the originating invoice distribution line.
• UNBUILT_FLEX / UNBUILT_FLEX_REASON — Flags and reason codes used when the accounting flexfield could not be fully built at creation time.
• ORG_ID — The operating unit that owns the distribution, enforcing multi-org security.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard WHO audit tracking.

The surrogate-style primary key is AP_PAYMENT_DISTRIBUTIONS_PK (INVOICE_PAYMENT_ID, PAYMENT_LINE_NUMBER), and the unique index AP_PAYMENT_DISTRIBUTIONS_U1 mirrors the same two columns, confirming that this composite pair is the authoritative business-key candidate.

Common Use Cases and Queries

Typical scenarios include reconciling payment accounting to General Ledger, reporting cash requirements by operating unit, and investigating unaccounted or partially built distributions. A representative query joining payments to their distributions is:

SELECT pd.invoice_payment_id, pd.payment_line_number, pd.line_type_lookup_code, pd.amount, pd.base_amount, pd.dist_code_combination_id FROM ap.ap_payment_distributions_all pd WHERE pd.invoice_payment_id = :p_payment_id ORDER BY pd.payment_line_number;

Analysts frequently filter on UNBUILT_FLEX to locate distributions requiring correction, and join DIST_CODE_COMBINATION_ID to GL_CODE_COMBINATIONS to resolve the full accounting flexfield for reporting. Because the table is partitioned by ORG_ID, queries should include the operating unit predicate to leverage partitioning and honor multi-org access.

Related Objects

The most significant related objects, derived from the documented foreign-key structure, are:

• AP_INVOICE_PAYMENTS_ALL — Parent payment table; joined on INVOICE_PAYMENT_ID.
• GL_CODE_COMBINATIONS — Joined via DIST_CODE_COMBINATION_ID for the distribution account.
• GL_CODE_COMBINATIONS — Joined a second time via ACCTS_PAY_CODE_COMBINATION_ID for the liability account.
• AP_PAYMENT_SCHEDULES_ALL — Related payment schedule detail commonly joined by invoice payment context for reconciliation.
• AP_INVOICES_ALL — Upstream invoice source that ultimately feeds the payment distributions.
• AP_INVOICE_DISTRIBUTIONS_ALL — Invoice-side distributions cross-referenced by INVOICE_DISTR_LINE_NUMBER.
• GL_JE_LINES / GL_IMPORT_REFERENCES — Receives the accounting entries generated from these distributions.