Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

AR Aging Bucket (Fusion OTBI)

571
Views
1
Comments
Maram Abuzaid
Maram Abuzaid Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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 

 

Tagged:

Comments

  • Sahil Makhiza
    Sahil Makhiza Rank 3 - Community Apprentice

    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