Benefit Variance calculation in DWH differs from that in Transactional DB

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

1. Create a Project. Associate it with a Department and Location
2. Go to Financials tab in the Modern UX. Create a Cost Plan. Populate the Cost Plan with some Cost
3. Go to Benefit Plans tab. Create a Benefit Plan. Navigate back to Cost Plans. Associate this newly created Benefit Plan with the Cost Plan from Step 2
4. Go back to the Benefit Plan. Enter some Benefit in the detailed view. Display the 'Variance' column. Note down the numbers mentioned here
5. Run the 'Load Data Warehouse' job to get these numbers into the DWH
6. Check on the numbers loaded into DWH using the query mentioned below. Note down the Variance numbers again.

Expected Results: Variance is same in steps 4 and 6.

Actual Results: Variance is not the same in steps 4 and 6.

Cause

DE174749

Resolution

DE174749 is fixed in 16.4.0.