Oracle Fusion AI Data Platform Forum

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

AP invoices have an outgoing AR invoice

Received Response
24
Views
1
Comments
Marilyn Keating-Oracle
Marilyn Keating-Oracle Rank 3 - Community Apprentice

Working on a use case to validate that all AP invoices have an outgoing AR invoice, the number's are equal but they don't share any other attributes. Here is the error I encountered, what am I doing wrong? Was able to perform the join on local subject area's but aggregation totals are not summing correctly. Below is on FDI metrics.

image.png

Answers

  • RVohra
    RVohra Mod
    edited Feb 20, 2026 5:28AM

    @Marilyn Keating-Oracle , It is obvious you are getting this error because in Oracle FDI, AP invoices and AR invoices do not share any natural join key. It is better to aggregate both datasets independently before comparing. Hope it helps!