Search Results po_distributions_pk

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:

• PO_DISTRIBUTION_ID — surrogate primary key (PO_DISTRIBUTIONS_PK and unique index PO_DISTRIBUTIONS_U1); uniquely identifies each distribution row.
• PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID — the business-key composite (PO_DISTRIBUTIONS_UK1) tying the distribution to its header, line, and shipment, plus DISTRIBUTION_NUM for sequencing.
• CODE_COMBINATION_ID — the charge account in GL_CODE_COMBINATIONS.
• BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, VARIANCE_ACCOUNT_ID — additional accounting flexfield references used for budgeting, accrual, and variance postings.
• QUANTITY_ORDERED, QUANTITY_DELIVERED, QUANTITY_BILLED, QUANTITY_CANCELLED — lifecycle quantity tracking per distribution.
• AMOUNT_ORDERED, AMOUNT_DELIVERED, AMOUNT_BILLED, AMOUNT_CANCELLED — the corresponding monetary values.
• ENCUMBERED_AMOUNT, ENCUMBERED_FLAG, UNENCUMBERED_AMOUNT — encumbrance accounting state.
• DESTINATION_TYPE_CODE, DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY — inventory or expense destination detail.
• REQ_DISTRIBUTION_ID, PO_RELEASE_ID, SOURCE_DISTRIBUTION_ID — links back to the originating requisition, release, or source distribution.
• ORG_ID, SET_OF_BOOKS_ID — multi-org and ledger context.

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

• PO_HEADERS_ALL (PO_HEADER_ID), PO_LINES_ALL (PO_LINE_ID), PO_LINE_LOCATIONS_ALL (LINE_LOCATION_ID) — parent PO entities.
• GL_CODE_COMBINATIONS — via CODE_COMBINATION_ID and the budget/accrual/variance account columns.
• AP_INVOICE_DISTRIBUTIONS_ALL — references this table via PO_DISTRIBUTION_ID for invoice matching.
• RCV_TRANSACTIONS and RCV_SHIPMENT_LINES — receiving transactions linked by PO_DISTRIBUTION_ID.
• PO_REQ_DISTRIBUTIONS_ALL (REQ_DISTRIBUTION_ID) and PO_RELEASES_ALL (PO_RELEASE_ID) — upstream requisition and release sourcing.
• PA_BC_COMMITMENTS_ALL and PA_BC_PACKETS — project commitments referencing DOCUMENT_DISTRIBUTION_ID.
• MTL_SUPPLY and MTL_KANBAN_CARD_ACTIVITY — supply and kanban integration.
• PO_ACCRUAL_RECONCILE_TEMP_ALL and PO_ACCRUAL_WRITE_OFFS_ALL — accrual reconciliation processes.