Search 800 + Posts

Nov 30, 2009

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

Recently I was geeting this error while trying to Run the ITS for order line  ('ATO Item').During my analysis I found that Order line status is 'SUPPLY_ELIGIBLE' and workflow for the order line is "CREATE_SUPPLY_ORDER_ELIGIBLE" Notified status , but to my surprise Delivery details was SHIPPED.
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
  1. Order line
  2. Workflow and
  3. Delivery Details
It was for sure a case of data corruption and I had noticed that end user try to FORCE the workflow.

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.

No comments:

Post a Comment