AnsweredAssumed Answered

ERROR Job: Datamart Rollup - Time Facts and Time Summary

Question asked by gaetano.diluca.1 on Jan 3, 2014
Latest reply on Jul 1, 2015 by Jerin_Sebastian

Hello EveryOne,

I have started the new year with the follow error in my clarity 13.1:

Job: Datamart Rollup - Time Facts and Time Summary 
Stored Procedure application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in CMN_JOB_DATAMART_ROLLUP_SP - ORA-20000: Error in NBI_EXTRACT_TF_TS_SP - Determine current fiscal period: ORA-01403: no data found
ORA-06512: at line 1


Reading the old messagges I found that the problem can be located in Fiscal Time Periods missing, so I checked in the Administration --> Setup --> Entity --> Fiscal Time Periods but the Fiscal Time Periods are present ( but are NOT active). How I can active-it? Can be this the problem?