Order needs to be closed , however line Wf seems stuck with active status.
An old order from 2010 , where the order (2153270) header is in Booked Status and Line is also in Booked Status . The Delivery (1100357 ) status is closed as well with Line Status as Shipped and Next Step as 'Run Interfaces'.
Executed the Interface trip Stop with above delivery id and get the warning as below:
Interface trip stop is completed with warning
wf CompleteActivity error ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/7210298'.
X_Return_status is now WARNING
Below is the output as it shows that wf process is not errored.
1) select wdd.source_header_number, wdd.source_line_id, wdd.delivery_detail_id, wdd.released_status,wdd.creation_date , source_code , oe_interfaced_flag From wsh_delivery_details wdd where source_line_id = 7210298;