Results for “so_headers_interface_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SO_HEADERS_INTERFACE_ALL is the Order Entry (OE) open interface staging table that holds imported order header information for Oracle E-Business Suite Release 12.1.1 and 12.2.2. It resides in the OE schema and stores header-level attributes prior to validation and import into the operational sales order tables (OE_ORDER_HEADERS_ALL). Applications, external systems, and in-house interfaces populate this table, after which the Order Management concurrent programs process each row through import, validation, and order creation.

From a Data Vault modeling perspective, the foreign-key topology is classified as satellite-leaning. This is a useful heuristic: the table primarily records descriptive, context-dependent attributes drawn from many reference sources rather than acting as a structural hub or pure intersection. Note that ORG_ID is present, confirming a multi-org (operating unit) context.

Key Information Stored

The table contains 121 documented columns. The single-column primary key is SO_HEADERS_INTERFACE_PK, which is not a surrogate generated key but is composed of the business key ORIGINAL_SYSTEM_REFERENCE. A unique index, SO_HEADERS_INTERFACE_U1, covers (ORIGINAL_SYSTEM_REFERENCE, ORDER_SOURCE_ID), providing the composite business-key candidate that identifies a source order uniquely within its originating system.

• ORIGINAL_SYSTEM_REFERENCE — External source identifier; part of the primary key and the join key to child interface tables.
• ORDER_SOURCE_ID / ORDER_NUMBER_SOURCE_ID — Identify the order source and numbering source used at import.
• CUSTOMER_ID / CUSTOMER_NUMBER / CUSTOMER_NAME — Sold-to customer identification.
• ORDER_TYPE_ID / ORDER_TYPE / ORDER_CATEGORY — Order classification used by import validation.
• SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID, SHIP_ADDRESS_ID — Ship-to party, site, and address.
• INVOICE_CUSTOMER_ID, INVOICE_TO_SITE_USE_ID, INVOICE_ADDRESS_ID — Invoice-to party, site, and address.
• PRICE_LIST_ID / PRICE_LIST_NAME, TERMS_ID / TERMS_NAME — Pricing and payment terms.
• CURRENCY_CODE, CONVERSION_RATE, CONVERSION_TYPE_CODE, CONVERSION_DATE — Currency and conversion context.
• SALESREP_ID / SALESREP_NUMBER, SALES_CHANNEL_CODE — Sales representative and channel.
• INTERFACE_STATUS, ERROR_FLAG, OPERATION_CODE, SCHEDULE_STATUS_CODE — Interface processing state and error control.
• ORG_ID — Operating unit for multi-org security.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield columns.

Common Use Cases and Queries

The primary use case is managing bulk order import. Administrators insert or stage rows, then invoke the Order Import concurrent program, which reads header records and their child lines from SO_LINES_INTERFACE_ALL keyed on ORIGINAL_SYSTEM_REFERENCE.

A common query pattern checks import errors by status flag:

SELECT original_system_reference, customer_number, order_type_id, error_flag
FROM   so_headers_interface_all
WHERE  error_flag = 'Y'
AND    org_id = :p_org_id;

Order status tracking selects header-level control columns:

SELECT original_system_reference, interface_status, schedule_status_code, operation_code
FROM   so_headers_interface_all
WHERE  original_system_reference = :p_ref;

Reporting scenarios include reconciliation of source orders to imported orders, monitoring of rejected records, and pre-import auditing of customer, price list, and terms references to prevent failed validations against RA_CUSTOMERS, SO_PRICE_LISTS_B, and RA_TERMS_B.

Related Objects

• SO_LINES_INTERFACE_ALL — Child interface table; joined on ORIGINAL_SYSTEM_REFERENCE.
• SO_PRICE_ADJUSTMENTS_INTERFACE — Adjustments linked via ORIGINAL_SYSTEM_REFERENCE.
• SO_SALES_CREDITS_INTERFACE — Sales credits linked via ORIGINAL_SYSTEM_REFERENCE.
• RA_CUSTOMERS / RA_SITE_USES_ALL / RA_ADDRESSES_ALL — Customer, site, and address references via CUSTOMER_ID, SHIP_TO_SITE_USE_ID, SHIP_ADDRESS_ID, and related columns.
• SO_ORDER_TYPES_115_ALL — Order type validation via ORDER_TYPE_ID and ORDER_TYPE.
• SO_ORDER_SOURCES_115 / SO_ORDER_NUMBER_SOURCES — Source reference validation.
• RA_TERMS_B / SO_PRICE_LISTS_B — Terms and price list references.
• RA_RULES — Invoicing and accounting rule references.
• FND_CURRENCIES / RA_SALESREPS_ALL / SO_CYCLES / SO_AGREEMENTS_B — Currency, salesrep, cycle, and agreement lookups.