My Oracle Support Banner

Unable to Update Tracking Number on Delivery Details Using API: wsh_delivery_details_pub.update_shipping_attributes (Doc ID 1944738.1)

Last updated on FEBRUARY 19, 2019

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.

When updating using the API, it fails and get the below message in sqldeveloper log:
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)
msg_buffer ==> Status "XX-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


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.