My Oracle Support Banner

R12/CE: ce_branch_merge.sql Errors While Updating Two Branches Having Duplicate Ext Bank Accounts (Doc ID 1600819.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Cash Management - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Cash Management - Version 12.0.6 to 12.2.3 [Release 12 to 12.2]
Information in this document applies to any platform.


During migration of bank and bank account data from 11i to R12, there is a high chance that duplicate banks and branches get created. This happens because of the inherent architectural difference in the 11i and R12 bank account model.

A generic datafix (GDF) patch consisting of merge scripts is being provided to address this. These scripts will allow merging of banks and branches to eliminate duplication.

***Important*** Bank and bank branch information is used across EBS Financials products and merging of banks or branches has to be done carefully to avoid data integrity issues. Please read the sections below on Restrictions and Potential Risks/Impacts carefully. Consider the risks involved before attempting to merge banks or bank branches.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.