Financials - AR Aging Question

Question

Hello. I am trying to build an AR Trend analysis graph using the Financials - AR Aging subject area. While validating data, I'm noticing the majority of the unpaid AR Invoices aren't showing up in this subject area. I'm only seeing 2 when I know we have at least hundreds. Is there something special that has to occur in order for unpaid AR Invoices to show up in this subject area aside from configuring the buckets in fusion?

User_WJ43I · Answer

@Shobana Kapyarath-Oracle SR: 4-0002154290

Shobana Kapyarath-Oracle · Answer

pls share the Oracle SR#

User_WJ43I · Answer

@Shobana Kapyarath-Oracle I did log an SR. The invoices are accounted. We do not use multi funded AR. I'm going through the items the Oracle Service team member provided. I'm starting to wonder if the issue might be around how the aging buckets were setup in fusion. I did not do that setup so I'm wondering if maybe it wasn't done correctly. I'm also going to look for any documentation around that. At the moment, of all of our unpaid accounted invoices, only two are in the AR Aging subject area. Both of those are the only two that have TRANSACTION_SOURCE = 'Manual' and TRANSACTION_TYPE_NAME = 'TRC_Prepayment'. It seems odd that there are only two invoices with that combination, and they are the only two showing in the AR Aging subject area.