My Oracle Support Banner

Custom Programs Error With "Java.sql.SQLSyntaxErrorException: ORA-01722: Invalid Number" (Doc ID 2333426.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.


Created a custom report to obtain General Ledger details errors in Production.

The report query is retrieving data from database, but through concurrent processing it errors with message => java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

For the same parameters it ran successfully initially, later it error-ed for same parameters and different parameters.

Need to run the program successfully without any issue.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.