The Jaspersoft Time Management Reports are missing time reporting periods in input fields. They may be missing the current year's time periods, future time periods or all periods. This can impact out-of-the-box (default) and custom reports).
The reports in Advanced Reporting are working and we can generate the reports. However, on the Time Management reports, the 'Time Reporting Period' parameter is missing a list of timesheet periods e.g. "Time Period" input control in the Missing Time Report shows the message: "This field is mandatory so you must enter data" but no time period choices are available.
Make sure Fiscal Time Periods that cover the entire period are created and active. To check this, go to Administration > Finance > Setup > Entity > Fiscal Time Periods > Monthly periods.
In this example:
The From date is 4/1/2016 and the number of periods is 35 ( fiscal period type is monthly). The number of periods that are part of the fiscal Data Warehouse slices decides the number of periods to be inserted into DWH_CMN_PERIOD table, which in turn is what advanced reporting uses to load these fiscal time periods in reports. Three years back and forward for Fiscal slices is what the document recommends and is found as default (73).
If any changes were made based on the above prerequisites, then run the Load Data Warehouse job and the time periods should show the periods. If not, proceed to check the below as well.
NOTE: Check this if no time periods are shown at all.
Prior to doing this, it's recommended to ensure all other causes above have been ruled out.
For additional prerequisites for the Missing Time report, see also: Missing Time on techdocs