Error with recompiling invalid objects when upgrading to 15.4

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• 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

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.