Configure Banks and Bank Accounts

Banks and bank accounts must be configured in Oracle Cloud ERP before transacting. The recommended method is to use turnkey implementation spreadsheet to upload bank accounts. Alternatively, you can manually enter the bank and bank account details using the user interface. This will not create any matching rule sets.

The bank provides a list of your bank accounts. Verify with the bank that the accounts are set up for the correct payment types and obtain the sender ID for the transmission.

  • Upload bank accounts using the turnkey implementation spreadsheet.
    1. Download the template from the document Knowledge Article KB930302 from the Oracle Support website.
    2. Copy the bank accounts from the list provided by the bank to the turnkey implementation spreadsheet
      1. Enter the sender ID received from the bank in the Company ID column.
      2. Enter the legal entity.
    3. Generate the XML file by following the instructions in the template.
    4. Sign in as a Financials Administrator, Application Implementation Consultant, or a user with equivalent privileges.
    5. From the Setup and Maintenance work area, search for the task Upload Banks, Branches, and Accounts.
    6. Run the upload process by selecting:
      • File Type = Turnkey Onboarding
      • Data File = XML file generated from the spreadsheet
    The process:
    • Creates bank accounts and associated setup.
    • Assigns business units to bank accounts based on legal entities.
    • Automatically assigns the bank statement transaction creation rule set for the legal entity of the bank account and the bank statement reconciliation rule set Oracle B2B integration matching rule set.

      If you’ve already enabled Embedded Banking Services with another bank, the Oracle B2B integration matching rule set already exists in your environment. You can assign this reconciliation matching rule set and the applicable transaction creation rule set to bank accounts that already exist in Oracle Cloud ERP to use enhanced bank statement processing capabilities. You can also continue to use your existing bank statement matching rules.