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.

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.

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.

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 same email. The international customer still fails.