I recently encountered a problem with one of our projects, specifically with the cost plan, calculations of planned cost.
When i run the following query i get inconsistent results that have nothing to do with the actual data that is showed in Clarity.
select * from odf_ssl_cst_dtl_cost where prj_object_id in (select id from fin_cost_plan_details where plan_id=???)
I doubled checked the plan_id from the url, and it seems all checks out but the values presented have nothing to do with the values displayed in the cost plan.
This issue only occurs for some of our projects, the rest of them return consistent values.
I tried to recalculate the time slices but no change there, also can you tell me what time slices i should calculate for this? or it has nothing to do with time slices? .
I ran this ones:
Is there something i am forgetting or this is a much deeper issue that requires a ticket?
Anyone have an idea of what is happening here?
CA PPM 14.3
SQL Server 2012 Enterprise
Try running this query to see the if the slices are up to date. You might want to modify the query to include only one project which you think is out of sync.
select systimestamp as current_time , det.id, det.total_cost, det.odf_ss_cost, slc.start_date, cast(slc.created_date as TIMESTAMP), slc.slice, last_updated_datefrom fin_cost_plan_details det left join odf_ssl_cst_dtl_cost slc on det.id = slc.prj_object_id where last_updated_date > sysdate - 0.1
Let me know the results.
The query did not return any records . What particular slice has the financial data? maybe if i try to recalculate it...
Hi Jerin_Sebastian - Any further input for TiagoAb? Thanks!
Hi TiagoAb - Did Jerin_Sebastian's response help answer your question? If so please mark as Correct Answer. Thanks!
Check out TEC440146 : Can you provide more details regarding the Financial Planning Slice Tables?