Load Data Warehouse Job Fails With Error ORA-04063

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

The following error appears in the bg-dwh.log

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: package body "NIKU.CRV_SQL_CURVE_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "NIKU.CRV_SQL_CURVE_PKG"
ORA-06512: at "NIKU.CRV_CALENDAR_FCT", line 7
ORA-06512: at line 1
ORA-06512: at "NIKU.RPT_CALENDAR_SP", line 85
ORA-06512: at line 2

Environment

All

Resolution

Have DBA team run the following command:

ALTER PACKAGE CRV_SQL_CURVE_PKG COMPILE;