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

Document ID : KB000022068
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

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

Cause:

This error message indicates that there is no active, monthly fiscal time period defined for the current month.

Resolution:

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.

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