AnsweredAssumed Answered

Budget Financial Plans Details

Question asked by RafaLarios on Jun 21, 2010
Latest reply on Jun 25, 2010 by DevK
Hi Everyone!!!

I've been trying to do a portlet that brings me the information of the planed budget cost (total cost, cost to date and actuals) for every project. It would look like this
PROJECT    TOTAL PLANED COST    PLANED COST TO DATE    ACTUAL COST
-------    -----------------    --------------------    ----------
Project 1       100.000                 50.000            45.000
Project 2       200.000                 70.000            60.000
It seemed Quite simple because it should be a simple query on the details of the financial plans. However I've stumbled with a roadblock :(

I know that this budget information is on the tables:
 fin_cost_plan_details
 fin_plans
 ppa_wip
I can extract the total planed cost and its actuals, however, the problem lies with the planed cost to date. The detailed cost for a budget plan is on the [color=#FD0303]cost[color] column on the [color=#FF0000]fin_cost_plan_details[color] table. The problem with this table is that it holds a record for every transclass, but the cost column contains all the sliced information on a binary format.

Is there a way to extract (with a SQL query in order to use it with a portlet) the sliced information in a readable format in order to query it?. I knew that on previous versions, there was a table called pac_frc_forecast_values wich holded this detailed info, but this table is deprecated on Clarity v12.

Thanks for your support, kind regards

Rafa Larios

Outcomes