DWH enabled curves defined to the financials object are not being synced properly to the DWH by Instant Sync

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

DWH Instantaneous Sync isn't correctly syncing some financial data

Steps to Reproduce:

1. Set up Instant Sync and make sure the SQL Curves system option is enabled.
2. Run the load data warehouse job (full load) to get data set up properly in the Data Warehouse.
3. Create a cost plan in Clarity.
4. Update Some of the detail records for Cost and verify that forecast cost is also updated.
5. Verify that the Instant Sync tried to sync the cost plan updates by checking the dwh_odf_inst_changes_archive table in the DWH.
6. Check the dwh_inv_investment_crv_facts tables for the investment that had the cost plans and check the crv_fcst_cost curve to see if it matches what's in Clarity.

Expected Results: The curve sums match.

Actual Results: The curve in the dwh_inv_investment_crv_facts table has not been updated.

Environment

Clarity 16.4.1

Cause

DE185572

Resolution

The resolution for this is included in 16.4.2.