Search Results OE_ORDER_HEADERS_ALL

Overview

The OE_ORDER_HEADERS_ALL table is a fundamental data structure within the Oracle E-Business Suite (EBS) Order Management (ONT) module. It serves as the primary repository for header-level information for sales orders, quotations, and returns. As a multi-organization table, denoted by the "_ALL" suffix, it stores data for all operating units, with access typically controlled by the MOAC (Multi-Org Access Control) security profile. This table is central to the order lifecycle, establishing the foundational business context—such as customer, terms, and transaction type—for the detailed line items stored in related tables like OE_ORDER_LINES_ALL.

Key Information Stored

The table's primary key is the HEADER_ID, a unique system-generated identifier for each order header. Critical foreign key columns define the order's relationships and attributes. These include ORDER_TYPE_ID (linking to OE_TRANSACTION_TYPES_ALL), SOLD_TO_ORG_ID (linking to HZ_PARTIES for the customer), and PRICE_LIST_ID (linking to QP_LIST_HEADERS_B). Other significant columns track the order source (ORDER_SOURCE_ID), sales representative (SALESREP_ID), invoicing and accounting rules (INVOICING_RULE_ID, ACCOUNTING_RULE_ID), payment terms (PAYMENT_TERM_ID), and the sold-from and ship-from organizations (SOLD_FROM_ORG_ID, SHIP_FROM_ORG_ID). The table also captures key dates, flow status codes, and order number identifiers.

Common Use Cases and Queries

This table is essential for order inquiry, reporting, and integration. Common operational reports, such as order summaries by customer or sales rep, originate from this table. A typical query to retrieve basic order header information for a specific operating unit would join to related reference tables:

• SELECT ooha.header_id, ooha.order_number, ooha.ordered_date, hzp.party_name customer_name, ott.name order_type FROM ont.oe_order_headers_all ooha, hz_cust_accounts hca, hz_parties hzp, ont.oe_transaction_types_tl ott WHERE ooha.sold_to_org_id = hca.cust_account_id AND hca.party_id = hzp.party_id AND ooha.order_type_id = ott.transaction_type_id AND ooha.org_id = :p_org_id;

Data fixes, audits, and integrations with external systems (like CRM or BI tools) frequently query or update records in this table, though direct DML should be approached with caution and typically performed via standard Order Management APIs.

Related Objects

OE_ORDER_HEADERS_ALL has extensive relationships within the EBS schema. It is the parent table for OE_ORDER_LINES_ALL, which holds all line details. As indicated by the foreign keys, it references numerous control and setup tables, including OE_TRANSACTION_TYPES_ALL, RA_TERMS_B, QP_LIST_HEADERS_B, and RA_RULES. It is also referenced by several other module-specific tables, such as AHL_OSP_ORDERS_B (Service) and AMS_EVENT_REGISTRATIONS (Marketing). The primary transactional view for users is OE_ORDER_HEADERS, which applies a security filter on ORG_ID. Key APIs for manipulating data in this table include OE_ORDER_PUB.PROCESS_ORDER for order processing and OE_HEADER_UTIL for utility operations.