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

Last updated on MARCH 08, 2017

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.

Goal

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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms