Outstanding Corporate Card Transaction Report

Summary

Need to determine who has not processed card transactions through expenses.

Content

With the corporate card administrator role, we can see there is $xx amount of money that has not been reconciled in an expense report. We are looking for a method to drill down to the user level to know who has outstanding transactions. For example, I can see the Budget Office has $100,000 outstanding and I need to see that Jon Kelly has $12,500 outstanding and the list of transactions. Is there any table or report that we could build? I found a bug/ER to create this report on Oracle's side, but we need something now to be able to