CE Bank and Branch Upload  Help

CE Bank and Branch Upload creates and updates banks and bank branches in Oracle Cash Management from Excel, one branch per row. Each row names a bank by country and name and a branch of that bank; a bank that does not exist yet is created with its first branch, so a complete bank and branch structure, across several countries, loads in one file.

When to use it

• Load the banks and branches needed during an implementation or a bank rollout.
• Add branches to a bank that already exists.
• Correct branch details in bulk: branch number, branch type, BIC / SWIFT code, EFT number, alternate branch name or description.
• Maintain the bank and branch reference data that internal and external bank accounts are set up on.

Before you start

• Access to the upload in Blitz Report.
• For every row you know the Country, Bank Name and Branch Name, and the branch type (American Bankers Association, Clearing House Interbank Payment System, Society for Worldwide Interbank Financial Telecommunication or Other).

Step 1 – Set the parameters

Open CE Bank and Branch Upload in Blitz Report and choose the Upload Mode:

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens with one row per bank branch, sorted by country, bank and branch, or an empty sheet in Create mode.

Step 3 – Enter or change the banks and branches

Country, Bank Name and Branch Name are required. The bank is found by Country and Bank Name, and also by Bank Number when one is entered; the branch is found by its bank and Branch Name. A branch that is found is updated, otherwise it is created, and a bank that is not found is created first with the row’s Bank Number, Short Bank Name and Alternate Bank Name. On a downloaded row change the Branch Number, Branch Type, Bic Swift Code, Eft Number, Alternate Branch Name or Description; to add a branch, enter a new row. Always fill Branch Type: a row without one is rejected. Pick Country and Branch Type from the list.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which creates or updates each bank and branch.

Step 6 – Review the result report

When the request completes, a result report opens listing every uploaded row with its status and message: Branch created or Branch updated, or the reason the row failed.

What’s produced

• Banks and bank branches in Cash Management, ready for bank account setup.
• A result report listing every row with a status (success or error) and a message.

Common questions

Does the upload change an existing bank?
No. Existing banks are reused unchanged; Short Bank Name and Alternate Bank Name apply only when the upload creates the bank. Only branch details are updated.

Why was a second bank created?
A Bank Number that differs from the existing bank’s number does not match that bank, so a new bank is created. Leave Bank Number blank, or enter the existing number, to add branches to an existing bank.

Can I clear a branch value by emptying the cell?
No. An empty cell leaves the stored value unchanged; change the branch in Cash Management to remove a value.

Can I load the branch or bank descriptive flexfields?
The upload has Attribute Category and Attribute1-24 columns for the branch and Bank Attribute Category and Bank Attribute1-24 for a new bank, but the Default template leaves them out. Add them in a template of your own.

Can I delete a bank or branch?
No. The upload only creates and updates.

Troubleshooting