Interface Trip Stop Error: Unexpected Error Has Occured Ora-06502
(Doc ID 386983.1)
Last updated on MAY 17, 2018
Applies to:Oracle Shipping Execution - Version 22.214.171.124 to 12.2.4 [Release 11.5.10 to 12.2]
Oracle Inventory Management - Version 126.96.36.199 to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS
Application Release: 188.8.131.52
Family pack level: J
After a recent upgrade to 184.108.40.206 you find that when the interface trip stop is run it completes with a warning.
There is the following error in the log file:
RIGHT BEFORE CALLING MTL_ONLINE_TRANSACTION_PUB.PROCESS_ONLINE
2840218: process_inv_online failed
The unexpected error is ORA-06502: PL/SQL: numeric or value error: character to
number conversion error
Unexpected error has occured. Oracle error message is ORA-06502: PL/SQL:
numeric or value error: character to number conversion error
Exiting WSH_SHIP_CONFIRM_ACTIONS.PROCESS_INV_ONLINE - EXCEPTION:OTHERS
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