OEXOEORD: Sales Order Line Status is Picked, flow_status_code is Awaiting_Shipping
(Doc ID 740551.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Order Management - Version 220.127.116.11 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Reviewed for currency 8/4/10***
***Checked for relevance on 29-JUN-2015***
Q1: In the Sales order form, why does a line show status = 'Picked', yet in the HTMomse11i.sql, the line shows status = AWAITING SHIPPING?
You have a custom report that shows all the orders and their statuses from OM side and from Delivery side. The problem is when you get this information from OM side, from back end which is flow_status_code, you never get status of 'picked'. However, from the front end, the sales order form displays a status of 'Picked', which you want to display on the report.
Where does OM get this value of 'Picked' if not from the oe_order_lines_all table, field 'flow_status_code'?
Q2: You can link the records from OM to mtl_material_transactions but want to know how the 'Picked' status is derived. Is it not stored anywhere in the table? Or it just gets derived when the line is created in mtl_material_transaction table?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document