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 one reason or another. When this happens, users will occasionally create a new ProCard transaction line directly in their expense report to account for the charge that has become unassociated. This results in two expense line items for a single actual ProCard transaction. This unassociation also causes difficulty reconciling since we lose the sheet_id foreign key link in the backend on EX_TRANS. We essentially have to result in identifying the unassociated transaction by joining on