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.

Symptoms

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  

 

Cause

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