EM 13c: Running custom SQL fails with following errors against EM repository DB: 'ORA-01722: Invalid Number' and 'ORA-01847: day of month must be between 1 and last day of month' (Doc ID 2801775.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Symptoms

After upgrading the EM Repository Database, custom SQL statement is failing: 

ORA-01722: Invalid Number

and

ORA-01847: day of month must be between 1 and last day of month

Issue related to Parent Note 
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)

Below lists other custom SQL statement failing with error 'ORA-01722: Invalid Number' and 'ORA-01847: day of month must be between 1 and last day of month' that are documented below:

1) Metric Extension created (i.e. ME$ALT_TABLESPACE_MONI) and sql being used in ME is below :

Cause

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