Unable to Update Tracking Number on Delivery Details Using API: wsh_delivery_details_pub.update_shipping_attributes
Last updated on DECEMBER 07, 2017
Applies to:Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
On : 12.1.3 version, Open Interfaces & Public APIs
When attempting to update the tracking number on a 'Staged/Pick Confirmed' delivery detail using the API wsh_delivery_details_pub.update_shipping_attributes it errors out.
When doing the same action using the Shipping Transactions form, it is successful.
anonymous block completed
l_return_status is E
API error for delivery_detail_id error msg
Upon further investigation and obtaining the Shipping debug log for the API, the log shows the following error message:
Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 120.21.12010000.7) (10/20/2014 09:34:31 AM)
P_MESSAGE_TYPE ==> E
msg_buffer ==> Status "VE-Shipping" of Subinventory SHIPPING disallows this transaction.
Exiting WSH_UTIL_CORE.ADD_MESSAGE (10/20/2014 09:34:31 AM, .01 seconds)
The issue can be reproduced at will with the following steps:
1. Use API wsh_delivery_details_pub.update_shipping_attributes to update tracking number
2. The API errors out with the above error message
The issue has the following business impact:
Due to this issue, users cannot update tracking number via API
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms