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:
- Create 2 projects with identical cost plans
- Add the same actual costs to both projects
- Run a DWH Full Load
- Add a risk to Project 1
- Add an actual cost to Project 2
- Run an incremental load
- 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
Resolution
Fixed in 15.5.1 Patch 2 and 15.6
Feedback
thumb_up
Yes
thumb_down
No