My Oracle Support Banner

Why is Flow Status Code = PICKED but Database status is Awaiting_Shipping? (Doc ID 1918919.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Order Management - Version 12.0.6 and later
Information in this document applies to any platform.

Goal

Why is Flow Status Code = PICKED but DB status is Awaiting_Shipping?

Summary of Issue > See details below:

FileName
===========
imagem_1.png
Sales Order Number = XXX58
Line 1.1
Status Picked
Exam Field shows:
Block LINE
Field FLOW_STATUS_CODE
Value AWAITING_SHIPPING

FileName
===========
imagem_2.png
select flow_status_code
from oe_order_lines_all
where line_id = 7562468
Returned >> Awaiting_Shipping

FileName
===========
imagem_3.png
Sales Order Number = XXX58
Line 1.1
Status Picked
Exam Field shows:
Block LINE
Field LINE_ID
Value 7562468

FileName
============
imagem_4.png
Order Management Lookups
Access Level = User
Type: LINE_FLOW_STATUS
Meaning: Line Flow Status
Application: Order Management
Description: Line Flow Status

Code: PICKED
Meaning: Picked
Desc: Picked
From: 04-NOV-1999
Enabled: Checked
 

Solution

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
Goal
Solution


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