Search Results po_interface_errors_pk

Overview

PO_INTERFACE_ERRORS is a Purchasing (PO) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas, owned by the PO schema. It functions as the central error repository for the Requisition Import process and related purchasing interface programs. When records are loaded into the purchasing interface tables, validation failures, missing references, and data conversion problems are logged here rather than being applied to the base transaction tables. This gives implementers and support analysts a persistent, queryable audit trail of rejected interface rows along with the reason for rejection.

The table is polymorphic: a single physical structure serves multiple interface flows, distinguished by the INTERFACE_TYPE column. Although the documented description emphasizes requisition import, the foreign keys also reference receiving and price difference interface tables, indicating reuse across purchasing, receiving, and price adjustment import processes. Under a heuristic Data Vault classification mined from its foreign key structure, PO_INTERFACE_ERRORS is best modeled as a link table. It records associations between an interface transaction and the error context that caused its rejection, rather than acting as a standalone hub of business entities or a satellite of descriptive attributes.

Key Information Stored

The primary key of the table is PO_INTERFACE_ERRORS_PK, defined on the composite columns INTERFACE_TYPE and INTERFACE_TRANSACTION_ID. INTERFACE_TYPE is therefore both a structural discriminator and part of the surrogate primary key, while INTERFACE_TRANSACTION_ID is a business-key candidate that points back to the originating interface transaction.

The most operationally significant columns include:

• INTERFACE_TYPE — distinguishes the interface flow (for example, requisition, receiving, or price difference) that produced the error.
• INTERFACE_TRANSACTION_ID — identifier of the failed interface transaction; participates in the primary key.
• ERROR_MESSAGE — the human-readable text describing why the row was rejected.
• ERROR_MESSAGE_NAME — the associated message name used for lookup and categorization.
• COLUMN_NAME and COLUMN_VALUE — identify the specific interface column and value that failed validation.
• TABLE_NAME — the interface table from which the failing row originated.
• PROCESSING_DATE — timestamp of the validation attempt.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID — identify the concurrent program and request that generated the error.
• BATCH_ID — groups errors belonging to a single import batch.
• INTERFACE_HEADER_ID, INTERFACE_LINE_ID, INTERFACE_DISTRIBUTION_ID, INTERFACE_LINE_LOCATION_ID — hierarchical pointers to the affected interface record.
• TOKEN1_NAME through TOKEN6_VALUE — parameter substitution values for message tokens.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Support teams query this table to diagnose why Requisition Import or Receiving Import rejected records. A typical pattern joins errors back to the source interface table and filters by request:

• Identify all errors for a batch: SELECT * FROM po_interface_errors WHERE batch_id = :batch;
• Trace errors for a concurrent request: SELECT interface_type, interface_transaction_id, error_message FROM po_interface_errors WHERE request_id = :request_id;
• Group failures by type for reporting: SELECT interface_type, error_message_name, COUNT(*) FROM po_interface_errors GROUP BY interface_type, error_message_name;
• Locate the offending column value: SELECT column_name, column_value FROM po_interface_errors WHERE interface_transaction_id = :id;

Reporting use cases include monitoring interface throughput, quantifying error rates per source system, and producing remediation worklists for data stewards.

Related Objects

The documented foreign keys tie PO_INTERFACE_ERRORS to the following significant objects, each joined on INTERFACE_TRANSACTION_ID unless noted:

• PO_REQUISITIONS_INTERFACE_ALL — the primary requisition interface staging table.
• RCV_TRANSACTIONS_INTERFACE — the receiving transactions interface table.
• RA_INTERFACE_DISTRIBUTIONS_ALL — joined via INTERFACE_DISTRIBUTION_ID.
• PO_PRICE_DIFF_INTERFACE — joined via PRICE_DIFF_INTERFACE_ID.

These relationships make the table a connective link across purchasing, receiving, and price adjustment import flows, consistent with its heuristic Data Vault classification.