My Oracle Support Banner

Dropship Order Lines Stuck In Booked Status Even Though PO Is In Open Status (Doc ID 2735093.1)

Last updated on MAY 16, 2021

Applies to:

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

Symptoms

On : 12.2.6 version, Transaction Control

ACTUAL BEHAVIOR
---------------

Drop Ship Sales Order Line status is Booked while there exists an approved Purchase order against it

EXPECTED BEHAVIOR
-----------------------
Drop Ship Sales Order Line status should have been Awaiting Receipt


STEPS
-----------------------
The issue cannot be reproduced at will  and  below SQL will identify transactions with this issue

select l.line_id , l.header_id
,l.flow_status_code
,l.booked_flag, l.fulfilled_quantity, l.ordered_quantity
from oe_order_lines_all l ,
oe_drop_ship_sources ds
where l.source_type_code = 'EXTERNAL'
and l.booked_flag = 'Y'
and l.open_flag = 'Y'
and l.flow_status_code = 'BOOKED'
AND Nvl(cancelled_flag, 'N') = 'N'
AND Nvl(shippable_flag, 'N') = 'Y'
AND Nvl(fulfilled_flag, 'N') = 'N'
AND Nvl(shipped_quantity, 0) = 0
and ds.line_id = l.line_id;

Cause

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
Symptoms
Cause
Solution
References


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