Unable to Book Sales Order Ora-20001 Error in Wsh_interface (Doc ID 2173399.1)

Last updated on OCTOBER 03, 2023

Applies to:

Symptoms

After applying patch 21817524:R12.WMS.C, the following errors appear when attempting to book a new sales order:

ERROR
-----------------------
msg_buffer ==> Error in Routine WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS,  Oracle Error - -6508
Line 24288:             msg_buffer ==> Error in Routine WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS,  Oracle Error - -6508
Line 24290:             U:Error in Routine WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS,  Oracle Error - -6508
Line 24290:             U:Error in Routine WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS,  Oracle Error - -6508
Line 24309:   ERROR IN WSH_INTERFACE.PROCESS_RECORDS / UPDATE_INVENTORY_INFO
l_errmsg User-Defined Exception
L_MSG_DATA=User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Update_Shipping_From_OE
EXIT Save_API_Messages
LEAVING OE_MSG_PUB.ADD
PROCESS_SHIPPING_ACTIVITY : UNEXPECTED ERROR
LEAVING OE_MSG_PUB.ADD
RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIPPING_ACTIVITY U
LEAVING OE_MSG_PUB.ADD
In WF save messages
ENTER Save_API_Messages
l_errmsg ORA-20001:
L_MSG_DATA=User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Update_Shipping_PVT
L_MSG_DATA=User-Defined Exception in Package OE_Shipping_Integration_PVT Procedure Process_Shipping_Activity
L_MSG_DATA=Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.
Line 24342: PROCESS_SHIPPING_ACTIVITY : UNEXPECTED ERROR
Line 24351: L_MSG_DATA=Workflow activity Ship has failed. Please fix the errors and retry the activity from the Order Form or the Workflow Monitor.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Orders Workbench > Enter a new sales order
3. Book order


.

Cause

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