Cost Plan data in Jaspersoft reports and Ad Hoc views do not get populated correctly
Following are the steps to reproduce this issue:
round(slice.slice * extract(day from (slice.finish_date - slice.start_date))::integer, 2) forecast_cost
join fin_cost_plan_details fcpd on
fcpd.plan_id = fp.id
join odf_ssl_cst_dtl_cost slice on
slice.prj_object_id = fcpd.id
join inv_investments ii on
ii.id = fp.object_id
ii.code = 'PR2000';
7. Run Load Data Warehouse job (Full Load)
8. Check the values that have been transferred over to the DWH using the following query (replace Project ID):
round(fpd.plan_cost, 2) forecast_cost
join dwh_fin_plan fp on
fp.plan_key = fpd.plan_key
join dwh_inv_investment ii on
ii.investment_key = fp.investment_key
join dwh_cmn_period dcp on
dcp.period_key = fpd.period_key
ii.investment_id = 'PR2000';
Expected Results: The values returned in step 6 and step 8 are same
Actual Results: The values returned in step 8 do not match with that in step 6. DWH has reduced values against certain months.
Due to defect DE60921.
Versions tested against: 15.9.2, 15.9.1, 15.8.1
The defect is under review by Product Management.
As a workaround, untick the checkbox for "Consistent Fiscal Periods across Entities" in the Clarity => Administration => General Settings => System Options page.
This will cause Jaspersoft reports and Ad Hoc views to render incorrect Cost plan data
Reference also: Load DWH job frequently reported issues