Oracle Communities

Oracle Analytics and AI

Child Item

OTBI duplicate lines

Hi. Does anyone have any idea how to deal with duplicate lines in OTBI? The subject are we are using is Receivables - Standard Receipts Application Details Real Time. We are getting the receipt information, but it displays two lines for a receipt that was posted and updated. The receipt was posted and updated on two different days using two different natural account and it shows both of those, but we only need one. Anyone has any idea on how to do so? Thanks.

Find more posts tagged with

OTBI

Remove Duplicates

OTBI Reports

Accepted answers

All comments

Rajasekhar Bandaru-Oracle

Please review the OTBI help center documentation link and include recommended date columns in Time Reporting section.
https://docs.oracle.com/en/cloud/saas/financials/24c/faofb/Receivables--Standard-Receipts-Application-Details-SA-39.html#Time-Reporting

missy_21

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.

RVohra

Are you able to identify any additional dimension that is causing duplication (e.g., Remittance Bank, Currency, etc) sometimes two lines differ only by bank or currency or distribution type. If not, then it has to be reviewed by Oracle Support.

missy_21

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.

RVohra

Currently, I have no easy access to OTBI but see if there is Group BY area and in the Results → Layout.

If yes, set an aggregate function for Accounting Date.

missy_21

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

RVohra

How about Aging Days?

missy_21

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.

RVohra

Got it. You might need to work with Oracle Support considering it is a seeded OTBI report.