Search Results ap_payment_distributions_all




Overview
Explore in AI Chat

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.

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.