Error with recompiling invalid objects when upgrading to 15.4

Document ID : KB000108569
Last Modified Date : 03/08/2018
Show Technical Document Details
Question:
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
Answer:
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.