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:
- HEADER_ID — System-generated surrogate primary key uniquely identifying each order header.
- ORDER_NUMBER — The user-visible number of the order; combined with ORDER_TYPE_ID it forms the business key (SO_HEADERS_U2).
- ORDER_TYPE_ID — Foreign key to SO_ORDER_TYPES_115_ALL, defining the order's transaction type.
- ORDER_CATEGORY — Indicates whether the order is a regular order, return, or internal sales order.
- OPEN_FLAG and CANCELLED_FLAG — Control the lifecycle state; OPEN_FLAG supports index SO_HEADERS_N2.
- CUSTOMER_ID — Foreign key to RA_CUSTOMERS (indexed via SO_HEADERS_N1).
- SHIP_TO_SITE_USE_ID and INVOICE_TO_SITE_USE_ID — Foreign keys to RA_SITE_USES_ALL defining fulfillment and billing locations.
- CURRENCY_CODE — Foreign key to FND_CURRENCIES; with CONVERSION_RATE, CONVERSION_TYPE_CODE, and CONVERSION_DATE.
- TERMS_ID, PRICE_LIST_ID, SALESREP_ID, and AGREEMENT_ID — Foreign keys to RA_TERMS_B, SO_PRICE_LISTS_B, RA_SALESREPS_ALL, and SO_AGREEMENTS_B respectively.
- PURCHASE_ORDER_NUM — Customer PO reference, indexed by SO_HEADERS_N3.
- ORIGINAL_SYSTEM_SOURCE_CODE and ORIGINAL_SYSTEM_REFERENCE — Used by Order Import to track external source systems (indexed by SO_HEADERS_N9).
- Standard Who columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_ID, and PROGRAM_APPLICATION_ID for concurrent program auditing.
- ORG_ID — Multi-org operating unit identifier, qualifying rows within a specific organization.
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
- OE.SO_LINES_ALL — child table joining on HEADER_ID (SO_LINES_ALL.HEADER_ID → SO_HEADERS_ALL).
- OE.SO_ORDER_HOLDS_ALL and SO_HOLD_RELEASES — order holds, joining on HEADER_ID / HOLD_ENTITY_ID.
- OE.SO_ORDER_CANCELLATIONS and SO_ORDER_APPROVALS — lifecycle events joining on HEADER_ID.
- OE.SO_PICKING_HEADERS_ALL — joining on ORDER_HEADER_ID; picking batches reference HEADER_ID.
- OE.SO_SALES_CREDITS and SO_PRICE_ADJUSTMENTS — heading-level financial records joining on HEADER_ID.
- OE.SO_NOTE_REFERENCES — attached notes joining on HEADER_ID.
- OE.SO_HEADERS_ALL (self-reference) — via SOURCE_HEADER_ID for split/derived orders.
- RA_CUSTOMERS, RA_SITE_USES_ALL, RA_SALESREPS_ALL, RA_TERMS_B, FND_CURRENCIES, SO_ORDER_TYPES_115_ALL — primary reference (parent) objects.
-
INDEX: OE.SO_HEADERS_U2 12.1.1
-
INDEX: OE.SO_HEADERS_U2 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
TABLE: OE.SO_HEADERS_ALL 12.1.1
-
Order header information
-
TABLE: OE.SO_HEADERS_ALL 12.2.2
-
Order header information
-
eTRM - OE Tables and Views 12.1.1
Temporary table
-
eTRM - OE Tables and Views 12.2.2
Temporary table