Automate Receipt reversal for Direct Debit payment failures based on pain.002 xml

Summary

Automate Receipt reversal for Direct Debit payment failures based on pain.002 xml

Content

Is there a standard way in Oracle to automatically reverse the Direct Debit receipts based on a pain.002 xml file shared by the Bank?

Note: Oracle notes expects this file to have both accepted and rejected payments, however, the bank only provides rejected payments for all the direct debit failures.

Oracle engineers suggested this process is not standard and has to be developed and automated. However, looking to see how best can the client handle this process each month and avoid manual processing