Updating Invoice and Payment Status from US Bank Recon File in Oracle Fusion Cloud
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).
The recon file includes various scenarios — for example:
• Vendor has redeemed the VCC
• VCC is not redeemed but still valid
• VCC expired and reissued
• VCC expired and voided by AP
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:
0