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 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrading the Repository DataBase from 12.1.0.2 to 19.5.0.0 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

 

 

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
Cause
Solution


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