An automated integration is needed between the bank and Oracle Receivables to generate receipts.
The customer needs an automated integration between the bank and Oracle Fusion Receivables to generate receipts from payment transactions received via Fab Magnati (a payment gateway provider).
Our aim is to have all collections processed through Fab Magnati automatically imported into Oracle using AR Lockbox functionality.
We need guidance on the following:
1- Best practice for automating daily receipt creation from bank files that include Fab Magnati transactions.
2- Required file format and mandatory fields to process such receipts using Lockbox.
3- How to distinguish Fab Magnati-originated payments within the bank file (via specific references or identifiers).
4- Avoiding duplication and ensuring transactional accuracy.