Results for “interface_distribution_ref”

6 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PO_DISTRIBUTIONS_ARCHIVE_ALL is the archive counterpart of PO_DISTRIBUTIONS_ALL in the Oracle Purchasing (PO) schema. It stores historical purchasing distribution records — the accounting, receiving, and encumbrance detail that fragments a purchase order line into one or more deliverable/chargeable units. In Oracle EBS 12.1.1 and 12.2.2, distributions carry the GL code combination, quantity ordered/delivered/billed/cancelled, accrual and encumbrance flags, project and task references, and destination inventory attributes. The archive table preserves these records when the parent document (for example, a blanket agreement or a fully processed PO) is purged or moved through the archive process, retaining the row at the same structural fidelity as the operational table.

Structurally, the table is keyed by the composite primary key PO_DISTRIBUTIONS_ARCHIVE_PK on (PO_DISTRIBUTION_ID, REVISION_NUM). The presence of both the surrogate distribution identifier and a REVISION_NUM introduces revision history into the archive, so the same logical distribution may appear across multiple revisions. The heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning: the table carries descriptive and transactional attributes that depend on core PO hubs (header, line, line location) and link to reference hubs (accounts, inventory).

Key Information Stored

The catalogue documents 127 columns. The following are the most operationally significant:

Common Use Cases and Queries

The table is used primarily for historical procurement and accounting reporting where current distributions have been purged. Typical scenarios include reconstructing the charged GL account for an invoice or receipt whose PO no longer resides in PO_DISTRIBUTIONS_ALL, and reconciling encumbrance balances for closed periods.

Sample query joining archived distributions to their header for a given purchasing document:

  • SELECT d.po_distribution_id, d.distribution_num, d.revision_num, d.quantity_ordered, d.amount_ordered, d.code_combination_id, h.segment1 AS po_number FROM po_distributions_archive_all d JOIN po_headers_all h ON h.po_header_id = d.po_header_id WHERE h.segment1 = :po_number ORDER BY d.revision_num DESC;

To inspect the latest archived revision for each distribution use a correlated subquery or analytic ranking on (PO_DISTRIBUTION_ID), filtered where LATEST_EXTERNAL_FLAG = 'Y'. Grouping by SET_OF_BOOKS_ID and CODE_COMBINATION_ID supports archival expenditure summaries, while joins to GL_CODE_COMBINATIONS resolve the accounting flexfield segments.

Related Objects

  • PO_DISTRIBUTIONS_ALL — Source operational table; joins on PO_DISTRIBUTION_ID (and SOURCE_DISTRIBUTION_ID).
  • PO_HEADERS_ALL — Parent document; joins on PO_HEADER_ID.
  • PO_LINES_ALL — Parent line; joins on PO_LINE_ID.
  • PO_LINE_LOCATIONS_ALL — Shipment; joins on LINE_LOCATION_ID.
  • PO_RELEASES_ALL — Release reference; joins on PO_RELEASE_ID.
  • GL_CODE_COMBINATIONS — Accounting flexfield for CODE_COMBINATION_ID, BUDGET_ACCOUNT_ID, ACCRUAL_ACCOUNT_ID, and VARIANCE_ACCOUNT_ID.
  • GL_SETS_OF_BOOKS — Ledger; joins on SET_OF_BOOKS_ID.
  • MTL_SECONDARY_INVENTORIES — Destination subinventory; joins on DESTINATION_ORGANIZATION_ID and DESTINATION_SUBINVENTORY.
  • PO_REQ_DISTRIBUTIONS_ALL — Requisition origin; joins on REQ_DISTRIBUTION_ID.
  • ICX_PO_REVISIONS_TEMP — References this table via DISTRIBUTION_ID and REVISION_NUM.