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.
There are open timesheet periods in the system in Administration > Project Management > Time Reporting Periods.
Steps to Reproduce:
- Execute 'Load Data Warehouse' (Load DWH) job with 'Full Load' option
- Navigate to Advanced Reporting, View List of Reports
- Select one of the Time Management Reports, such as 'Missing Time' or 'Time Compliance'
- Look for the Time Reporting Period parameter ; it is a required input control parameter
Expected Result: To see a list of available open time reporting periods
Actual Result: The list of available periods is empty; the user cannot select any value for this required parameter
A. PMOJSFT-284: Advanced Reporting Time Period input control does not display any results if no Time Reporting periods exist in future
This is resolved in 14.4.0.
B. The Time Reporting Period records may not have a 'last_updated_date' value that is recognized by the Load DWH job. This can be remedied by updating the periods through the application.
C. The Administration > Finance > Setup > Entity > Fiscal Time Periods > Monthly periods have not been created and/or active.
D. The Time Reporting Period Browse Lookup may not have been upgraded. Check for 'Upgrade Ready' status on the 'Portlet Timesheet Period Browse' Lookup in the PMO Accelerator Content Add-In items and install this lookup along with other items ready for upgrade.
-Go to Administration > General Settings > System Options > Data Warehouse Options
1.Unset the field: Entity for Fiscal Time Periods
Reset the field and Click Save.
2. Run the following jobs in the following order:
a. Time Slicing job
b. Update Report Tables job
c. Load DWH job (full)
d. Load DWH Access Rights job