https://community.oracle.com/products/oracleanalytics/discussion/comment/72192#Comment_72192 Yes. I used aggregation for both. However, the receipt is posted in two different accounts so the aggregate function may not really work for this.

I added the MAX aggregation to the Accounting Date and it still shows two lines. https://community.oracle.com/products/oracleanalytics/discussion/comment/72188#Comment_72188

https://community.oracle.com/products/oracleanalytics/discussion/comment/72183#Comment_72183 Hi. The columns that are causing the duplication are the Aging Days and Accounting Date.

I added Application Date as suggested and it ruined the report. This is a seeded OTBI report named 'Unapplied Receipt Register' by the way. We just customized it to add Bank Account Info, Receipt Comments, Application Status, and Aging Days.

https://community.oracle.com/products/oracleanalytics/discussion/comment/70859#Comment_70859 Hi Bhaskar, We were able to resolve the issue by adding 'Statements' in the Communications tab of each Customer.

Hi Bhaskar, We were able to open an SR regarding this issue. Will update once Oracle resolve. https://community.oracle.com/products/oracleanalytics/discussion/comment/70805#Comment_70805

https://community.oracle.com/products/oracleanalytics/discussion/comment/70764#Comment_70764 Hi Bhaskar, We used the same email for both the domestic and the international customer. Just for the sake of testing, we set the contact points for both the sample domestic customer and sample international customer to have the…