1. Implementing Receivables Credit to Cash
  2. Bulk Maintenance of Banks and Bank Branches in Japan

Bulk Maintenance of Banks and Bank Branches in Japan

Manage banks and bank branches automatically by comparing the bank master file shared by the Japanese Bankers Association (Zengin) with Oracle Cloud ERP data.

This eliminates manual maintenance of banks and bank branches in Oracle Cloud ERP after comparing the application data with the latest bank master files.

The Japanese Bankers Association (Zengin) provides monthly updates with the latest bank and branch information that needs to be updated monthly in Oracle Cloud ERP. Banks and branches can be added, updated, or ignored. Banks and branches that aren't present in the uploaded Zengin files aren't automatically prefixed with "Deleted"; you decide whether and when to end date them.

The Upload Banks, Branches, and Accounts process compares the uploaded Zengin CSV files with the existing bank and branch data and identifies differences. You can upload the files as supplied by Zengin without first consolidating them. The process supports native Shift-JIS encoding and filters out sub-branch rows where the sequence code isn't 1. Oracle Cloud ERP then inserts or updates the bank and branch data based on the differences found.

  • Banks are identified with the bank code and branches are identified with the branch number.
  • If the banks and branches are present in the Zengin files, but not available in Oracle Cloud ERP, then new banks and branches will be created.
  • If banks and/or branches are present in both the Zengin files and Oracle Cloud ERP, then they will be ignored.
  • If a bank or bank branch exists in Oracle Cloud ERP but isn't present in the uploaded Zengin files, the process doesn't automatically change or end date the record. You retain responsibility for reviewing differences and deciding which banks or branches to end date.
  • Existing banks and bank branches that already have the "Deleted" prefix aren't automatically changed by this process.
  • If the bank name/alternate bank name or branch name/alternate branch name associated with the bank code/branch number changes, then that data will be updated.
  • Only branch rows with sequence code 1 are processed. Rows with a sequence code other than 1 represent sub-branches and are ignored during import.

To bulk upload banks and bank branches in Japan, follow these steps:

1. Go to Tools > Scheduled Processes.

2. Select Schedule New Process. The Schedule New Process dialog box appears.

3. From the Name choice list, select Upload Banks, Branches, and Accounts.

4. Select OK. The Process Details dialog box appears.

5. From the File Type list, select Japan Zengin File.

6. Upload the latest Zengin CSV files in their supplied format. You don't need to merge the files, convert them from Shift-JIS to UTF-8, or remove sub-branch rows before upload.

7. Select Submit. After submitting the process, you can review the results from the output ZenginResults.txt file. Review the process output and Zengin difference information, and use your governance process to determine whether any banks or branches should be end dated.