Updating Payment Status from US Bank Recon File in Oracle Fusion Cloud-We would need solution

Summary:

We are currently implementing US Bank Virtual Card Payments (VCC) in Oracle Fusion Cloud (Payables), where payments are issued to vendors through US Bank and a reconciliation (recon) file is received back indicating the payment outcomes (e.g., redeemed, expired, voided, reissued).

Content (please ensure you mask any confidential information):

Our business requirement is to update invoice and payment statuses in Oracle Fusion Cloud automatically or in bulk, based on this recon file.

Business Need:

We need guidance on how to best update the following:

      •     Payment Status (e.g., Cleared, Negotiable, Void)

      •     Invoice Status (e.g., Paid, Cancelled)

Version (include the version you are using, if applicable):