My Oracle Support Banner

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 later
Information 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
-------------

Error: Failed to autocreate deliveries in organization xxx.

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
----------------

  P_MODULE_NAME ==> wsh.plsql.WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY
  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

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. 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


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