ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Clarity PPM: Timesheets are missing from the Timesheet Extract

book

Article ID: 213115

calendar_today

Updated On:

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.