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
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.