Search Results po_distributions_all




Overview
Explore in AI Chat

Overview

The PO_DISTRIBUTIONS_ALL table is a core transactional entity within Oracle E-Business Suite Purchasing (PO) module, specifically in releases 12.1.1 and 12.2.2. It stores the detailed accounting and logistical distribution information for each purchase order line. While a purchase order line defines the item or service being procured, its distributions define how the cost is allocated across one or more accounting segments (e.g., department, account, project) and specify destination details for physical items. This table is fundamental for financial integration, enabling costs to be properly charged to the correct general ledger accounts and facilitating the matching process between purchase orders, receipts, and invoices.

Key Information Stored

The table's structure captures financial, logistical, and relational data. Its primary key is PO_DISTRIBUTION_ID, a unique system-generated identifier. Key columns include PO_HEADER_ID, PO_LINE_ID, and LINE_LOCATION_ID, linking the distribution to its parent documents. Critical accounting fields are CODE_COMBINATION_ID (the charge account), BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, and VARIANCE_ACCOUNT_ID, all referencing GL_CODE_COMBINATIONS. For inventory items, DESTINATION_ORGANIZATION_ID and DESTINATION_SUBINVENTORY specify where goods are to be received. The REQ_DISTRIBUTION_ID links back to the originating requisition distribution, maintaining the procurement audit trail. Other significant columns include DISTRIBUTION_NUM (sequence), QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, and QUANTITY_CANCELLED for tracking line progress.

Common Use Cases and Queries

This table is central to procurement reporting and reconciliation. Common use cases include analyzing PO commitments by account, reconciling received quantities to invoiced quantities, and tracing requisition-to-PO cost allocation changes. A typical query retrieves distribution details for a specific PO or account:

  • SELECT pod.po_distribution_id, pod.distribution_num, pod.quantity_ordered, gcc.segment1, gcc.segment2 FROM po_distributions_all pod, gl_code_combinations gcc WHERE pod.code_combination_id = gcc.code_combination_id AND pod.po_header_id = <header_id>;
  • For reconciliation, distributions are often joined to AP_INVOICE_DISTRIBUTIONS_ALL on PO_DISTRIBUTION_ID to match invoice lines to their PO source.
  • Reporting on un-invoiced receipts involves joining to RCV_TRANSACTIONS and checking QUANTITY_BILLED against QUANTITY_DELIVERED.

Related Objects

As indicated by its extensive foreign keys, PO_DISTRIBUTIONS_ALL is a hub table with critical relationships. It is a direct child of PO_HEADERS_ALL, PO_LINES_ALL, and PO_LINE_LOCATIONS_ALL. Its primary accounting link is to GL_CODE_COMBINATIONS via multiple account columns. For inventory, it references MTL_SECONDARY_INVENTORIES. It is the source for invoice matching in Payables, referenced by AP_INVOICE_DISTRIBUTIONS_ALL. For project-related procurement, it links to PA_TASKS. The table also maintains lineage to requisitions via PO_REQ_DISTRIBUTIONS_ALL and supports blanket agreements via PO_RELEASES_ALL. For cost management, it is referenced by CST_AP_PO_RECONCILIATION.