CA PPM: Why Are Rates Wrong/incorrect on My Project?

Document ID : KB000010748
Last Modified Date : 14/02/2018
Show Technical Document Details

Time entered on projects are entered either from timesheets, manual transactions, and XOG.
Time actuals/units have to be associated with a rate in order to calculate actual cost, which is displayed in portlets or reports.

The rates appear to be incorrect when reviewed and raises several questions:
1. What are the proper steps to ensure the correct rate is associated with the project?
2. What if the incorrect rate has already posted?




CA PPM provides historic, live, and snapshot rates.

a. The historic rate can be derived from PPA_WIP/PPA_WIP_VALUE tables, i.e. all the posting jobs (Post Timesheets, Post Transactions to Financials, Post to WIP) will need to be ran.

b. The live rates are in PPA_MATRIX/PPA_MATRIX_VALUES. The cost plan planned cost gets the rate from these tables.

c. The snapshot rates are obtained from the NBI_PROJ_RES_RATES_AND_COSTS table.
This is why it is extremely important that the full Rate Matrix Extraction (RME) job runs and completes prior to the Post Timesheets job.
When the Post Timesheets job is ran to post the actuals from timesheets, the rates are not obtained from PPA_MATRIX/PPA_MATRIX_VALUES.
It is instead retrieved from the NBI_PROJ_RES_RATES_AND_COSTS, which is updated when the full Rate Matrix Extraction job is ran.


Actuals are viewed from a planned(actuals/cost) versus realized(WIP actuals/cost).

1. What steps are needed to ensure the correct rate is associated with the project?

a. Create a rate matrix.


b. Associate the rate matrix to a project for each labor type.

When the entity-level matrix, no matrix, or incorrect matrix is associated with an investment, it will yield unexpected rates and costs.
Make sure the correct rate matrix is used.

2. View the planned and actual costs by creating a cost plan from either (Team Allocation/Investment Team or Task Assignments)

The rates are obtained directly from the live matrix in Administration > Finance > Manage Matrix (PPA_MATRIX)


For planned actuals/cost, use the Project > Financial Plans > Cost Plan > Populate the detailed cost plan from Team Allocation/Investment Team
For realized(WIP actuals/cost), use Project > Financial Plans > Cost Plan > Populate the detailed cost plan from Task Assignments

Both methods will always show the planned units and cost and actual units and cost from WIP from matching grouping attributes.

Additional Information:

Frequently Asked Questions:

Q. How can the financially-posted transactions be viewed to reveal the rates and costs?

Use the Home > Financial Management > Posted Transactions Review portlet for viewing the realized/posted rates and actual costs.
Again, it is critical that the following jobs be ran in the following sequential order:
-Rate Matrix Extraction(full)
-Post Timesheets
-Post Transactions to Financials
-Post to WIP

Q. What if the incorrect rate has already posted?

To adjust a timesheet, the timesheet needs to be changed in order for the Post Timesheets job to process the adjustment.

To adjust a manual transaction, create and approve the WIP adjustment
a. Home > Financial Management > Create WIP Adjustment
-Set 'Quantity' to be the desired number of hours (never a negative quantity)
-Set 'Cost' to be the desired actual cost rate (never a negative rate)
-Checkmark 'Calculate New Rates'
b. Approve the adjustment via Home > Financial Management > Approve WIP Adjustment

Q. What if we have questions on how to properly adjust/correct a transaction?

Proceed to open a case to get the problem reviewed.
Based on the scenario, it may require an approved utility to synchronize the project actuals vs the WIP actuals.