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.