Oracle Fusion Sales Order Table – DOO_HEADERS_ALL

Hello,
DOO_HEADERS_ALL is the base table of Oracle Fusion to store the sales order data and this blog is dedicated to share the structure and indexes of the table. Sales Order is one of the most critical piece in O2C Cycle. This blog is divided into 2 subsections:
1. Table Structure
2. Indexes

But before that let’s have a look at few important points:
1. This table is equivalent of OE_ORDER_HEADERS_ALL table in R12.
2. DOO_HEADERS_ALL table is parent table of DOO_LINES_ALL table which is used to hold the line level data of an SO.
3. In case you are looking for the query to fetch the SO Details, please click here.
4. Since it is one of the important tables in Order management, you might want to check this post to see the linkage of DOO_HEADERS_ALL table with other tables.

Hopefully this post helps you. If no, pls leave a comment at the bottom of the page. If it did, pls rate the page.

Want to give back to the society? (Do you have something which you think can be used by folks working on Oracle world wide?) Then Click here, share your email id and a brief description of the topic. And keep your photo and the content ready.

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports. Try them only when nothing else works.. kind of SOS...

DOO_HEADERS_ALL Table Structure

COLUMN NAME	DATA TYPE	DATA LENGTH	NULLABLE
HEADER_ID	NUMBER	22	N
PRE_CREDIT_CHECKED_FLAG	VARCHAR2	4	Y
ORDER_NUMBER	VARCHAR2	200	N
OBJECT_VERSION_NUMBER	NUMBER	22	N
OWNER_ID	NUMBER	22	Y
CREATION_DATE	TIMESTAMP(6)	11	N
CREATED_BY	VARCHAR2	256	N
LAST_UPDATE_DATE	TIMESTAMP(6)	11	N
LAST_UPDATED_BY	VARCHAR2	256	N
LAST_UPDATE_LOGIN	VARCHAR2	128	Y
SOURCE_ORDER_SYSTEM	VARCHAR2	200	N
SOURCE_ORDER_NUMBER	VARCHAR2	200	N
SOURCE_ORDER_ID	VARCHAR2	200	N
SOURCE_DOCUMENT_TYPE_CODE	VARCHAR2	200	Y
SOURCE_REVISION_NUMBER	NUMBER	22	N
ORIG_SYS_DOCUMENT_REF	VARCHAR2	200	Y
SOURCE_ORG_ID	NUMBER	22	Y
ORG_ID	NUMBER	22	N
LEGAL_ENTITY_ID	NUMBER	22	Y
SOLD_TO_CUSTOMER_ID	NUMBER	22	Y
SOLD_TO_CONTACT_ID	NUMBER	22	Y
ORDERED_DATE	DATE	7	N
CUSTOMER_PO_NUMBER	VARCHAR2	200	Y
ORDER_TYPE_CODE	VARCHAR2	120	Y
TRANSACTIONAL_CURRENCY_CODE	VARCHAR2	60	Y
CONVERSION_RATE	NUMBER	22	Y
CONVERSION_TYPE_CODE	VARCHAR2	120	Y
CONVERSION_DATE	DATE	7	Y
STATUS_CODE	VARCHAR2	120	N
PARTIAL_SHIP_ALLOWED_FLAG	VARCHAR2	4	Y
OPEN_FLAG	VARCHAR2	4	N
ON_HOLD	VARCHAR2	4	Y
CANCELED_FLAG	VARCHAR2	4	Y
CHANGE_VERSION_NUMBER	NUMBER	22	Y
IS_EDITABLE	VARCHAR2	4	Y
CANCEL_REASON_CODE	VARCHAR2	120	Y
SOLD_TO_PARTY_ID	NUMBER	22	Y
SOLD_TO_PARTY_CONTACT_ID	NUMBER	22	Y
REQUEST_CANCEL_DATE	TIMESTAMP(6)	11	Y
COMMENTS	VARCHAR2	4000	Y
ALLOW_CURRENCY_OVERRIDE_FLAG	VARCHAR2	4	Y
APPLIED_CURRENCY_CODE	VARCHAR2	60	Y
PRICED_ON	TIMESTAMP(6)	11	Y
PRICING_SEGMENT_CODE	VARCHAR2	120	Y
PRICING_SEGMENT_EXPLANATION	VARCHAR2	4000	Y
PRICING_STRATEGY_EXPLANATION	VARCHAR2	4000	Y
SEGMENT_EXPLANATION_MSG_NAME	VARCHAR2	120	Y
STRATEGY_EXPLANATION_MSG_NAME	VARCHAR2	120	Y
PRICING_STRATEGY_ID	NUMBER	22	Y
FREEZE_TAX_FLAG	VARCHAR2	4	Y
SHIPSET_FLAG	VARCHAR2	4	Y
FULFILL_ORG_ID	NUMBER	22	Y
SUPPLIER_ID	NUMBER	22	Y
SUPPLIER_SITE_ID	NUMBER	22	Y
DEMAND_CLASS_CODE	VARCHAR2	120	Y
SUBSTITUTE_ALLOWED_FLAG	VARCHAR2	4	Y
FREIGHT_TERMS_CODE	VARCHAR2	120	Y
FOB_POINT_CODE	VARCHAR2	120	Y
PACKING_INSTRUCTIONS	VARCHAR2	4000	Y
SHIPPING_INSTRUCTIONS	VARCHAR2	4000	Y
SHIPMENT_PRIORITY_CODE	VARCHAR2	120	Y
REQUEST_SHIP_DATE	DATE	7	Y
LATEST_ACCEPTABLE_SHIP_DATE	DATE	7	Y
EARLIEST_ACCEPTABLE_SHIP_DATE	DATE	7	Y
CARRIER_ID	NUMBER	22	Y
SHIP_MODE_OF_TRANSPORT	VARCHAR2	120	Y
SHIP_CLASS_OF_SERVICE	VARCHAR2	120	Y
REQUEST_ARRIVAL_DATE	DATE	7	Y
LATEST_ACCEPT_ARRIVAL_DATE	DATE	7	Y
EARLIEST_ACCEPT_ARRIVAL_DATE	DATE	7	Y
SUBMITTED_FLAG	VARCHAR2	4	Y
REFERENCE_HEADER_ID	NUMBER	22	Y
FREEZE_PRICE_FLAG	VARCHAR2	4	Y
FREEZE_SHIPPING_CHARGE_FLAG	VARCHAR2	4	Y
PAYMENT_TERM_ID	NUMBER	22	Y
SOLD_TO_PARTY_CONTACT_POINT_ID	NUMBER	22	Y
MODIFIED_FLAG	VARCHAR2	4	Y
REVISION_SOURCE_ORDER_SYSTEM	VARCHAR2	120	Y
APPROVAL_SEQUENCE_NUMBER	NUMBER	22	Y
TRADE_COMPLIANCE_RESULT_CODE	VARCHAR2	120	Y
CREATED_IN_RELEASE	VARCHAR2	60	Y
SUBMITTED_DATE	TIMESTAMP(6)	11	Y
SUBMITTED_BY	VARCHAR2	256	Y
SALES_CHANNEL_CODE	VARCHAR2	120	Y
SALESPERSON_ID	NUMBER	22	Y
AGREEMENT_HEADER_ID	NUMBER	22	Y
AGREEMENT_VERSION_NUMBER	NUMBER	22	Y
BATCH_ID	NUMBER	22	Y
CREATION_MODE	VARCHAR2	120	Y
MDO_FLAG	VARCHAR2	4	Y

Indexes

INDEX NAME	INDEX TYPE	UNIQUENESS	COLUMN NAME
DOO_HEADERS_ALL_FK1	NORMAL	NONUNIQUE	SOLD_TO_CUSTOMER_ID
DOO_HEADERS_ALL_FK2	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_NC00086$
DOO_HEADERS_ALL_FK3	NORMAL	NONUNIQUE	SOLD_TO_PARTY_ID
DOO_HEADERS_ALL_N1	NORMAL	NONUNIQUE	SOURCE_ORDER_NUMBER
DOO_HEADERS_ALL_N1	NORMAL	NONUNIQUE	SOURCE_ORDER_SYSTEM
DOO_HEADERS_ALL_N2	NORMAL	NONUNIQUE	OPEN_FLAG
DOO_HEADERS_ALL_N2	NORMAL	NONUNIQUE	ORG_ID
DOO_HEADERS_ALL_N2	NORMAL	NONUNIQUE	SOURCE_ORDER_SYSTEM
DOO_HEADERS_ALL_N2	NORMAL	NONUNIQUE	HEADER_ID
DOO_HEADERS_ALL_N3	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_NC00087$
DOO_HEADERS_ALL_N4	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_NC00088$
DOO_HEADERS_ALL_N5	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_NC00095$
DOO_HEADERS_ALL_PK	NORMAL	UNIQUE	HEADER_ID
DOO_HEADERS_ALL_UK1	NORMAL	UNIQUE	SOURCE_ORDER_ID
DOO_HEADERS_ALL_UK1	NORMAL	UNIQUE	SOURCE_ORDER_SYSTEM
DOO_HEADERS_ALL_UK1	NORMAL	UNIQUE	SUBMITTED_FLAG
DOO_HEADERS_ALL_UK1	NORMAL	UNIQUE	CHANGE_VERSION_NUMBER
DOO_HEADERS_ALL_UK2	NORMAL	UNIQUE	ORDER_NUMBER
DOO_HEADERS_ALL_UK2	NORMAL	UNIQUE	SOURCE_ORDER_SYSTEM
DOO_HEADERS_ALL_UK2	NORMAL	UNIQUE	SUBMITTED_FLAG
DOO_HEADERS_ALL_UK2	NORMAL	UNIQUE	CHANGE_VERSION_NUMBER

Related Posts
Sales Order Table Linkage in Oracle Fusion – DOO_HEADERS_ALL
Oracle Fusion Sales Order Table – DOO_HEADERS_ALL
Sales Order Query in Oracle Fusion

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com