Search Results po_headers_archive_xml




Overview
Explore in AI Chat

Overview

APPS.PO_HEADERS_ARCHIVE_XML is a Purchasing (PO) module view in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes a denormalized, XML-oriented projection of archived purchasing document headers, drawing from PO_HEADERS_ARCHIVE_ALL and joining reference, vendor, currency, and buyer information. Its principal role is to serve as the data source for Oracle Purchasing's XML document generation and communication routines — particularly the archived/revised versions of purchase orders, blanket agreements, and contracts that must be rendered into XML for printing, e-mail, EDI, or fax transmission to suppliers.

The view is structured to present header-level information in a format readily consumable by the PO communication layer (PO_COMMUNICATION_PVT) and by XML Publisher / BI Publisher templates. Because it reflects the archive tables, it captures point-in-time snapshots of documents as they existed at each revision, which is essential for auditability and for regenerating documents historically.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

The heavy use of packaged functions means the view is context-sensitive and can raise errors if session context (e.g., FND_GLOBAL initialization) is not set.

Key Columns

Common Use Cases and Queries

Typical uses include regenerating archived PO documents as XML, auditing field-level changes across revisions, and building custom BI Publisher reports against archived headers. Notably, the vendor_area_code field a user may search for is not exposed as a distinct column in this view's documented text; telephone area code is typically stored on vendor site/contact tables rather than the archived header.

  • Retrieve recent archived headers for a supplier:
SELECT h.segment1, h.revision_num, h.creation_date,
       h.vendor_name, h.currency_code, h.amount_agreed
FROM   apps.po_headers_archive_xml h
WHERE  h.vendor_num = '&vendor_num'
ORDER BY h.creation_date DESC;
  • List archived buyers for revised documents only:
SELECT h.segment1, h.revision_num,
       h.document_buyer_first_name, h.document_buyer_last_name,
       h.archive_buyer_first_name, h.archive_buyer_last_name
FROM   apps.po_headers_archive_xml h
WHERE  NVL(h.revision_num,0) <> 0;

Because the view calls PO_COMMUNICATION_PVT and FND_GLOBAL, queries should be executed in an application-initialized session (or via concurrent programs) to avoid function errors.