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

AR Total Outstanding is not matching with Oracle Fusion

Received Response
12
Views
1
Comments
User_3SSHM
User_3SSHM Rank 1 - Community Starter
in Oracle Fusion AI Data Platform Forum

I can see that FDI shows there is outstanding from a customer under Total Outstanding column but when reviewed the customer account in AR(Oracle Fusion) there is no outstanding.

I tried looking in data validation tab for validating this matric but its not available.

I also tried at transaction level, but FDI treats transaction and payment as different rows and showing the outstanding as +ve and -ve values.

Can anyone faced the similar issue/ any approach to validate the FDI Total Outstanding or a way to get customer balances.

Tagged:

Answers

  • JohnW-Oracle
    JohnW-Oracle Rank 7 - Analytics & AI Coach

    Hello @User_3SSHM,

    The Total Outstanding from a customer could be different in FDI compared to Fusion if the Pipeline has not run for the day (depending on how often you run it). This is the first thing to check.

    If could also be different if the Transaction in Fusion had not been closed or 'Accounted'.

    Regards,

    John