Funding Header Fact
Additional funding metrics that are not available at the funding line level are extracted from the PA_SUMMARY_PROJECT_FUNDINGS table and stored in the Project Funding Header Fact table (W_PROJ_FUNDING_HDR_F).
These header-level metrics include:
-
Unbaselined Amount
-
Baselined Amount
-
Invoiced Amount
-
Revenue Accrued
Before activating the EBS_PROJECTS DA Script application, the following concurrent program must be executed in Oracle E-Business Suite to refresh the summary funding data:
PRC: Refresh Project Summary Amounts
Running this process ensures that the summary funding information is up to date before it is extracted into the analytics warehouse.