Oracle Fusion · Data dictionary
DOO_HEADERS_ALL
SharedUsed in 17 subject areas31 reporting columns
Order Management (DOO) — header table — one row per transaction or event (with detail in the paired _LINES table).
Likely primary key: HEADER_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BILLING_SET_FLAG | ● | Indicator (Y/N) for the billing set. | |
| CANCELED_FLAG | ● | Indicator (Y/N) for the canceled. | |
| CANCEL_REASON_CODE | ● | Code identifying the cancel reason. | |
| CHANGE_VERSION_NUMBER | ● | Change version number. | |
| CONVERSION_DATE | ● | Conversion date. | |
| CONVERSION_RATE | ● | Conversion rate. | |
| CONVERSION_TYPE_CODE | ● | Code identifying the conversion type. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUSTOMER_PO_NUMBER | ● | Customer purchase order number. | |
| HEADER_ID | PK? | ● | Identifier for the header. |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| ON_HOLD | ● | On hold. | |
| OPEN_FLAG | ● | Indicator (Y/N) for the open. | |
| ORDERED_DATE | ● | Ordered date. | |
| ORDER_NUMBER | ● | Order number. | |
| ORDER_TYPE_CODE | ● | Code identifying the order type. | |
| ORIG_SYS_DOCUMENT_REF | ● | Orig sys document reference. | |
| PRICING_DATE | ● | Pricing date. | |
| REQUEST_SHIP_DATE | ● | Request shipment date. | |
| SALESPERSON_ID | ● | Identifier for the salesperson. | |
| SALES_CHANNEL_CODE | ● | Code identifying the sales channel. | |
| SOLD_TO_PARTY_ID | ● | Identifier for the sold to party. | |
| SOURCE_DOCUMENT_TYPE_CODE | ● | Code identifying the source document type. | |
| SOURCE_ORDER_NUMBER | ● | Source order number. | |
| SOURCE_ORDER_SYSTEM | ● | Source order system. | |
| SUBMITTED_BY | ● | Submitted by. | |
| SUBMITTED_DATE | ● | Submitted date. | |
| SUBMITTED_FLAG | ● | Indicator (Y/N) for the submitted. | |
| TRANSACTIONAL_CURRENCY_CODE | ● | Currency code for the transactional. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - New COGS and Gross Margin Details Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Distributed Order Orchestration - Order Headers Real Time
- Distributed Order Orchestration - Order Holds Real Time
- Distributed Order Orchestration - Order Lines Real Time
- Distributed Order Orchestration - Price Adjustments Real Time
- Fiscal Document Capture Transactions Real Time
- Fiscal Document Holds Real Time
- Fiscal Document Item Deliveries Real Time
- Inventory - Inventory Transfer Order Real Time
- Inventory - Kanban Activity Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Supervision Real Time
- Product Genealogy - Genealogy Instance Real Time
- Shipping Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for DOO_HEADERS_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.