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

Last updated on AUGUST 17, 2016

Applies to:

Oracle Shipping Execution - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

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)
P_MESSAGE_TYPE ==> E
P_MODULE_NAME ==>
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)

 

STEPS
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

BUSINESS IMPACT
The issue has the following business impact:
Due to this issue, users cannot update tracking number via API

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