Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
AP invoices have an outgoing AR invoice
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.
0
Answers
-
@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!
0

