Configure Bank Statement Processing
Use this integration to automatically retrieve, import, and reconcile bank statements.
The integration uses the bank's CAMT.053 statement format based on ISO 20022 standards. Predefined configurations available through View Configurations simplify implementation and processing.
Configure banks and bank accounts for reconciliation by using the standard Oracle Fusion implementation methodology. Manually update your accounts with reconciliation rules using the predefined codes where relevant.
Note: You are responsible for requesting that your bank’s
implementation manager follow the Embedded Banking Services bank statement process. The
file name and format must exactly match these standards:
- File Name: <POD NAME>.BOFA.CAMT53*.<YYYYMMDDHHmmss>.xml.pgp
- Provide the bank with your Oracle Fusion PODname.
- Don’t replace periods (.) with underscores (_).
- The POD NAME should only include the POD family name. Don't include qualifiers like "-test" or "- dev1".
- Use the provided encryption keys. The .pgp extension is added automatically after encryption. Don't manually rename the file to add the .pgp extension. Oracle Fusion Embedded Banking Services recognizes only properly encrypted PGP files.
- Include the complete date and time stamp to ensure a unique file name. Embedded Banking Services doesn't process duplicate file names.