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

Last updated on JUNE 13, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms