Budget/Cost plan records missing in Data Warehouse (in DWH_FIN_PLAN_PERIOD_FACTS and other tables)
search cancel

Budget/Cost plan records missing in Data Warehouse (in DWH_FIN_PLAN_PERIOD_FACTS and other tables)

book

Article ID: 136321

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Steps to Reproduce:

  1. Create 2 projects with identical cost plans
  2. Add the same actual costs to both projects
  3. Run a DWH Full Load
  4. Add a risk to Project 1 
  5. Add an actual cost to Project 2
  6. Run an incremental load
  7. Look at the table dwh_x_inv_sum_facts, Project 1 will have 0 actual costs and Project 2 will be correct

This will also affect other tables

Cause

Caused by DE46688 

Resolution

Fixed in 15.5.1 Patch 2 and 15.6