Error with recompiling invalid objects when upgrading to 15.4

Article Id: 108569

Status: Published

Updated On: 03-08-2018 07:46

Products:

CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM

Issue/Introduction:

Why do we receive compilation errors when trying to recompile invalid objects during an attempt to upgrade PPM?

Errors for FUNCTION COP_SUM_WBS_MATRIX_FCT:

248/88 PL/SQL: ORA-00904: "W"."W"."TRANSNO": invalid identifier
276/45 PL/SQL: SQL Statement ignored

Environment:

Release:
Component: PPMPRD

Resolution:

The problem seems to be using a “double alias” format : “W.W.TRANSNO”. It should be “W.TRANSNO”, but for some reason Oracle 11g version seems to accept the invalid syntax, while 12c version rejects it. When you edit the function using “W.TRANSNO” format, it should complete successfully. Please consult with your DBA to get this accomplished.