OAC- Duplicate Amounts When Adding Project Details in Asset Transactions

Question

Hi Team,

@Darryn Hinett-Oracle @JohnW-Oracle

The below issue has been reported by an FDI customer currently using ERP Analytics. The concern appears to be specific to the Oracle Analytics Cloud (OAC) layer, and we would appreciate any thoughts or suggestions to help investigate and resolve it.

Issue Summary:

Duplicate Amounts When Adding Project Details in Asset Transactions

* The values in the ‘Contract Amount’ and ‘Funding Amount’ columns are appearing multiple times (duplicated/tripled/more) for the same Contract Number.
* We have already verified the values in the Fusion ERP source system, and they are accurate and as expected.

Request:

Could you please advise if there are any known issues or recommended workarounds at the OAC reporting/model level to address this?

Appreciate your support.

User_MCABE · Answer

Hi @PRATHEEK

We are facing similar issue, the funding amount is getting doubled for the same contract number. Have you got any workaround for this issue ? Please do let me know.

Thank you in advance.

JohnW-Oracle · Answer

Hi @PRATHEEK,

We may need to get some additional information to answer this fully like the logical and/or physical query. A SR may be required for that unless you can hide the PI.

Do you have a Time dimension in this Workbook?

One example of something to check is your Aggregation Method. In OAC, with the Workbook open and edited, Switch from Grammar to Properties on the toolbar to the left.

Click on '#'

Under Aggregation you will see 'By'. Click what you want to group by.

This will enable the Aggregation setting and change that to SUM.

Regards,

John