View "Apps.PA_STATUS_RSRC_GENERIC_V" has errors in PSI, Resources screen (Doc ID 559026.1)

Last updated on JULY 25, 2024

Applies to:

Symptoms

When trying to see resource information in the Project Status Inquiry screen it gets:

ORA-04063: view "APPS.PA_STATUS_RSRC_GENERIC_V" has errors

Projects Super User > Project Status Enquiry > Put Project Number> Task Status
Button> On pressing the resource status button get the following errors

ORA-04063: view "APPS.PA_STATUS_RSRC_GENERIC_V" has errors

When trying to compile the form the following error appears:

Compiling ON-CHECK-DELETE-MASTER trigger on PROJ_FIELDS data block...
Compilation error on ON-CHECK-DELETE-MASTER trigger on PROJ_FIELDS data block:
PL/SQL ERROR 905 at line 19, column 22
object APPS.PA_STATUS_RSRC_GENERIC_V is invalid
PL/SQL ERROR 0 at line 19, column 5

When trying to recompile the view the following errors appear:

SQL> select name, text from dba_errors where name='PA_STATUS_RSRC_GENERIC_V';

NAME
--------------------------------------------------------------------------------
TEXT
--------------------------------------------------------------------------------
PA_STATUS_RSRC_GENERIC_V
ORA-00904: "RLM"."ALIAS": invalid identifier

Cause

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