Oracle Order Management & Shipping Execution – Sales Order Line Status Flow & Meaning

Oracle Order Management & Shipping Execution – Sales Order Line Status Flow & Meaning

In Oracle Order Management the order line status is captured in the Line Items Main tab in the Status field. In Oracle Shipping Execution the status displays the delivery line status in the Shipping Transactions form on the Lines/LPN Main tab in the Line Status field.

 ‘OM’ denotes the flow in Order Management Sales order form &

 ‘SE’ denotes the flow in Shipping Transaction Form

For a standard flow the statuses are:

S no	Status	Form	Meaning
1	Entered	OM	Order is saved but not booked
2	Booked	OM	Order booked
3	Awaiting Shipping	OM	Order is booked, but the lines are not yet picked
4	Not Ready to Release	SE	When the lines are interfaced manually into Shipping, are not scheduled and has no reservations. When lines are imported automatically from OM this status is not used
5	Released to Warehouse	SE	Pick Release started but not yet completed. One of the reason could be allocation have not been pick confirmed. The Pick Release process creates a Move Order Header & Mover Order Line in Inventory. This is a common status when performing a two-step pick release process. This status indicates that inventory allocation has occurred however pick confirmation is performed.
6	Ready to Release	SE	Sales order Line is booked and entry is done in shipping table & eligible for pick release
7	Backordered	SE	Backordered status exist during the below scenarios -          When the order line quantity is not fulfilled by the on-hand reservable quantity -          User Manually backordered the entire delivery line quantity.
8	Shipped	SE	Delivery line is ship confirmed
9	Confirmed	SE	Delivery line is shipped or backordered and the trip stops are open.
10	Picked	OM	Pick release is complete, both allocations and pick confirm
11	Picked Partial	OM	This status exist when the delivery line is not allocated the full quantity during the pick release & ship confirm not occurred.
12	Interfaced	SE	Delivery line is shipped & Inventory interface trip stop concurrent is completed
13	Awaiting Fulfillment	OM	This status exist when fulfillment set is used, not all shippable lines in a fulfillment set or a configuration is fulfilled.
14	Fulfilled	OM	When all the lines in a fulfilment set are fulfilled
15	Interfaced to Receivables	OM	This status exist when the sales order is linked with receivables and the invoice is created.
16	Partially Interface to Receivables	OM	This status exist during a PTO flow and indicated that the particular PTO item is required for revenue.
17	Closed	OM	This status exist when the sales order line is closed
18	Canceled	OM	This status exist when the line has been completely canceled & no further processing will occur for the line.

References: Oracle Order Management Implementation Guide.

Oracle Order Management – Pick Release Status in wsh_delivery_details

Oracle Order Management – Pick Release Status in wsh_delivery_details

Once a Sales Order line is booked, the Shippable lines enter into “wsh_delivery_details” table. The column “Released Status” has below status values which provide the information of the Sales Order line pick release status

Released Status	Status	Definition
B	Backordered	Line failed to be allocated in Inventory
C	Shipped	Line has been shipped
D	Cancelled	Line is Cancelled
I	Interfaced	Line has been shipped and interfaced to Order Management and Inventory
N	Not Ready for Release	Line is not ready to be released
R	Ready to Release	Line is ready to be released
S	Released to Warehouse	Line has been released to Inventory for processing
X	Not Applicable	Line is not applicable for Pick Release
Y	Staged	Line has been picked and staged by Inventory

B: Backordered: 

When the Sales Order is pick released but On-hand is not available for the order line, in this scenario the order line is back ordered and the released status = 'B'

C: Shipped:

Once the Order line is shipped the associated delivery details Released Status is changed to 'C'. OM interface and Inventory interface have processed and the trip is closed.

D: Cancelled:

When the Order line is cancelled the released status = 'D'

I: Interfaced:

When the Order line is interface the released status = ‘I’

N: Not Ready for Release: 

Line is not ready to be released. This can happen when the information is available in wsh_delivery_details but order line has not reached the Awaiting Shipping status, might be due to some workflow customization

R: Ready to Release: 

Order line has been booked and the line is ready to be pick released. Line status is Awaiting Shipping

S: Released to Warehouse: 

Depending on the Pick release process in the business it might be that Pick release is performed with Auto Pick confirm Set to No. In this scenarios when we do pick release the Move Order will be created. Move Order allocation is done, but since Auto Pick Confirm is set to No the Move Order will not be transacted. The Delivery Detail will be in state: Pick Wave

X: Not Applicable:

Line is not applicable for Pick Release, for the non-shippable item lines ex: Warranty orders

  

Y: Staged:

Line has been picked and staged by Inventory. In this Case the line has been pick released. The Move Order Creation, Allocation and transaction is completed. Goods have be transferred from the Source Sub-inventory to Staging area of the warehouse and the line is ready to be shipped

Oracle R12 - Difference between Inter Organization Transfer & Internal Sales Order?

Oracle R12 - Difference between Inter Organization Transfer & Internal Sales Order?

S no	Inter Org Transfer	Internal Sales Order
1	No Approval Process	Approval Process is required
2	Tracking is not possible	Tracking is possible
3	Transfer is possible from one org to another org within an operating unit only	Transfer is possible from one org to another org across the operating units within the company
4	Simple process – Transfer completes in few steps	Complicated – Transfer completes after many steps
5	Process completes in Oracle Inventory Responsibility	Process flows in Oracle Purchasing, Oracle Order Management & Oracle Inventory