Configure Banks and Bank Accounts

Banks and bank accounts must be configured in Oracle Cloud ERP before transacting.

If your banks and bank accounts aren't already configured, use one of these methods:
  • J.P. Morgan Integrated Banks and Bank Accounts (automatically generated through the onboarding process)
  • Self-Managed Banks and Bank Accounts (created manually or through file-based uploads)

J.P. Morgan Integrated Banks and Bank Accounts

Integrating with J.P. Morgan automatically creates bank and bank account details for accounts listed in your Statement of Work (SOW) document. During initial connectivity, the banks and bank accounts process automatically creates banks, bank branches, and bank accounts, as well as reconciliation configurations and bank statement transaction creation rules. Contact the bank's team when adding or changing accounts included in your integration.

Troubleshooting

The Banks and Bank Accounts automatic configuration process may result in an error message. It is displayed on the Manage Embedded Banking Configurations task page.

You also receive a notification with details about any configuration issues. After you resolve the issues, select Resolve Now in the dialog box to reimport the bank onboarding file.

A notification lists the bank accounts that were successfully created and those that failed, including the reason for each failure. Review the reported issues, update the prerequisite configuration, and reimport the bank onboarding file. This process applies to both initial and incremental bank onboarding.

You can review the bank account onboarding file using the link on the bank onboarding page.

Page Navigation
  • Success:
    • The page displays the successfully created banks, branches, and bank accounts as a header message.
    • The page opens the bank accounts search page with an option to perform a mass update for the cash, cash clearing, and reconciliation difference accounts.
  • Error:
    • If the bank onboarding process ends with a status indicating that onboarding couldn't be completed, you can use the retry option after completing the prerequisite legal entity configuration.
    • If EMEA accounts are included in the onboarding file, the file is processed as expected except for these countries: France, Israel, Italy, Portugal, Spain, and United Kingdom.
      • If the onboarding file includes any of the countries listed above, the process completes with an Error status. Connectivity is still established, but the bank accounts for these countries must be configured manually.
  • Exceptions:
    • Duplicate banks, bank branches, and bank accounts: Duplicates are included in the notification.
    • Prerequisite configuration not available: Business units, business functions, ledger, and chart of accounts must be configured before you obtain the bank onboarding file from the bank.

The business unit association is completed automatically during the bank onboarding process. If the ledger of the business unit and the legal entity is the same, the business unit is associated with the bank account if either the supplier payment or customer payment business function is enabled.

Payables and Receivables Usage Defaults

For onboarded bank accounts:

  • Payables usage is selected if at least one business unit associated with the bank account has the supplier payment business function enabled.
  • Receivables usage is selected if at least one business unit associated with the bank account has the customer payment business function enabled.

Self-Managed Banks and Bank Accounts

You can create your banks and bank accounts using one of these standard Oracle Fusion implementation methods. To use enhanced bank statement processing features, assign the bank's predefined codes to your bank accounts.
  • Upload bank accounts using the rapid implementation spreadsheet. See Oracle Support for a generic template.
  • Manually enter the bank and bank account details using the user interface.
Note: If you use existing accounts or self-manage bank accounts by configuring your own banks and bank accounts, the status for Banks and Bank Accounts may appear as Failed after establishing connectivity, with error messages related to account creation. This status and the error messages are acceptable as long as the other configurations show Completed.