ORA-01555 with Query Duration=0

We have Oracle 12.2 running on Oracle database Appliance X7-2.

Randomly (about once in a day) when we run a report in Cognos 10 application that connects to this database, a report fails with a message similar to "table or view <table_name> was not found in the dictionary".

At the same time there is following error in the database alert log:

2020-03-31T11:50:15.565885-04:00

ORA-01555 caused by SQL statement below (SQL ID: 094rzh0muv671, Query Duration=0 sec, SCN:

0x0000001d9eb06f42

):

2020-03-31T11:50:15.566041-04:00

select TABLE_NAME, COLUMN_NAME, DATA_TYPE,                CASE WHEN DATA_TYPE IN ('CHAR', 'VARCHAR2', 'NCHAR', 'NVARCHAR2' ) THEN CHAR_LENGTH ELSE DATA_PRECISION END,            DATA_LENGTH, DATA_SCALE, NULLABLE      from