Unable to Autocreate Deliveries in Shipping Transactions Form And Pick Release Fails When Autocreate Delivery = Yes
(Doc ID 2393256.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Shipping Execution - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version:
When attempting to Autocreate Delivery in the Shipping Transactions form, get the following error
Details of message:
ORA-06508: PL/SQL: could not find program unit being called in Package WSH_YMS_INTEGRATION_PVT Procedure _x_
------------------------------------
Unexpected Error: Error in Routine WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DELIVERY_DETAIL, Oracle Error - -6508
ORA-06508: PL/SQL: could not find program unit being called
------------------------------------
Error: Deliveries could not be automatically created. The lines may already be assigned to existing deliveries.
Also, when attempting to run the "Pick Selection List Generation" with Autocreate Delivery Yes, it completes with Error.
The log shows the following errors:
msg_buffer ==> Error in Routine WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DELIVERY_DETAIL, Oracle Error - -6508
ORA-06508: PL/SQL: could not find program unit being called
U:Error in Routine WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DELIVERY_DETAIL, Oracle Error - -6508
ORA-06508: PL/SQL: could not find program unit being called
Exiting WSH_UTIL_CORE.ADD_MESSAGE (04/24/2018 08:55:47 PM, 0 seconds)
Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (04/24/2018 08:55:47 PM, 0 seconds)
Unexpected error has occured. Oracle error message is ORA-06508: PL/SQL: could not find program unit being called
Exiting WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY - EXCEPTION:OTHERS (04/24/2018 08:55:47 PM, .01 seconds)
Exiting WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY (04/24/2018 08:55:47 PM, .01 seconds)
ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR 9909144 TO 8513510
PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED ERROR
Entering WSH_UTIL_CORE.ADD_MESSAGE (WSHUTCOB.pls 120.27.12020000.7) (04/24/2018 08:55:47 PM)
P_MESSAGE_TYPE ==> E
P_MODULE_NAME ==>
msg_buffer ==> Deliveries could not be automatically created. The lines may already be assigned to existing deliveries.
...
Exiting WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES (04/24/2018 08:55:47 PM, .04 seconds)
WSH_DELIVERY_AUTOCREATE.Autocreate_Deliveries l_return_status ==> E
Current Time is ==> 04/24/2018 08:55:47 PM
Error occurred in WSH_DELIVERY_AUTOCREATE.Autocreate_Deliveries
End of log shows:
Error occurred in WSH_PICK_LIST.Autocreate_Deliveries
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST.Release_Batch_Sub
Error occurred in Release_Batch_Sub
SQLCODE: 1 SQLERRM: User-Defined Exception
Exception occurred in WSH_PICK_LIST
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to Autocreate Delivery in the Shipping Transactions form
2. Or Submit the "Pick Selection List Generation"
3. Both processed end with an Error.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Unable to autocreate deliveries for orders so they cannot be shipped
Also not able to pick release orders with Autocreate Delivery = Yes
So the whole company is grounded
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 |