Clarity PPM: Timesheets are missing from the Timesheet Extract

Products

• Clarity PPM SaaS

Issue/Introduction

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. 

Cause

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.

Resolution

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