Annual Plans Actual costs and units missing from dwh_fin_plan_period_facts and dwh_x_plan_act_per_facts_v after upgrade to 16.2.1

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrade to 16.2.1 the actual costs and actual units are missing from dwh_fin_plan_period_facts and dwh_x_plan_act_per_facts_v for any financial plans that have period type of Annual.

STR:

1.  Make sure there are actual WIP costs for the project

2.  Use an existing cost/budget plan that has period type = Annual or create a new Annual Plan
      - Make this the plan of record if it is a cost plan and you are only including the Plan of Record in DWH

3.  Run full load of Data Warehouse

4. Query the DWH table for your plan_key/investment key
       select * from dwh_fin_plan_period_facts where plan_key = (your plan key)  

5. View the actual costs/actual units fields for your plan where there should be actual costs/units

     Another option is to create an ad-hoc view from the Financial Management Domain using the same criteria

 

Expected Results: The actual costs and actual units have a value in the table

 

Actual Results: The actual costs and actual units show as 0 for the Annual Type Plans.

 

Workaround:  None for annual plans

Cause

Reported as DE80384

Resolution

The resolution for this issue is included in 16.2.3 and 16.2.2.1 (Patch 1).