Oracle Fusion ERP Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion ERP Analytics

Categories

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

I want to show Accounts Receivable Invoice aging days by Project in FDI

Received Response
55
Views
2
Comments
ACDC
ACDC Rank 3 - Community Apprentice
edited Mar 5, 2025 3:21AM in Oracle Fusion ERP Analytics

I am trying to build a dashboard in FDI to show Accounts Receivable (AR) aging days and outstanding amount by project/contract etc.

I am using AR Aging subject area which does not provide any information of Project or Invoice.

subject area AR transactions has contracts, remaining amount and some dates but no project information.

subject area Project Invoices does not show remaining amount etc.

When i bring AR aging and Prj invoicing etc, it throws some odd figures as relationships are not valid.


How could i get/calculate invoice aging days by project and Invoice? Which subejct area/s could provide this information?

Tagged:

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    @Ramamurthy Shankarachetty-Oracle Any inputs/suggests here?

  • Nandini Krishnan-Oracle
    Nandini Krishnan-Oracle Mod

    Currently the project is at the Invoice distribution level. Depending on the grouping, an Invoice can have multiple projects. Users can see the remaining amount, Contract and Invoice from the AR Transaction subject area. You can add another table with Receivable Number, Contract Number, Project number and the Invoice Amount from the Project Invoice subject area. By passing the contract number, drill down to see the Projects which are part of that contract and Invoice.