My Oracle Support Banner

How can we include Account Information within AP Aging Report (Doc ID 2156140.1)

Last updated on OCTOBER 22, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.