Error searching for locations in PSR Ordering Dialog Search Locations window; java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
(Doc ID 1958351.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
A java.sql.SQLSyntaxErrorException: ORA-01722: invalid number error is thrown when attempting to search for a location in the PSR Ordering Dialog window.
Image of error in GUI
Error text in GUI
5. Click the Search Now button and the exception is thrown
The issue can cause concern and confusion for users that encounter the
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