This scheduled job failed. Datamart Rollup - Time Facts and Time Summary
Job: Datamart Rollup - Time Facts and Time Summary
Run ID: 7128854
Failed - Message: java.sql.SQLException: [CA PPM][Oracle JDBCDriver][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 "CAPPMDB.CMN_JOB_DATAMART_ROLLUP_SP", line 11
ORA-06512: at line 1
This error message indicates that there is no active, monthly fiscal time period defined for the current month.
The Datamart jobs require active, monthly Fiscal Time Periods defined for the Entity that is configured on the Datamart Settings page. The configuration of Fiscal Time Periods must include the current month. It is a 'best practices' recommendation to define active, monthly periods up to 6 months into the future so that the Administrator does not have to remember to create these periods each month.
Once confirmed the fiscal periods are set up and active run the Datamart Extraction job and the the Datamart Rollup job.
The Datamart Extraction job needs to run first in order to populate the tables needed for the Rollup job.
For details on steps to configure the Fiscal Periods:
Reference TEC497531 : Datamart Extraction Job Failed - NBI_CFG_NO_FISCAL_PERIOD - No fiscal periods have been set up