OBIA 188.8.131.52.1 - Is there Support for Project Dimension for W_AP_AGING_INVOICE_A?
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 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