Create Banks and Branches

To create new banks, branches, or addresses, you must enter the correct action in your spreadsheet so the integrator knows how to process the row.

  1. Locate the Upload Action Column: Navigate to the section where you want to create a record and find its corresponding action column. The integrator includes the following action columns:

    • Banks Upload Action

    • Bank Addresses Upload Action

    • Branches Upload Action

    • Branch Addresses Upload Action

  2. Set the Action to Create or Create records: In the Upload Action column, click on 'Data Forms' to open the list of values (LOV) or type the action manually.

BB Create form
  1. Populate Data Fields: Enter the required data for your new banks, branches, or addresses (e.g., routing numbers, standard names, and physical locations). Click on 'Data Forms' to open the list of values (LOV) or enter the data manually.

  2. Upload to Oracle: Once your sheet is populated, use the standard upload ribbon command to validate the data and upload your new records to Oracle ERP Cloud.

When the data is uploaded to Oracle, the status columns for the sections uploaded will be set to 'Accepted'.

BB Create New

The following columns are required on the sheet to Create:

Banks

The following columns are required to be on the sheet to Create the Banks section.

  • Country Name

  • Bank Name

Bank Addresses

The following columns are required to be on the sheet to Create the Bank Addresses section.

  • Country Name (from Banks section)

  • Bank Name (from Banks section)

  • Bank Address Number (leave blank for autogenerated number to populate)

Branches

The following columns are required to be on the sheet to Create the Branches section.

  • Country Name (from Banks section)

  • Bank Name (from Banks section)

  • Branch Name

Branch Addresses

The following columns are required to be on the sheet to Create the Branch Addresses section.

  • Country Name (from Banks section)

  • Bank Name (from Banks section)

  • Branch Name (from Branches section)

  • Branch Address Number (leave blank for autogenerated number to populate)