Automated Zengin master data upload for bulk maintenance of banks and bank branches in Japan
Upload Japan Zengin bank master data for bulk maintenance of banks and bank branches without the need to manually prepare and consolidate multiple CSV files before import. The feature automates Zengin bank-master CSV ingestion so users can upload the files as received. The process handles native Shift-JIS encoding and filters out sub-branch rows where sequence code isn't 1. This removes the need to manually merge files, convert them to UTF-8, or clean up sub-branch records before upload, while leaving deactivation or end dating decision with the user.
Business benefits include:
- Removes manual file consolidation, encoding conversion, and sub-branch cleanup.
- Avoids automatically changing inactive master records; users retain control of end-dating decisions.
Steps to enable and configure
You don't need to do anything to enable this feature.
Tips and considerations
To process Zengin bank master data in bulk:
- Go to Scheduled Processes, select Upload Banks, Branches, and Accounts.
- Choose Japan Zengin File as the file type, and upload the latest Zengin files in their supplied format.
No additional steps needed for pre-merging, UTF-8 conversion, or removing sub-branch rows where the sequence code is not.
- Existing records already prefixed with “Deleted” are not automatically changed.
- Maintain a governance process to review Zengin difference information and decide which banks/branches to end-date.
Key resources
- Based on Idea 737667 from the Payables, Payments & Cash Management Idea Lab on Oracle Cloud Customer Connect.
- Oracle Help Center: Using Cash Management
Access requirements
No new access requirements.