Invoice Count Shows Incorrect Results When Creating Workbooks On A Dataset Combining Two Subject Areas in FAW
(Doc ID 2987573.1)
Last updated on NOVEMBER 24, 2023
Applies to:
Fusion Analytics Warehouse - Version N/A and laterInformation in this document applies to any platform.
Symptoms
When creating a DV dataset by combining two of the FAW subject areas ( Financials- GL Balance Sheet and Financials- AP Invoices), the preview of the dataset may show proper data, but there maybe incorrect data when users create workbooks OR reports on top of the dataset.
This can easily be seen by using the below steps
- Create a new dataset by joining two subject areas Financials – GL Balance Sheet and Financials -Ap Invoices.
- In the Financials – AP invoices SA filter the Invoice accounting fiscal period column for a month ( Example : JAN-2018) , it shows X number of records and the invoice count to Y. Aggregation for The Invoice Count column is set to Sum(default) and save the dataset.
- Create a workbook based on this dataset by including Invoice Amount Fiscal Period and Invoice Amount columns from Financials- AP invoices.
- You may see incorrect results in the measure Invoice Count.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |