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 APRIL 04, 2025
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
-----------------------
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
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 |