Skip to main content
Planview Customer Success Center

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