How can we include Account Information within AP Aging Report

(Doc ID 2156140.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Goal

On OBIA : 11.1.1.10.1 versionĀ 

Currently W_AP_AGING_INVOICE_A table, does not have any information about GL_ACCOUNT information, where the same is available in W_AP_XACT_F.
Including GL_ACCOUNT_WID, with the existing AP_AGING formula, returns only a few accounts and the grain is not changing.
Since many invoices are against multiple Accounts would like them to be available in W_AP_AGING_INVOICE_A table.
How can this be achievedĀ 

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