Costs do not calculate if Matrix currency is different than project currency

book

Article ID: 207274

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

When the currency on the matrix row (ppa_matrixvalues) is something other than the currency identified for the project's entity the Allocation Cost as well as ETC cost and ACWP do not calculate when the Full Rate Matrix Extraction job is run

(Options 1,2,3 or 2,3)

Cause

Reported as DE59570

It appears when the Rate Matrix Extraction job is run, if the currency for the matrix row is different than the project currency the rows may not populate in the corresponding table.

Environment

Release : 15.6.1

Component : CA PPM SAAS FINANCIAL MANAGEMENT

Resolution

Workaround:

Run the rate matrix extraction job in this order

1) Run it with only option 2 selected ( Prepare Rate Matrix Data )

2) Run it with only option 3 selected  ( Update Rate Matrix Data )

 

This should populate the rows correctly and calculate the rates correctly.

 

Running the full Rate Matrix Extraction job will not remove the rows once they show.

Additional Information

What does the Rate Matrix Extraction job do and how is it used?

https://knowledge.broadcom.com/external/article/25696/clarity-ppm-what-does-the-rate-matrix-ex.html

 

 

Rate Matrix Configuration

https://knowledge.broadcom.com/external/article/4679/rate-matrix-configuration.html