Datamart Rollup Job Failed - Determine current fiscal period no data found

Document ID : KB000022068
Last Modified Date : 02/01/2019
Show Technical Document Details


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 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.

Additional Information:

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


Please Update This Required Field