Load DWH Job Fails Due To Invalid Object: CRV_SQL_CURVE_PKG

Products

• Clarity PPM On Premise

Issue/Introduction

When compiling invalid object with command: ALTER PACKAGE CRV_SQL_CURVE_PKG COMPILE;

The error returned is:
ORA-00904: : invalid identifier
PLS-00201: identifier 'DBMS_LOB' must be declared 

 

Resolution

1. Have DBA run the following:
GRANT EXECUTE ON dbms_lob to [the niku/clarity database user];

2. Compile the package to show success.

3. Run the Load DWH job.