Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

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

Financials - AR Aging Question

Received Response
29
Views
4
Comments
User_WJ43I
User_WJ43I Rank 3 - Community Apprentice
in Oracle Fusion AI Data Platform Forum

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?

Tagged:

Answers

  • Shobana Kapyarath-Oracle
    Shobana Kapyarath-Oracle Mod

    AR Aging subject area shows only accounted invoices. Please confirm if the unpaid invoices that are not showing are accounted.

    Also, currently in FAIDP AR subject areas, Multi Funded Account Receivable (MFAR) is not supported. So, if the ledger has MFAR enabled, these transactions will not be available even if they are accounted.

    Please log Service Request if you would like Oracle Support to review your transactions if these are accounted and MFAR is not being used. Thanks!

  • User_WJ43I
    User_WJ43I Rank 3 - Community Apprentice

    @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.

  • Shobana Kapyarath-Oracle
    Shobana Kapyarath-Oracle Mod

    pls share the Oracle SR#

  • User_WJ43I
    User_WJ43I Rank 3 - Community Apprentice

    @Shobana Kapyarath-Oracle SR: 4-0002154290