Error that I was geeting was - ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/xxxxx'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt .
with the status of
- Order line
- Workflow and
- Delivery Details
Reason for this Error was , at the time of ITS , Order Management expects that Order Line workflow should be at SHIP_LINE - Notified status , but in this case it was not at SHIP_LINE-Notifed.On Further analysis I have noticed that after user progress the Order line from SUPPLY_ELIGIBLE , workflow progressed to SHIP_LINE- Notified and created work order in WIP , but on completion of WIP workflow was not progress any further rather it was return back to 'CREATE_SUPPLY_ORDER_ELIGIBLE'( Not able to analyze why that has happened, as that was stand alone incident).
First thing I did was advise user not to FORCE the workflow and Secondly open an SR with Oracle to get data-fix.