Skip to main content
OracleOps AI
Order Management

Create a Sales Order in Oracle Fusion

Capture a sales order for a business unit and customer, and route it into orchestration.

Navigation

Navigator→Order Management→Order Management→Create Order

Steps

Illustrative wireframe — not an actual Oracle Fusion screen

Navigator › Order Management › Order Management › Create Order

Business Unit

Vision Operations

Customer

Search customer…

Order Type

Standard Sales Order

Order Lines+ Add Item
ItemUOMQtyUnit PriceAmount
AS54888Ea10$249.00$2,490.00

Pricing Summary

Subtotal$2,490.00
Tax$199.20
Total$2,689.20

Shipping

WarehouseM1 – Seattle
Ship Date—
MethodGround
CancelSaveSubmit

Real Oracle Fusion Screens

Captured from a live Fusion instance with demo/test data — not a mockup.

The customer used in this walkthrough (TEST CUSTOMER 4321) set up via Receivables > Manage Customers, with its account and Bill-to/Ship-to site.
Create Order — customer, Bill-to/Ship-to, and an order line entered.

What Happens Technically?

Sales Order → DOO_HEADERS_ALL → DOO_LINES_ALL → DOO_FULFILL_LINES_ALL → Orchestration

Related Technical Objects

DOO_HEADERS_ALL

Curated

Order header — customer, order type, business unit.

Key columns

HEADER_IDORDER_NUMBERBUSINESS_UNIT_IDSOURCE_ORDER_SYSTEM

DOO_LINES_ALL

Curated

Order line — item, quantity, requested schedule.

Key columns

LINE_IDHEADER_IDINVENTORY_ITEM_IDORDERED_QUANTITY

DOO_FULFILL_LINES_ALL

Curated

Fulfillment/orchestration status for the line.

Key columns

FULFILL_LINE_IDLINE_IDHEADER_IDFULFILLMENT_LINE_STATUS_CODE

Common Errors

  • Order fails to submit when a required attribute (e.g. price list, warehouse) isn't defaulting — usually a setup gap on the order type or customer.
  • Line stuck at scheduling when there's no supply or the requested warehouse isn't enabled for the item.
  • Pricing shows zero or errors when no active price list is assigned to the business unit/customer combination.

Useful SQL

Find a sales order by number
SELECT header_id, order_number, business_unit_id, source_order_system
FROM doo_headers_all
WHERE order_number = :order_number;

Next Steps

Bill the Customer

Once the order ships, create the AR invoice that bills the customer for it.

See the Full Order-to-Cash Cycle

Orchestration, scheduling, shipping and cash application — everything that happens after Submit.

Ask Oracle AI about Create a Sales Order in Oracle Fusion