Search Results po_headers_archive_all

Overview

The PO_HEADERS_ARCHIVE_ALL table is a core data object within the Oracle E-Business Suite Purchasing (PO) module. It serves as the definitive repository for archived purchase order header information across all operating units. Its primary role is to maintain a complete historical record of purchase order revisions, enabling audit trails, historical reporting, and compliance. When a purchase order is revised, the system archives the previous version of the header record into this table before creating a new revision in the active PO_HEADERS_ALL table. This architecture ensures data integrity and provides a full version history for every purchase order transaction within the application.

Key Information Stored

The table stores a snapshot of a purchase order header at the moment of archival. Its structure mirrors that of the active PO_HEADERS_ALL table for historical fidelity. The table is uniquely identified by a composite primary key consisting of PO_HEADER_ID and REVISION_NUM. The PO_HEADER_ID links the archived record to its corresponding active header, while REVISION_NUM specifies the sequential version of the archived snapshot. Another unique key on SEGMENT1 (the purchase order number) and REVISION_NUM ensures uniqueness of document numbers across revisions. Critical foreign key columns, such as AGENT_ID, VENDOR_ID, VENDOR_SITE_ID, and CURRENCY_CODE, preserve the relational context of the purchase order as it existed at that revision, linking to agents, suppliers, supplier sites, and currencies respectively.

Common Use Cases and Queries

The primary use case is auditing and reporting on the complete lifecycle of a purchase order. Analysts can trace changes to terms, amounts, suppliers, or buyers across revisions. A common query retrieves the full revision history for a specific purchase order to analyze changes over time. For example: SELECT REVISION_NUM, CREATION_DATE, TYPE_LOOKUP_CODE, AGENT_ID, VENDOR_ID FROM PO.PO_HEADERS_ARCHIVE_ALL WHERE SEGMENT1 = '<PO_NUM>' ORDER BY REVISION_NUM;. Another critical use case is supporting the "View Changes" functionality within the Oracle Purchasing forms, where the system compares data between the active header and archived revisions to highlight modifications. Data from this table is also essential for generating historical procurement reports and meeting regulatory retention requirements.

Related Objects

PO_HEADERS_ARCHIVE_ALL maintains integral relationships with several key Purchasing and foundational tables. Its primary relationship is with the active PO_HEADERS_ALL table via the FROM_HEADER_ID foreign key. It references master data through foreign keys to PO_AGENTS (AGENT_ID), PO_VENDORS (VENDOR_ID), PO_VENDOR_SITES_ALL (VENDOR_SITE_ID), and PO_VENDOR_CONTACTS (VENDOR_CONTACT_ID). For currency information, it links to FND_CURRENCIES (CURRENCY_CODE) and GL_DAILY_CONVERSION_TYPES (RATE_TYPE). Furthermore, it has a foreign key relationship with the ICX_PO_REVISIONS_TEMP table (on HEADER_ID, REVISION_NUM), which is used by Oracle iProcurement for processing revision data. Corresponding archive tables for lines and shipments, such as PO_LINES_ARCHIVE_ALL, typically join to this table using PO_HEADER_ID and REVISION_NUM to form a complete archived document.