Project Revenue Fact

Actual project revenue transactions are extracted from the following Oracle E-Business Suite tables:

• PA_CUST_REV_DISTRIB_LINES_ALL

• PA_CUST_EVENT_DIST_ALL

These records are loaded into the Project Revenue Line Fact table (W_PROJ_REVENUE_LINE_F).

For the Oracle E-Business Suite source systems, the Revenue Transaction Currency Code corresponds to the Document Currency Code of the source transaction.