OEXOEORD: Sales Order Line Status is Picked, flow_status_code is Awaiting_Shipping

(Doc ID 740551.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 to 12.1.2 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
OEXOEORD.fmb
***Reviewed for currency 8/4/10***
***Checked for relevance on 29-JUN-2015***

Goal

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?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms