My Oracle Support Banner

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 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
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

EXPECTED BEHAVIOR
-----------------------
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,
WF_PROCESS_ACTIVITIES P,
OE_ORDER_HEADERS_ALL H
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
FROM OE_ORDER_LINES_ALL
WHERE HEADER_ID = TO_NUMBER(WAS.ITEM_KEY)
AND OPEN_FLAG = 'Y');

 

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.