About Integrating Financial Analytics with Project Analytics

You can enable Oracle Financial Analytics to use dimension tables in Oracle Project Analytics. You can only perform this integration if you have licensed Oracle Project Analytics.

You can configure the following Oracle Financial Analytics Subject Areas to join to certain Project Dimensions:

  • Financials - Payables (Project, Task, Financial Resource and Expenditure Organization Dimensions)

  • Financials - Receivables (Contract Dim)

The following Oracle Financial Analytics fact tables integrate with Project Analytics dimensions:

  • W_AP_XACT_F

  • W_AR_XACT_F

  • W_AR_AGING_INVOICE_A

To use dimensions from Oracle Project Analytics in Oracle Financial Analytics, you must select the Oracle Project Analytics offering during installation and setup.