Unable to Autocreate Deliveries in Shipping Transactions Form And Pick Release Fails When Autocreate Delivery = Yes

(Doc ID 2393256.1)

Last updated on APRIL 30, 2018

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 in the Shipping Transactions form, get the following error

Error: Failed to autocreate deliveries in organization Jomvu .

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:

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms