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 FEBRUARY 22, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.


java.sql.SQLSyntaxErrorException: ORA-01722: invalid number error is thrown when attempting to search for a location in the PSR Ordering Dialog window.

NOTE: The behavior occurs when attempting a Location Search by City name without first specifying a State value.  Example; DALLAS is a valid City name for the State of Texas(TX).  Searching for City = DALLAS without State = TX results in the exception.



Image of error in GUI

Error text in GUI

5. Click the Search Now button and the exception is thrown

Business Impact

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