Search Results oe_order_headers_u1

Overview

ONT.OE_ORDER_HEADERS_ALL is the master header table for the Oracle Order Management (ONT) application in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the header-level attributes of every sales order, return, quote, and blanket agreement processed through Order Management, including the sold-to, ship-to, invoice-to and deliver-to parties, pricing and currency controls, payment and accounting rules, credit card data, hold and booking flags, and the complete set of descriptive flexfield (DFF) and Trading Partner (TP) attribute columns. Each row represents a single order version, so the table is the primary integration point for order capture, order import, pricing, scheduling, shipping, and receivables.

Under a heuristic Data Vault classification mined from its foreign key structure, this object is best modeled as a hub — the core business entity keyed by HEADER_ID, with satellites supplying the descriptive order attributes and links connecting it to customer, order type, pricing, and reference entities. The table resides in the APPS_TS_TX_DATA tablespace, with all index segments in APPS_TS_TX_IDX.

Key Information Stored

The surrogate primary key is HEADER_ID, defined by the unique index OE_ORDER_HEADERS_PK. Two unique indexes act as business-key candidates: OE_ORDER_HEADERS_U1 on HEADER_ID and OE_ORDER_HEADERS_U2 on (ORDER_NUMBER, ORDER_TYPE_ID, VERSION_NUMBER). The user query "oe_order_headers_u1" therefore resolves to the unique key on the header identifier.

• HEADER_ID — surrogate primary key; joins to lines, holds, price adjustments, sales credits, and every dependent child table.
• ORG_ID — operating unit that owns the transaction; drives Multi-Org (MOAC) security.
• ORDER_TYPE_ID / ORDER_NUMBER / VERSION_NUMBER — the user-visible order identifier; the composite unique key of U2.
• ORDER_SOURCE_ID and ORIG_SYS_DOCUMENT_REF — origin of the order and its external system reference, used heavily by order import.
• SOLD_TO_ORG_ID, SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID — the four customer party site roles.
• ORDERED_DATE, REQUEST_DATE, PRICING_DATE — transaction dates governing scheduling and pricing.
• TRANSACTIONAL_CURR_CODE, PRICE_LIST_ID — currency and price list used for pricing.
• OPEN_FLAG, BOOKED_FLAG, CANCELLED_FLAG, FLOW_STATUS_CODE — order lifecycle status used for filtering and reporting.
• CUST_PO_NUMBER, QUOTE_NUMBER, BLANKET_NUMBER — customer-facing document references, each individually indexed.
• SALESREP_ID, BATCH_ID, SOURCE_DOCUMENT_ID — salesperson, import batch, and source order linkage.

Common Use Cases and Queries

Typical reporting retrieves booked orders for an operating unit, traces a customer PO to its order, or lists open orders pending fulfillment.

• Retrieve a booked order by number: SELECT HEADER_ID, ORDER_NUMBER, ORDERED_DATE, FLOW_STATUS_CODE FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER = :n AND ORG_ID = :org;
• List open orders for a sold-to party: SELECT h.HEADER_ID, h.ORDER_NUMBER, h.CUST_PO_NUMBER FROM OE_ORDER_HEADERS_ALL h WHERE h.SOLD_TO_ORG_ID = :cust AND h.OPEN_FLAG = 'Y';
• Join to lines for detail-level reporting: SELECT h.ORDER_NUMBER, l.LINE_NUMBER, l.ORDERED_QUANTITY FROM OE_ORDER_HEADERS_ALL h, OE_ORDER_LINES_ALL l WHERE h.HEADER_ID = l.HEADER_ID;
• Audit order-source or batch imports using ORIG_SYS_DOCUMENT_REF, BATCH_ID, and SOURCE_DOCUMENT_ID.
• Resolve the customer PO index OE_ORDER_HEADERS_N5 when searching by CUST_PO_NUMBER.

Related Objects

Foreign keys define the hub's referenced dimension tables, while many child and interface tables reference it by HEADER_ID.

• OE_TRANSACTION_TYPES_ALL — referenced via ORDER_TYPE_ID.
• OE_ORDER_SOURCES — referenced via ORDER_SOURCE_ID and SOURCE_DOCUMENT_TYPE_ID.
• HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, HZ_CUST_ACCOUNT_ROLES — customer, site, and contact lookups.
• RA_RULES, RA_TERMS_B — invoicing/accounting rules and payment terms.
• OE_ORDER_LINES_ALL — primary child; join on HEADER_ID.
• OE_ORDER_HOLDS_ALL, OE_SALES_CREDITS, OE_PRICE_ADJUSTMENTS, OE_ORDER_PRICE_ATTRIBS — child detail tables on HEADER_ID.
• OE_HEADERS_IFACE_ALL — order import staging table referenced to this header.