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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

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!