Unexpected Error Calling WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY (Doc ID 2252232.1)

Last updated on APRIL 12, 2017

Applies to:

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

Symptoms

On :  12.1.3 version, Open Interfaces & Public APIs

When using custom code which calls Oracle public API WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY, the following error occurs.

ERROR
-----------------------
Unexpected error has occured. Oracle error message is User-Defined Exception
Error in Updating ARN number for the delivery

P_MODULE_NAME ==> wsh.plsql.WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME
      msg_buffer ==> Invalid Delivery Name
      E:Invalid Delivery Name

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.  Set OM, INV, and WSH debugging profiles
2.  Execute custom code which calls PI WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY
3.  An error occurs
4.  Review the log file to see the above error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the API WSH_DELIVERIES_PUB.CREATE_UPDATE_DELIVERY to automatically update deliveries.
  Individual deliveries must be updated in the User Interface, which is a very time consuming process.

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