Adjusted hours are not moving to WIP

book

Article ID: 182943

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When a resource in adjusting Timesheet and removing the hours entered on project A and charging hours on project B, we see that the negative hours i.e. the hours removed on project A are not moving to WIP in few cases. The hours changed on new project B are moving but the hours removed from project A are not showing up in WIP. Please help us correct these hours and to identify all the records with this kind of problem.

Environment

Release : 15.6

Component : CA PPM PORTFOLIO MANAGEMENT

Resolution

Below are the queries you can run to identify impacted entries.

Note: You can just run the select part without the create table part to see the differences. However this has no dates around it.

Please reach out to Broadcom support for assistance in fixing those impacted

Query 1:
create table inv_time_wip as
select pm.id investmentid,

(select sum(e.practsum/3600)
from prtimesheet pt, prtimeentry e, prassignment a, prtask t
where e.prassignmentid = a.prid
and a.prtaskid = t.prid and t.prprojectid = pm.id
and pt.prid = e.prtimesheetid and pt.prstatus = 4 and e.prrmexported = 1) timeentry,

(select sum(quantity) from ppa_wip where investment_id = pm.id and sourcemodule = 51) wip

from pac_mnt_projects pm, inv_investments inv where pm.departcode is not null and inv.id = pm.id
and pm.status = 'O' and inv.track_mode = 2 and inv.is_open_for_te = 1;


-- Not needing the ones where both timeentry and wip values are null.

Query 2:

select * from inv_time_wip where timeentry is not null and wip is not null