AnsweredAssumed Answered

Actual Revenue in database

Question asked by Rajini on Aug 1, 2014
Latest reply on Aug 4, 2014 by Kathryn_Ellis

Hello All,


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,