OTBI analysis on duplicate expense lines
Summary:
How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice by mistake. The subject area is Expenses - Expense Transactions Real Time. The report should return rows with identical Employee Name, Merchant Name, Reimbursable Amount, and Start Date. It should return those columns with a count of duplicate rows.
Thank you.
Content (please ensure you mask any confidential information):
For example, there are 2 rows with this identical information:
Employee Name: Smith, Bob
Merchant: Costco
Start Date: 1/1/2025
Amount: $100
The report should return those values and a count of 2: