OBIA - Is there Support for Project Dimension for W_AP_AGING_INVOICE_A?

(Doc ID 1666428.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


Does Oracle support project dimension for W_AP_AGING_INVOICE_A?

Is it possible to join AP Aging Fact Table  To Project Dimension?

1. The following AP Aging Fact table doesn't have Repository (RPD) joins to project dimension W_PROJECT_D



Can we extend these AP Aging fact table to join to Project Dimension?

2. There are AP invoices of two types

  a. One AP Invoice per project (AP_INVOICES_ALL.PROJECT_ID)
  b. One invoice with Many projects (AP_INVOICE_DISTRIBUTIONS_ALL.PROJECT_ID)

Considering the above data, what changes need to be performed on AP Invoice Aging fact table to add project Dimension to W_AP_AGING_INVOICE_A, W_AP_AGING_INVOICE__ENT_A ?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms