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 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.


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:


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 ==>
(06/07/2011 02:43:22 AM, )
The unexpected Error Code -1002 : ORA-1002: fetch out of sequence

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


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