My Oracle Support Banner

OEXOEORD: Sales Order Line Status is Picked, flow_status_code is Awaiting_Shipping (Doc ID 740551.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Oracle Order Management - Version 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***


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.