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