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.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. 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