Here is another issue I recently hit with a customer and would like to share the solution with all of you.
When running Load Data Warehouse job, an error is thrown:
Financial plans has invalid start or end periods.
Orphans Cost plans exist with no fiscal periods on them.
As a fix for CLRT-78721, a Data Integrity Check for FIN_PLANS START_PERIOD_ID and END_PERIOD_ID was added in Data Warehouse.
Seeing that error message means that you failed the check and orphans exist.
select f.id, f.name as cost_plan, f.code, f.object_code, f.plan_type_code, f.start_period_id, f.end_period_id,i.code project_code, i.is_active, i.name Project_name
from fin_plans f, inv_investments i where i.id =f.object_id and (f.start_period_id NOT IN (select id from biz_com_periods) or end_period_id NOT IN (select id from biz_com_periods))
order by Project_name
Save the results in an Excel sheet with headers.
set start_period_id = (select min(id) from biz_com_periods), end_period_id =(select min(id) from biz_com_periods)
where start_period_id NOT IN (select id from biz_com_periods)
or end_period_id NOT IN (select id from biz_com_periods)
It should complete successfully.
Hope this helps -Nika
Should be published soon as https://support.ca.com/us/knowledge-base-articles.TEC1565201.html as well.