Autocreate Delivery Fails When Pick Releasing and in Shipping Transactions Form Via Actions LOV
(Doc ID 2393256.1)
Last updated on APRIL 27, 2023
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 via Actions LOV in the Shipping Transactions form, the following error is raised:
ERROR
-------------
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.
When attempting to run the "Pick Selection List Generation" with Autocreate Delivery = Yes, the following error is raised:
ERROR
----------------
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
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
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. OM Super User Responsibility
2. Shipping
3. Releases Sales Order > Run pick release with autocreate delivery = Yes
or Shipping Transactions form > select Autocreate Delivery from Actions LOV
4. Both processes end with error.
Changes
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 |
Changes |
Cause |
Solution |
References |