My Oracle Support Banner

Send Planned Shipment Interface Transmission With Changes from OTM to EBS Completes With "Could not find delivery detail to Process" " When Others exception. Setting l_tms_sshipunit_id to null" (Doc ID 2727709.1)

Last updated on NOVEMBER 10, 2020

Applies to:

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


When attempting to send interface transmission from OTM with changes in carrier or some other details,
find that it is completing in error in EBS


Error messages shown during processing.

  Could not find delivery detail to process

  p_message_name ==> WSH_OTM_GENERIC

  There was an error processing the interface data from Oracle Transportation Management.

  Please update and reprocess the records using the Interface Message Corrections Form to close the exception.

  When Others exception. Setting l_tms_sshipunit_id to null


The issue can be reproduced at will with the following steps:

1. Created sales order
2. Created batch and sent the details to OTM
3. Created shipment in otm and sent the details to EBS
4. Launched the planned shipment program in EBS
5. Changed the details in otm and sent to EBS and try to launch the planned shipment program.
  -- we are trying to change the details in OTM and trying to push it to EBS after the planning is published to EBS.
Errors in log are shown




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.