Search Results po_distributions_all




Overview
Explore in AI Chat

Overview

PO_DISTRIBUTIONS_ALL is the core accounting and receiving distribution table in the Oracle Purchasing (PO) module, owned by the PO schema. It represents the lowest level of granularity on a purchase order, breaking down each purchase order shipment (line location) into one or more accounting distributions that identify the charge account, quantity ordered, quantity delivered, quantity billed, and encumbrance information. Every requisition, purchase order, and release ultimately drives one or more rows in this table, and it serves as the bridge between procurement activity and the General Ledger, receiving, and payables sub-ledgers.

Because it stores both the transactional quantities and the GL account references (CODE_COMBINATION_ID, BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID), PO_DISTRIBUTIONS_ALL is central to encumbrance accounting, accrual reconciliation, and receiving-to-invoice matching. In a Data Vault modeling context, the ETRM metadata classifies this table as hub-leaning. Practically, this suggests treating PO_DISTRIBUTION_ID as a hub or core business key, with the many foreign key references (to PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, GL_CODE_COMBINATIONS, and others) behaving as links connecting the distribution to its surrounding business entities.

Key Information Stored

The table contains 128 documented columns. The most significant include:

Common Use Cases and Queries

Typical uses include PO-to-invoice reconciliation, encumbrance and budget checking, and receiving accrual reporting. A common query joins distributions to headers and lines to report open commitments:

  • Reporting unencumbered and encumbered amounts by account for period-end accrual.
  • Matching receiving transactions to distributions via RCV_TRANSACTIONS.PO_DISTRIBUTION_ID to analyze ordered-versus-delivered quantities.
  • Reconciling AP invoices against PO distributions through AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID for quantity billed and price variance analysis.
  • Tracing requisition-to-PO lineage using REQ_DISTRIBUTION_ID and SOURCE_DISTRIBUTION_ID, including self-referencing chains for blanket releases.

A representative pattern selects PO_DISTRIBUTION_ID, PO_HEADER_ID, PO_LINE_ID, CODE_COMBINATION_ID, QUANTITY_ORDERED and QUANTITY_BILLED, filtering by ORG_ID and joining to PO_LINES_ALL and GL_CODE_COMBINATIONS for account descriptions.

Related Objects