Submit Deliveries For Export Compliance Screening Fails With Error ORA-6502: PL/SQL: Numeric Or Value Error For Delivery Details With A Single Serial Number

(Doc ID 1349806.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to process WSH_ITM_EXPORT_SCREENING.PROCESS_SERIAL_NUMBERS by running the concurrent program "Submit Deliveries for Export Compliance Screening",  the following error occurs:


ERROR
-----------------------

ENTERING WSH_ITM_EXPORT_SCREENING.PROCESS_SERIAL_NUMBERS ==>
l_from_serial_num ==> TCC060601
l_to_serial_num ==>
l_real_serial_prefix ==> TCC
l_prefix_length ==> 3
l_from_numeric ==> 60601
l_to_numeric ==> is NULL
l_range_count ==> is NULL
The unexpected Error Code -6502 : ORA-6502: PL/SQL: numeric or
value error ==>
Exiting WSH_ITM_EXPORT_SCREENING.PROCESS_SERIAL_NUMBERS
(06/07/2011 02:43:22 AM, )
EXITING WSH_ITM_EXPORT_SCREENING.PROCESS_SERIAL_NUMBERS ==>
The unexpected Error Code -1002 : ORA-1002: fetch out of sequence


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) Order Management Super User Responsibility
2) Create a sales order for a serialized item
3) Reserve the item ( quantity = 1)
4) Attempt to pick and ship the order
5) Run "Submit Deliveries for Export Compliance Screening to send request for screening
6) Observe error in logs

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