My Oracle Support Banner

Pick release completes with error: Could Not Find Program Unit Being Called (Doc ID 2657736.1)

Last updated on FEBRUARY 06, 2021

Applies to:

Oracle Shipping Execution - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Order Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Pick Release

When attempting to Pick release an order on a TEST instance, the following error occurs

ERROR
-----------------------
msg_buffer ==> Error in Routine WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_to_Delivery, Oracle Error - -6508
 ORA-06508: PL/SQL: could not find program unit being called
  U:Error in Routine WSH_DELIVERY_DETAILS_ACTIONS.Assign_Detail_to_Delivery, Oracle Error - -6508
ORA-06508: PL/SQL: could not find program unit being called

ERROR IN WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY FOR 18345883 TO 22631474
  
  THE UNEXPECTED ERROR FROM WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES IS User-Defined Exception
Error occurred in WSH_DELIVERY_AUTOCREATE.Autocreate_Deliveries
Error occurred in WSH_PICK_LIST.Autocreate_Deliveries


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Pick release any order
2. Pick release request completes with "Exception occurred in WSH_PICK_LIST"
3. Review debug log file, see above error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pick release this order. Therefore it is not possible to ship confirm this order or to recognize any revenue on this order. This also causes a delayed shipment and an unhappy customer

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


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