Results for “so_headers_u2”

10 results




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

Overview

OE.SO_HEADERS_ALL is the master transactional table that stores sales order header information within the Oracle E-Business Suite Order Management (OE) application, owned by the OE schema. In EBS 12.1.1 and 12.2.2, this table resides in the APPS_TS_TX_DATA tablespace and represents the top-level container for every sales order, return, and internal sales order processed through the system. Each row corresponds to a single order header, with an associated set of order lines held in OE.SO_LINES_ALL. The table is flagged VALID and carries an Oracle Internal Use Only restriction, meaning supported access should occur only through standard Order Management forms, Order Import, and public APIs rather than direct DML.

From a dimensional modeling perspective, and applying the Data Vault classification heuristic supplied in the metadata, SO_HEADERS_ALL is best treated as a hub entity. The unique business key around which the table is organized is the combination of ORDER_NUMBER and ORDER_TYPE_ID (enforced by the SO_HEADERS_U2 unique index), while HEADER_ID serves as the surrogate primary key (SO_HEADERS_PK, also enforced by the SO_HEADERS_U1 unique index).

Key Information Stored

The table comprises 180 documented columns, of which the most operationally significant include:

Common Use Cases and Queries

Because SO_HEADERS_ALL is a hub, it is frequently the starting point for order-level reporting, and joins to SO_LINES_ALL, RA_CUSTOMERS, and SO_ORDER_TYPES_115_ALL. A typical open-order report uses the OPEN_FLAG index:

  • Retrieve all open orders for a customer: SELECT h.ORDER_NUMBER, h.ORDER_CATEGORY, h.CUSTOMER_ID FROM OE.SO_HEADERS_ALL h WHERE h.CUSTOMER_ID = :cust AND h.OPEN_FLAG = 'Y';
  • Trace an order by its customer PO: SELECT HEADER_ID, ORDER_NUMBER FROM OE.SO_HEADERS_ALL WHERE PURCHASE_ORDER_NUM = :po; (uses SO_HEADERS_N3).
  • Identify imported orders: use ORIGINAL_SYSTEM_SOURCE_CODE and ORIGINAL_SYSTEM_REFERENCE (SO_HEADERS_N9) to reconcile data loaded via Order Import.
  • Lifecycle and audit queries rely on OPEN_FLAG, CANCELLED_FLAG, WH_UPDATE_DATE (SO_HEADERS_N10), and the Who/concurrent columns.

Related Objects