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.
DE154713
DE154713 is under review.