OTBI analysis on duplicate expense lines — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!