AR Aging Bucket (Fusion OTBI)

Maram Abuzaid

Content

I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket

but there is no subject that is called aging 

I tried to check the query of this report "Receivables Aging by General Ledger Account"

but I did not find the table names in the attached file of OTBI tables as well

 

Is there any subject area that has the Aging data even if I needed to edit the date formula and so on 

Please advise me 

 

Sahil Makhiza

Hi,

There is no subject area which can directly give the aging details.

You can try with Receivables - Transactions Real Time or Receivables - Payment Schedules real time and edit the formula to calculate the aging on the basis of dates available in the subject area