After removing some custom attributes from Project object, we have noticed that some portlets that retrieve data from the view 'ODF_PROJECT_V2' display error 500 messages and no data is shown.
Release : 15.8.1
Component : CA PPM APPLICATION
A glitch occurred during the deletion of the custom attributes from Project object in the user interface.
The data got removed from 'ODF_CA_PROJECT' table but the deletion did not cascade to the 'ODF_PROJECT_V2' view level and so there was reference to an invalid column.
Executed the following Sql statement.
SQL> show errors view ODF_PROJECT_V2;
Errors for VIEW ODF_PROJECT_V2:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00904: "ODF_CA_PROJECT"."AAAA_IA_OAO_RT": invalid identifier
select table_name, owner, status from dba_tab_cols where table_name='ODF_CA_PROJECT' and column_name='AAAA_IA_OAO_RT';
SQL> select table_name, owner from dba_tab_cols where table_name='ODF_CA_PROJECT' and column_name='AAAA_IA_OAO_RT' and owner='UK25';
no rows selected
The view 'ODF_PROJECT_V2' seems to be trying to access the column AAAA_IA_OAO_RT on the table ODF_CA_PROJECT that is not present
To resolve the issue, DBA should remove invalid references to the column 'AAAA_IA_OAO_RT' from the view 'ODF_PROJECT_V2' and the recomplie it.