We have been receiving at least 6 of these messages since January 1st, 2021, and it looks like the scheduled jobs for "Job Datamart Roll - Time Facts and Time Summary" have failed to run in production. Please help us to fix the issue.
Error message: ERROR: Error in CMN_JOB_DATAMART_ROLLUP_SP - Error in NBI_EXTRACT_TF_TS_SP - :Determine current fiscal period: query returned no rows
Release : 15.9
Component : CA PPM SAAS DATAMART
1. Navigate to Administration -> Finance -> Setup -> entities -> Your Entity -> Fiscal Time Periods and set-up the time periods for 2021 and Active.
2. Run Datamart Extraction with no parameters checked.
3. Run Datamart Rollup - Time Facts and Time Summary