My Oracle Support Banner

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

Last updated on DECEMBER 10, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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