OBIA 11.1.1.7.1 - 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 11.1.1.7.1 and later
Information in this document applies to any platform.

Goal

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

W_AP_AGING_INVOICE_A
W_AP_AGING_INVOICE_ENT_A

W_AP_AGING_SUPPLIER_A
W_AP_AGING_SUPPLIER_ENT_A

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 ?
 
 

Solution

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