AnsweredAssumed Answered

CA PPM 15.2 Data Warehouse Options Error

Question asked by ykrao on Aug 2, 2017
Latest reply on Aug 7, 2017 by ykrao

Hi all,

 

We have installed CA PPM 15.2 Patch 01( Version: 15.2.0.213 01 39). When we set the Entity for Fiscal Periods of Data Warehouse Option in System Option, we received the error: System error. Contact system administrator.

Error in logfile:
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04063: package body "NIKU_IDA.CRV_SQL_CURVE_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "NIKU_IDA.CRV_SQL_CURVE_PKG"

We found that the TYPE CRV_PREIOD and CRV_SLICE are being used with one additional column group_by and these type definiations don't have that column.

Package compilation the error:

Error(910,32): PLS-00306: wrong number or types of arguments in call to 'CRV_PERIOD'
Line 910 in CRV_SQL_CURVE_PKG
 v_calendar(idx) := CRV_PERIOD( v_period, v_start, v_temp_date, DATE_TO_JULIAN( v_start ), DATE_TO_JULIAN( v_temp_date ), v_period_type, v_calendar_key, v_conversion, v_group_by );
 
If we see the CRV_PERIOD definition, it doesn't have group by column
CREATE OR REPLACE TYPE "CRV_PERIOD" FORCE
AS
  OBJECT
  (
    PERIOD NUMBER,
    START_DATE DATE,
    FINISH_DATE DATE,
    JULIAN_START   INTEGER,
    JULIAN_FINISH  INTEGER,
    PERIOD_NAME    VARCHAR2(32),
    CALENDAR_KEY   VARCHAR(20) NULL,
    FTE_CONVERSION NUMBER );

 

Thanks

Giri

Outcomes