Search Results po_headers_interface




Overview
Explore in AI Chat

Overview

PO_HEADERS_INTERFACE is the open interface table in the Oracle Purchasing (PO) module, owned by the PO schema, that serves as the staging area for purchase order header records before they are validated and imported into the production purchasing tables. In Oracle EBS 12.1.1 and 12.2.2, external systems, legacy conversions, and batch programs populate this table with rows describing PO headers across the full range of document types, including standard purchase orders, releases, blanket and global agreements, contracts, RFQs, and quotations. The Purchasing Documents Open Interface (PDOI) subsequently reads the staged rows, applies validation, and creates or updates the corresponding records in PO_HEADERS_ALL and its related tables.

From a heuristic Data Vault modeling perspective, the FK structure mined from the metadata classifies this table as standalone, suggesting it functions as a staging or hub-adjacent table rather than a dependent link or satellite. Its granularity is one row per header to be imported, uniquely identified by INTERFACE_HEADER_ID, which makes it a natural hub candidate for the purchase order header business key during ETL lineage modeling.

Key Information Stored

The table contains 172 documented columns, of which the following are the most operationally significant:

Common Use Cases and Queries

The most frequent scenario is monitoring the open interface for pending, errored, or partially processed rows. A typical reconciliation query counts staged rows by batch:

  • SELECT BATCH_ID, COUNT(*) FROM PO.PO_HEADERS_INTERFACE GROUP BY BATCH_ID;
  • SELECT INTERFACE_HEADER_ID, DOCUMENT_NUM, VENDOR_ID, PROCESS_CODE FROM PO.PO_HEADERS_INTERFACE WHERE BATCH_ID = :batch_id;
  • SELECT * FROM PO.PO_HEADERS_INTERFACE WHERE PO_HEADER_ID IS NOT NULL; — isolates update-mode rows linked to existing production headers.

Other common uses include pre-import data cleansing, tracing the origin of a purchase order via INTERFACE_SOURCE_CODE, auditing attribute flexfield population, and confirming that legacy conversion loads reconcile against PO_HEADERS_ALL. Reporting on the interface is frequently paired with the PO_HEADERS_INTERFACE_ERRORS table produced during validation.

Related Objects

  • PO_HEADERS_ALL — The production header table populated upon successful import; joined on PO_HEADER_ID.
  • PO_RELEASES_ALL — Referenced through PO_RELEASE_ID for release-related interface rows.
  • PO_VENDOR_LIST_HEADERS — Referenced through VENDOR_LIST_HEADER_ID to apply sourcing rules.
  • HR_ADE_STYLES — Referenced through STYLE_ID, supporting the Contract Lifecycle Management style attributes.
  • PO_LINES_INTERFACE and PO_LINE_LOCATIONS_INTERFACE — Child interface tables processed alongside the header.
  • PO_HEADERS_INTERFACE_ERRORS — Captures validation failures encountered by the import program.
  • PO_INTERFACE_ERRORS — Shared error repository for interface processing.
  • Purchasing Documents Open Interface (PDOI) — The concurrent program and PL/SQL API that consumes these rows.