Search Results po_distributions_archive_all




Overview
Explore in AI Chat

Overview

The PO_DISTRIBUTIONS_ARCHIVE_ALL table is a core data retention object within Oracle E-Business Suite Purchasing (PO) modules, specifically for versions 12.1.1 and 12.2.2. It serves as an archival repository for distribution line records from purchase orders, blanket releases, and planned purchase orders. Its primary role is to preserve a historical, versioned record of financial and logistical distribution data whenever a purchasing document is revised, amended, or otherwise modified. This ensures a complete audit trail of changes to critical accounting and receiving information, such as charge accounts, quantities, and destinations, separate from the active transactional data in the PO_DISTRIBUTIONS_ALL table.

Key Information Stored

The table stores snapshots of distribution records, uniquely identified by the combination of PO_DISTRIBUTION_ID and REVISION_NUM. Key columns include identifiers linking to the parent document (PO_HEADER_ID, PO_LINE_ID, LINE_LOCATION_ID, PO_RELEASE_ID), financial account segments (CODE_COMBINATION_ID, BUDGET_ACCOUNT_ID), and logistical details (DESTINATION_ORGANIZATION_ID, DESTINATION_SUBINVENTORY). The REVISION_NUM is critical for tracking the sequence of archived versions. The table maintains referential integrity through numerous foreign keys to core Purchasing, Inventory, and General Ledger tables, as documented in the ETRM metadata.

Common Use Cases and Queries

The primary use case is historical auditing and reporting on changes to purchase order distributions. This is essential for financial compliance, troubleshooting account changes, and analyzing procurement history. A common query pattern involves joining this archive table with its active counterpart and document header/line tables to view the evolution of a specific distribution.

  • Sample Query (Retrieve Full Revision History for a Distribution):
    SELECT archive.po_distribution_id, archive.revision_num, archive.code_combination_id,
    archive.quantity_ordered, archive.destination_subinventory
    FROM po_distributions_archive_all archive
    WHERE archive.line_location_id = :p_line_location_id
    AND archive.distribution_num = :p_dist_num
    ORDER BY archive.revision_num DESC;
  • Reporting Use Case: Generating reports that show all account code changes for a specific purchase order line across its lifecycle, often required for internal or external audits.

Related Objects

As indicated by its foreign keys, PO_DISTRIBUTIONS_ARCHIVE_ALL has a direct and fundamental relationship with the active transaction table PO_DISTRIBUTIONS_ALL. It is a child of major Purchasing document tables: PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_RELEASES_ALL. Its financial integrity is tied to GL_CODE_COMBINATIONS (for multiple account types) and GL_SETS_OF_BOOKS. Links to MTL_SECONDARY_INVENTORIES and BOM_RESOURCES track delivery and charge details. The table PO_REQ_DISTRIBUTIONS_ALL is referenced for requisition-sourced distributions. The ICX_PO_REVISIONS_TEMP table may interact with it during revision processing workflows.