DATAFIX: Open_Flag And Cancelled_Flag = Y For Order Line In Cancelled Status Preventing Order From Progressing To Closure (Doc ID 2659146.1)

Last updated on DECEMBER 22, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

Order Header workflow in Notified - Close - Wait For Line and will not progress to closure.
Open Flag and Cancelled Flag = Y on the cancelled lines.
Order lines in CANCELLED status show the following warning:

Warning List:
10. Order_Line shows as OPEN but CANCELLED flag is set to Y.

 
EXPECTED BEHAVIOR

Expect that the order header would close since all order lines are closed or cancelled.  Lines in a Cancelled status with Cancelled flag = Y should have the Open flag = N.

Steps

Data corruption, issue cannot be reproduced at will

Changes

Cause

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