Search Results po_headers_interface

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:

• INTERFACE_HEADER_ID — The surrogate primary key, enforced by the unique index PO_HEADERS_INTERFACE_U1, and the definitive business-key candidate for each staging row.
• BATCH_ID and GROUP_CODE — Control identifiers used to group and process rows in logical batches.
• INTERFACE_SOURCE_CODE, PROCESS_CODE, and ACTION — Determine the source system, the processing mode, and whether the row results in an insert, update, or other action.
• ORG_ID and DOCUMENT_TYPE_CODE — Establish the operating unit and the purchasing document class.
• DOCUMENT_NUM and PO_HEADER_ID — Carry the document number and, for updates, the target production header identifier.
• VENDOR_ID, VENDOR_SITE_ID, and VENDOR_NAME — Supplier identification used during import.
• CURRENCY_CODE, RATE, and PAYMENT_TERMS — Commercial terms applied to the resulting purchase order.
• SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID, and FREIGHT_TERMS — Defaulting and logistics attributes.
• APPROVAL_STATUS, CLOSED_CODE, and CONFIRMING_ORDER_FLAG — Status and behavioral flags.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard DFF flexfield segments.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, REQUEST_ID, and PROGRAM_ID — Standard WHO and concurrent program audit columns.

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.