search cancel

Clarity PPM: Timesheets are missing from the Timesheet Extract


Article ID: 213115


Updated On:


Clarity PPM SaaS


This issue is around a custom Timesheet extract portlet. 

When the extract is pulled on the first day of the Fiscal Period, it shows the result of the previous fiscal periods as well. 


The fiscal time periods are stored in BIZ_COM_PERIODS table. 

The condition in the query was to check for >= and also INTERVAL '1' DAY. This was satisfying the condition for the previous day as well and hence pulling data from the previous fiscal period.


The conditions in the custom portlet query was changed to consider only the current day and time and not the previous day.