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 SEPTEMBER 06, 2023
Applies to:
Oracle Communications MetaSolv Solution - Version 6.2.1 and laterInformation in this document applies to any platform.
Symptoms
A 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
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |