Total Hours on Timesheets not Showing Correct Calculations

Article Id: 197307

Status: Published

Updated On: 13-08-2020 13:13

Products:

Clarity PPM SaaS , Clarity PPM On Premise

Issue/Introduction:

After a user enters a total of 30 hours, the timesheet calculates that he has entered a different total of 41.

Cause:

This can occur if the resource has a duplicate team record on one of the investments that they have on their timesheet.

The following query can be used to determine if duplicate team records exist:

SELECT t.prresourceid as prresourceid, t.prprojectid as prprojectid
FROM prteam t, srm_resources s, prj_resources p
WHERE t.prresourceid=s.id AND t.prresourceid=p.prid AND p.prisrole=0
GROUP BY t.prresourceid, t.prprojectid
HAVING COUNT(*)>1

Environment:

Release : 15.7.1

Component : CA PPM SAAS TIME MANAGEMENT

Resolution:

Please contact Broadcom support for assistance with removing the duplicate team records contributing to the unexpected total timesheet hours.