COST_ETC_TOTAL in the NBI_PROJECT_CURRENT_FACTS Table is Incorrect

Document ID : KB000100913
Last Modified Date : 12/06/2018
Show Technical Document Details
Issue:
The COST_ETC_TOTAL column in the NBI_PROJECT_CURRENT_FACTS table is incorrect when multiple instances of the same role are assigned to the same task.

Steps to Reproduce:
1. Create a financially enabled project and associate it to a rate matrix 
2. Staff two instances of the same role on the project 
3. Create a task and assign both instances of the role 
4. Add hours of ETC to each role on the task 
5. Run the Time Slicing, Rate Matrix, Update Cost Totals, Investment Allocation and Datamart jobs 
6. Query the NBI_PROJECT_CURRENT_FACTS for this project and check what the amount on the COST_ETC_TOTAL column 

Expected Results: The COST_ETC_TOTAL column in the NBI_PROJECT_CURRENT_FACTS matches the total ETC Cost for the task as per the UI and the PRASSIGNMENT table (sum of the ETCCOST_SUM column for both assignments) 
Actual Results: The COST_ETC_TOTAL column has a bigger amount than expected. Instead of only having the total ETC Cost for both assignments, it has the total ETC Cost of both assignments times two. 
For example, if the ETC Cost for each of the two assignments was $100. The amount in the COST_ETC_TOTAL column in the NBI_PROJECT_CURRENT_FACTS would NOT have the expected total of $200, it would have double this amount, so $400. 

Note: The ETC cost in this table is not always double, if there were three instances of the same role assigned, the COST_ETC_TOTAL column in the NBI_PROJECT_CURRENT_FACTS table would have a total amount 3 times bigger than expected. 
Cause:
Caused by DE41023
Resolution:
DE41023 is expected to be fixed in our upcoming Kenton release (15.5).