My Oracle Support Banner

Error: Status "&status" of Onhand disallows this transaction, When Using WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES API And Does Not Update Delivery Detail Columns (Doc ID 2944693.1)

Last updated on APRIL 26, 2023

Applies to:

Oracle Inventory Management - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES API is not updating the columns: Seal Code and Gross Weight in delivery detail tab in Shipping Transactions form.
The Material Status at onhand level is enabled.

The API is validating material status of all LPN in on hand table and if any one LPN is not in Active status, then throwing this error message.

ERROR
-----------------------

Calling program unit INV_VALIDATE.VALIDATELOCATOR
INV_MTL_CLASSIFICATION_PUB: is_mcc_transaction_tagged entered
INV_CACHE: p_pxn_type:18 l_txn_type:18
INV_CACHE: found in cache
INV_MATERIAL_STATUS_GRP: l_mcc_tagged_rcpt :1
INV_MATERIAL_STATUS_GRP: p_trx_type_id :33
INV_MATERIAL_STATUS_GRP: Exited Commingling check :
  Exiting WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR
  Result after validate locator ==> FALSE
  Return status after validate locator ==> S
  Invalid Locator
  FND_API.G_EXC_ERROR exception has occurred.
Exiting WSH_DELIVERY_DETAILS_GRP.VALIDATE_DETAIL_LINE - EXCEPTION:FND_API.G_EXC_ERROR
  Calling program unit WSH_UTIL_CORE.API_POST_CALL
  Validation failure for detail ==> XXXXXXXX


 Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 120.27.12020000.15)
  P_MESSAGE_TYPE ==> E
  P_MODULE_NAME ==>
  msg_buffer ==> Status \"Curing Hold Status\" of Onhand disallows this transaction.

  Exiting WSH_UTIL_CORE.ADD_MESSAGE
  FND_API.G_EXC_ERROR exception has occurred.
Exiting WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES - EXCEPTION:FND_API.G_EXC_ERROR

STEPS
-----------------------
1. Update delivery detail columns such as:Seal Code and Gross Weight, using (WSH_DELIVERY_DETAILS_PUB.UPDATE_SHIPPING_ATTRIBUTES).

Script is mentioned below:

Get the above mentioned error message.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.