Reconciling MyWallet ProCard Transactions with Expense Lines

Hello Oracle Community,

I am working on reconciling MyWallet ProCard expense transactions with their corresponding expense reports. Specifically, I’m having difficulty tying the primary MyWallet transaction record (EX_TRANS) to the related expense report lines (EX_SHEET_LINE).

In our system, we’ve observed that MyWallet transactions that were once associated to an expense report sometimes become “unassociated” from an expense report ID for various reasons. When this happens, users will occasionally create a new ProCard transaction line directly in their expense report to account for the charge. This results in two expense line items for a single actual ProCard transaction.