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.
Release : 15.6
Component : CA PPM PORTFOLIO MANAGEMENT
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
create table inv_time_wip as
select pm.id investmentid,
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.
select * from inv_time_wip where timeentry is not null and wip is not null