ORA-00904 Error When Compiling The Invalid View PA_STATUS_TASK_GENERIC_V (Doc ID 1612593.1)

Last updated on JULY 06, 2022

Applies to:

Goal

The view PA_STATUS_TASK_GENERIC_V is invalid. Attempting to compile the object manually errors:

SQL> alter view PA_STATUS_TASK_GENERIC_V compile;

Warning: View altered with compilation errors
 
select * from dba_errors where name = 'PA_STATUS_RSRC_GENERIC_V';

OWNER NAME TYPE SEQUENCE LINE POSITION
------------------------------ ------------------------------ ------------ ---------- ---------- ----------
TEXT
-----------------------------------------------------------------------------------------------------------------
ATTRIBUTE MESSAGE_NUMBER
--------- --------------
APPS PA_STATUS_RSRC_GENERIC_V VIEW 1 0 0
ORA-00904: "A"."LABOR_HOURS_ITD": invalid identifier
ERROR 0

How is this fixed?
 

Solution

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