Accelerator report "Task assignment effort summary by project and fiscal period" does not return any values
Symptoms
Accelerator report "Task assignment effort summary by project and fiscal period" does not return any values
Reason
This report requires the following financial analysis record types to be enabled in the database, which allows the Financial Analysis Summary job to populate relevant data when it runs.
select * from finannrectype (nolock) where finannrectype in ('28','42','38','33','34','35','29','43','30','49','31','44' )
Resolution
1- Enable the required record types in finannrectype table (e.g. find the row where FinAnnRecType=28 and set Enabled to 1).
2- Execute the job Changepoint_Financial Analysis Summary