DATAFIX: Order Header Remains in Booked Status Where as All Lines Are In A Closed And/Or Cancelled Status
(Doc ID 1517127.1)
Last updated on JANUARY 07, 2022
Applies to:Oracle Order Management - Version 126.96.36.199 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
After all order lines are closed and/or cancelled, the order header is stuck in a booked status and is not progressing to closure. The header workflow activity is in the close wait for line workflow activity as follows:
Order Flow - Generic Close - Order Active CPGI_R_STANDARD_HEADER CLOSE_HEADER_PROCESS
Close - Order Wait Null Complete CLOSE_HEADER_PROCESS WAIT
Close - Order Close - Wait For Line Notified CLOSE_HEADER_PROCESS CLOSE_WAIT_FOR_L
Expect that the order header would progress to closure since all lines are already closed or cancelled.
Following select Identified all such Orders.
SELECT P.INSTANCE_LABEL, WAS.ITEM_KEY, H.ORDER_NUMBER, H.ORG_ID
FROM WF_ITEM_ACTIVITY_STATUSES WAS,
WHERE TO_NUMBER(WAS.ITEM_KEY) = H.HEADER_ID
AND WAS.PROCESS_ACTIVITY = P.INSTANCE_ID
AND P.ACTIVITY_ITEM_TYPE = 'OEOH'
AND P.ACTIVITY_NAME = 'CLOSE_WAIT_FOR_L'
AND WAS.ACTIVITY_STATUS = 'NOTIFIED'
AND WAS.ITEM_TYPE = 'OEOH'
AND NOT EXISTS ( SELECT /*+ NO_UNNEST */ 1
WHERE HEADER_ID = TO_NUMBER(WAS.ITEM_KEY)
AND OPEN_FLAG = 'Y');
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