DWH - Forecast Cost is incorrect in Oracle DB based systems
search cancel

DWH - Forecast Cost is incorrect in Oracle DB based systems

book

Article ID: 379093

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Steps to Reproduce:
    1. Create a new project in the Modern UX
    2. Associate it with a Department and Location
    3. Create a new cost plan
    4. Create a detailed cost plan row within it
    5. Populate '1000' against all months of 2024
    6. From 2024-01 to 2024-09, 'Forecast' will show as 0 (As of 1st of October, 2024)
    7. From 2024-10 to 2024-12, 'Forecast' shows as 1000, in the Modern UX
    8. In the DWH however, from 2024-10, the fcst_cost and fcst_plan_cost against dwh_fin_plan_period_facts is incorrect.

    Expected Result: Forecast Cost loaded in DWH is as in step 7
    Actual Result: Forecast Cost is incorrectly loaded, in Oracle DB based systems.

Cause

DE154713

Resolution

DE154713 is fixed in 16.3.1.