The ETC Cost figures do not get recalculated when ETC becomes 0

Products

• Clarity PPM On Premise

Issue/Introduction

Steps To Reproduce:
1.Create a rate matrix with a catch all row at a rate of 10USD
2.Run the datamart jobs
3.Run the Rate matrix extraction job. If a rate matrix exists, the above might be skipped
4.Create a project and financially enable it
5.Add a team member, create a task and assign it to the task
6.Ensure there is some ETC at assignment level, let say 8 hours
7.Rerun the rate matrix job if necessary again
8.Add the ETC Cost to the assignment view
9.ETC is 8 hours, ETC Cost is 80 USD
10.At assignment level, edit the ETC and change it to 4
11.Go back to the task and run the Update Cost Totals action
12.At assignment level ETC shows 4 hours, ETC Cost is recalculated to 40 USD
13.At assignment level, edit the ETC and change it to 0
14.Go back to the task and run the Update Cost Totals action

Expected Result: At assignment level ETC is 0 hours, ETC Cost is 0 USD

Actual Result: At assignment level ETC is hours, ETC Cost is 40 USD

Environment

CA PPM 14.2, 14.3, 14.4

Cause

This is caused by CLRT-80294

Resolution

This is fixed within 14.3.0.8, 14.4.0.3 and 15.1

Additional Information

How is ETC Cost calculated? What is the formula?

ETC hours x Rate on the matrix

Clarity uses the rates from the matrix and populated at the NBI_PROJ_RES_RATES_AND_COSTS table