Pick Selection List Generation Ending In Error, Invalid Package Body WSH_DELIVERY_VALIDATIONS

(Doc ID 2315085.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Pick Release

When attempting to pick release an order, the following error occurs.

ERROR
-----------------------
 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 3976568 TO 11231138
 PROC WSH_DELIVERY_DETAILS_ACTIONS.ASSIGN_DETAIL_TO_DELIVERY RETURNED UNEXPECTED ERROR
msg_buffer ==> Error in Routine WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES, Oracle Error - 1 User-Defined Exception

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Pick Release  the problematic orders
2. Pick Release completes with error
3. View the pick release log file, see the above error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot pick release or ship confirm these order. This causes a shipping delay and an unhappy customer

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