My Oracle Support Banner

Deliveries From OTM Are Not Processing - Error: One Or More Deliveries Could Not Be Unassigned From Trip (Doc ID 2795795.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Shipping Execution - Version 12.2.9 and later
Information in this document applies to any platform.


On : 12.2.9 version, Packing Workbench

12.2.9 - Deliveries from OTM is not processing in Shipping

When trying to process the delivery from OTM to Shipping facing Error :

One or more deliveries could not be unassigned from trip &TRIP_NAME.Unexpected Error: Error in Routine WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES, Oracle Error - 100
ORA-01403: no data foundUnexpected Error: One or more deliveries could not be unassigned from trip 16459723.There was an error processing the interface data from Oracle Transportation Management.

The issue can be reproduced at will with the following steps:
1. Go to Shipment message correction form.
2. Query delivery
3. Try to re-process
4. See the error in the log




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.