Clarity report generated does not match with posted timesheet values

[DL_L2_Clarity_Support]

Hi,
We are using Clarity PPM v12.1 project management tool.
For generating resource report when we run populate resource allocation report we found some mismatch between the posted timesheets and actuals value in generated report.
We check all the jobs are running fine and data is getting feed correctly to system but some resource the actuals value are not available in generated report while the timesheet values are shown as posted for the resources.
Could any one please help us to resolve the issue?

Thanks,
Bharat

[Suman Pramanik]

There could be two approach I can think of 

 

1. Check the tables to see if the data is there and report not showing up, then report logic needs to be looked.

2. If the data is not there in underlying tables then it could be mismatch between PRASSIGNMENT.practsum and PPA_WIP.

 

Try the below steps to see if you can get through 

 

1. Admin > finance > manage matrix > set the prior rate
2. Run the full Rate Matrix Extraction job.
3. Adjust the timesheet/transaction down to 0 hours.
4. Admin > finance > manage matrix > set the correct rate.
5. run the full Rate Matrix Extraction job. .
6. Adjust the timesheet/transaction to positive, non-zero hours
7. Run the Post Timesheets (PT) job.

 

Let me know how it goes 

 

Regards

Suman Pramanik 

[David Morton]

^ yep as above, but also check the time slicing setup/job - if this not running correctly there can be an obvious mismatch between the timesheet PRACTSUM and the sum of the actuals from the actuals slice (and/or from the timeentry slice)

 

( obviously to investigate a perceived "discrepancy" we need to know what values we are looking at  and where the values are generated from - the vague notion of a "discrepancy" doesn't give many clues!  ) 

[DL_L2_Clarity_Support]

Hi Suman,

Thanks for your reply.

Only for some resources the time sheet data shows as posted but while we try to generate report,the report generated does not contain those few resources while we checked the properties for the resources those are not appearing in report are similar as of properties of  the resources appearing in the report.

Could you please suggest any reference table name to check whether any data getting stuck at any table?

Please let me know in case you need any more information on this.

Thanks,

Bharat

[Suman Pramanik]

Timesheet data goes to PRSTIMESHEET joins with PRTIMEPERIOD, PRTASK, PRASSIGNMENT, PPA_WIP

[DL_L2_Clarity_Support]

Thanks you so much Suman for your help.

Could you help me to figure out the issue with Monthly and Weekly timesheet  data mismatch?

The data generated with monthly and weekly properties value are not matching.

Again thanks a lot in advance.....

[goosr02]

Hi Bharat,

 

If Time Slicing job was interrupted at some point we might see some data miss. Please go through the below technical article to see if that helps:

CA PPM: How to Reslice Time Slice IDs 

 

Regards,

Srikanth G