Error with recompiling invalid objects when upgrading to 15.4

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

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

Note: This error can also occur after migrating from release 11 to release 12 without going via an upgrade

Environment

Release:
Component: 

Resolution

• The problem seems to be using a “double alias” format : “W.W.TRANSNO”.
• It should be “W.TRANSNO”. Oracle 11g version seems to accept the invalid syntax, while 12c version rejects it.
• Edit the function using “W.TRANSNO” instead and recompile
• Please consult with your DBA to get this accomplished