Error searching for locations in PSR Ordering Dialog Search Locations window; java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
Last updated on FEBRUARY 22, 2017
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
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