Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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.
Answers
-
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-Reporting0 -
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.
0 -
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.
0 -
Hi. The columns that are causing the duplication are the Aging Days and Accounting Date.
0 -
- 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.
0 -
I added the MAX aggregation to the Accounting Date and it still shows two lines.
0 -
How about Aging Days?
0 -
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.
0 -
Got it. You might need to work with Oracle Support considering it is a seeded OTRBI report.
0
