Ora-04023 Reported while Accessing Valid Objects

Hello,
In this blog post, I will describe ORA-04023 error when you query a view as below.

SQL> Select * from  abone.ABONE_BILGILERI_VW;

Select against a view fails with following error.
ORA-04023: could not be validated or authorized

When I check the referenced objects, all were valid in database.This is issue is due to a timestamp inconsistency in the data dictionary. This timestamp inconsistency will lead to the problem when we populate the relevant cached objects and later try to select from the affected views. Run following script to find out the objects which are having timestamp discrepancies.

Connect as / as sysdba
SQL> @?/rdbms/admin/utldtchk.sql

This script is available from 11g onwards. Recompile all the objects manually returned by this script. It will remove the timestamp inconsistency in data dictionary and resolve this issue.