ORA-04023: Object alter view, ERROR at line 1:

Issue

Getting the following error while recompiling a specific database object:

alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile

*

ERROR at line 1:

ORA-04023: Object alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile

Root cause of the issue

Possibly the there are issues in the shared pool, which could be related to some form of data corruption. Simply flush the shared pool to get rid of this issue.

Resolution

Step 1. Login as sysdba and flush the shared pool

sqlplus / as sysdba

alter system flush shared_pool;

Step 2. Now try to recompile the package again:

conn owbsys/owbsys

alter view UAB_RT_EXEC_PROC_RUN_COUNTS compile

package altered

Environment

• Oracle E-Business Suite Release 12.2.4
• Oracle Linux x86-64