Update Cost Totals is Not Working as Expected After Upgrade of PPM

Document ID : KB000097846
Last Modified Date : 12/09/2018
Show Technical Document Details
Issue:
Update Cost Totals is not working as expected in PPM 15.2 (and higher) as compared to lower versions (such as  PPM 14.3). In the earlier versions, when we assigned a resource/role to a task and then clicked on 'Update Cost Totals' on the Actions drop down menu, the ETC Cost would update as expected. In PPM 14.3, we also noticed that the NBI_PROJ_RES_RATES_AND_COSTS table was updated as soon as the resource/role was assigned to the task.

Now in the upgraded version, the same steps do not update the ETC Cost or the NBI_PROJ_RES_RATES_AND_COSTS table. 

Steps to Reproduce:
  1. Add a role to the Team tab of a project (Make sure the Role has an entry in the Rate Matrix)
  2. Assign the role to a task on the project (Ensure there is ETC assigned to the role)
  3. Run the update cost total job
Expected Result: The ETC Cost and EAC (T) fields on the Task and Assignment are updated reflecting the ETC for that resource/role
Actual Result: The ETC Cost is unchanged (zero for new assignment)

Were there any change to this process? 
Environment:
CA PPM 15.2 and later releases
Resolution:
Starting on PPM 15.2, the on-the-fly Rate Matrix setting is disabled by default. This means that any upgrade to either PPM 15.2 or later will disable this setting. This was done to help/prevent a defect that was reported on the PPM 15.1 release where this setting being enabled would cause performance with the Post Timesheet job, especially when processing a large number of timesheets (DE31729 : Post Timesheets slow due to on-the-fly.). Here are the 2 options that can be used to work around this change:

Option 1: Schedule the Rate Matrix Extraction job to run in incremental mode

It should be run prior to the Post Timesheets job and also run frequently throughout the day (recommended at least every hour if possible) 

Option 2: Enable On-the-fly RateMatrix 

IMPORTANT: Impact of enabling this setting:

This setting can made in PPM by using the below steps:

  1. Log in to PPM as an Administrator and Click on the Administration menu
  2. Under Security and Diagnostics click on the Health Report Link
  3. Go to the Application tab
  4. Under General->On-the-fly RateMatrix click on the 'Enable' link on the Status column (The value for the On-the-fly option should then switch immediately to Enabled)
Additional Information:
For additional details regarding DE31729, see KB000005886.
See KB000025696 for details on what the Rate Matrix Extraction job does and how is it used