Interface Trip Stop Error ORA-20002: 3133: Activity instance 'SHIP_LINE' when SO Line is SUPPLY_ELIGIBLE (Doc ID 1181532.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 and later
Information in this document applies to any platform.
Executable:WSHINTERFACE - Interface Trip Stop

Symptoms

When attempting to run Interface Trip Stop the following error occurs.

ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified activity for item 'OEOL/1257241'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt
Error msg: ORA-20002: 3133: Activity instance 'SHIP_LINE' is not a notified acti
vity for item 'OEOL/1257241'. in Package OE_Delayed_Requests_PVT Procedure Process_Request_Pvt


The Sales Order line that is failing has been split, is for ATO item, and is in status SUPPLY_ELIGIBLE.  Under Ship Tolerances have been set

Steps:
1. Create a Sales Order having ATO Item Line with Undership Tolerance and manually split it, into many lines, having the last line quantity less than that needed to meet the tolerance.
2. Ship the Delivery Details corresponding to all other lines, except the last line.
3. Right Click -> Scheduling -> Unreserve on the Last Line.
4. Confirm the Workflow Status for the Line is at Create Supply Order - Eligible Notified.
5. Run ITS for the Delivery and see the error in Log.

Changes

This issue happens on ATO Item lines when split manually. If the undership tolerance is met by shipping one or more shipment lines then, during ITS execution for such lines, the delivery detail for the remaining unshipped quantity gets canceled and the corresponding order line is progressed from SHIP_LINE ("Ship") workflow activity with 0 (zero) shipped quantity. Here, OM code requires the Ship activity to be in Notified status. This is as per the existing functionality,

However, workflow for ATO Item lines can be in status other than Ship:Notified, if it is unreserved manually. In such case, the ITS fails with the error "Activity instance SHIP_LINE is not a notified activity".

The remaining split line was causing the ITS to fail, is in status SUPPLY_ELIGIBLE.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms