DWH Table dwh_fin_plan_ln null grouping attributes

Products

• Clarity PPM SaaS

Issue/Introduction

SUMMARY:  If a cost plan is created or periods updated while the incremental Load Data Warehouse job is running, the table DWH_FIN_PLAN_LN gets inserted a record with the correct grouping attributes as well as one with null grouping attributes.

STR:

Make sure on your System Options that you are not only including the Plan of Record

1)  In MUX create a cost plan.

     For these STR it was on a project.

      - Grouping attributes: Cost Type, Transaction Class (though it does not matter)

       - Dates 12/2022 - 05/2024

 

2)  Add 3 lines to your plan and add some costs

 

3)   Run the Incremental Load Data Warehouse job  - be ready to copy your cost plan while the job is running

 

4) Once the job starts copy your cost plan several times as the job is running

        - Copy from the plan you just created

        - Right click on the plan and use the copy option

         - You will need to give the new plan an ID

   

          - Keep creating plans by copying or edit existing plans

   

Expected Results:  Once the job completes the table dwh_fin_plan_ln will not have any rows with null grouping attributes

 

Actual Results:  The table contains rows with null grouping attributes as well as a completed record for the same plan_detail_key

                         Note that the records may not appear until the next incremental job is run

 

Workaround:  Only run the Full Data Warehouse job

Cause

Reported as DE79807

Resolution

DE79807 resolved in 16.2.2