Search Results oe_headers_iface_all

Overview

The OE_HEADERS_IFACE_ALL table is a core multi-organization (multi-org) open interface table within the Oracle E-Business Suite (EBS) Order Management (ONT) module. Its primary role is to serve as the staging area for importing sales order header data from external, non-EBS systems or legacy applications into the core transactional tables of Oracle Order Management. This interface-based approach allows for data validation and transformation before the information is permanently committed to the production tables, ensuring data integrity. The table is central to the Order Import concurrent program, which processes records from this interface, validates them against business rules, and creates corresponding sales orders in the OE_ORDER_HEADERS_ALL table.

Key Information Stored

The table stores a comprehensive set of attributes required to define a sales order header. While the provided metadata focuses on foreign key relationships, these relationships indicate the critical columns and the data they reference. Key columns include the unique identifier (INTERFACE_HEADER_ID), the processing status (PROCESS_FLAG), and the originating system's order number (ORIG_SYS_DOCUMENT_REF). Crucially, it holds foreign keys to define the order's business context: customer and party identifiers (SOLD_TO_PARTY_ID, SOLD_TO_SITE_USE_ID), ship-to and bill-to locations (SHIP_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_ID), salesperson (SALESREP_ID), pricing and payment terms (PAYMENT_TERM_ID), currency (TRANSACTIONAL_CURR_CODE), and the operating unit (ORG_ID). The ORDER_SOURCE_ID specifies the origin channel, such as an external web store or a legacy system feed.

Common Use Cases and Queries

The predominant use case is the batch integration of sales orders. A typical process involves inserting records into OE_HEADERS_IFACE_ALL and its corresponding lines table (OE_LINES_IFACE_ALL), then submitting the Order Import concurrent program. Common diagnostic queries involve checking for interface errors. For example, to identify records that failed processing: SELECT interface_header_id, orig_sys_document_ref, error_message FROM oe_headers_iface_all WHERE process_flag = 'ERROR';. To monitor pending interface records: SELECT COUNT(*), order_source_id FROM oe_headers_iface_all WHERE process_flag = 'PENDING' AND org_id = 123 GROUP BY order_source_id;. Developers also query this table to trace the lifecycle of an imported order by joining the ORIG_SYS_DOCUMENT_REF to the OE_ORDER_HEADERS_ALL.ORDER_NUMBER after successful import.

Related Objects

OE_HEADERS_IFACE_ALL is intrinsically linked to numerous EBS objects. Its primary relationship is with OE_LINES_IFACE_ALL, which holds the corresponding line items for each interface header. The key dependent program is the Order Import concurrent program (OEOPIM). As indicated by the foreign keys, it references master data tables such as HZ_PARTIES (Trading Community Architecture), RA_SALESREPS_ALL (Salespersons), RA_TERMS_B (Payment Terms), and FND_CURRENCIES. Its success is measured by the creation of records in the core transactional tables OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL. The table also relates to OE_AGREEMENTS_B for contractual terms and HR_ALL_ORGANIZATION_UNITS for the operating unit structure.