I am looking for info like which resource has generated how much cost in by cost plan. Lets consider, I have 5 resources with different rate, in total for the month of Jan 2018 cost is 5000$, now I wanted to know how much cost resource 1, Resource 2 and so on has generated. project select * from fin_plans where 1=1 and object_id=6302410 ; select * from fin_cost_plan_details where plan_id=6027027; When I ran "select * from fin_cost_plan_details where plan_id=6027027;", seeing resource_ID as blank, in which Table will I get this info.
That information is not available in any other PPM OLTP or DWH DB table than FIN_COST_PLAN_DETAILS.
The only way you can get the cost by ResourceID information is by grouping a cost plan by Resource- then the Resource ID data will be updated in the FIN_COST_PLAN_DETAILS table.