Incorrect team allocation start and finish dates in DWH

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Data Warehouse Incremental Load is pushing wrong values into the START_DATE and FINISH_DATE columns of the DWH_INV_TEAM table. As a result, a mismatch arises between Team Allocation Start and Finish dates shown in Clarity, and those shown in DWH / Advanced Reporting / Reports.

STEPS TO REPRODUCE: 

1. Login to Clarity.
2. Run DWH Full Load.
3. Navigate to Home -> Projects -> Team. Modify the start & finish dates for few team records.
4. Run the DWH incremental Load. 
5. Validate DWH_INV_TEAM table on DWH schema and you can find that the Start and Finish dates reflect the values in UI.
6. Navigate to the same project used in step 3 and update any other DWH enabled attribute of the project. Ex :- decription field.
7. Run the DWH incremental Load. 

 

Expected Results: DWH_INV_TEAM table shows the actual start & finish dates of Team records. 

 

Actual Results: DWH_INV_TEAM table shows the start and finish dates of the investment. 

 

Environment

Release : 15.9.2, 15.9.3, 16.0.0, 16.0.1 

Cause

DE63242 

Resolution

Resolved in 16.0.2