1) For a Cost plan viewed in "Billing Currency View", where can I get the Actual Revenue slice in database. There is a blob and total value in FIN_COST_PLAN_DETAILS but it is not sliced . I checked the ODF_SSL_CST_DFT_AREV table but it is empty. I got the actual cost from PPA_WIP tables but I am unable to get actual revenue.
2) How can I get the rate of a resource working on a project from the rate matrix? The resource has no role on the project neither does he/she have a primary role. I do see that the ACWP is calculated for such resource.
Thanks and Regards,