My Oracle Support Banner

EM 13c While running the Customer SQL failed with ORA-01722: Invalid Number After upgrading the repository DB from 12c to 19c (Doc ID 2700945.1)

Last updated on AUGUST 16, 2020

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


After upgrading the Repository DataBase from to one of the custom SQL statement which is used in reports was failed with the ORA-01722: invalid number.

The following is the SQL used to run in 12c but not able to run in 19c/18c




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.