Pick Selection List Generation - SRS Completing With Error After Upgrade To Release 12.2.4

(Doc ID 1993552.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

After upgrading to Release 12.2.4, the Pick Release - SRS is not able to complete successfully. The following error messages were found in the log file.

ERROR
-----------------------
Unexpected error has occured. Oracle error message is ORA-01403: no data found

      WSH_PR_CRITERIA.Get_Lines l_return_status ==> U
Error occurred in WSH_PR_CRITERIA.Get_Lines
SQLCODE: 1 SQLERRM: User-Defined ExceptionWSHPRCRB.pls

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