My Oracle Support Banner

R12/CE: Upgrade From R11 To R12.2.4, CE_BANK_BRANCH, CE_BANK_ACCOUNTS, CE_BANK_ACCOUNT_USE Tables Have No Values (Doc ID 2032904.1)

Last updated on AUGUST 18, 2023

Applies to:

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

Symptoms

*Symptoms
Briefly describe the symptoms of the problem. Remember to delete any customer specific information

After Upgrade from R11 to R12.2.4, some CE tables have no values

SELECT * from CE_BANK_ACCOUNTS; --returns no records
SELECT * from CE_BANK_ACCT_USES_ALL; --returns no records
SELECT * FROM ce_bank_branches_V; --returns no records
During upgrade some scripts failed, including the script that generated the legal entities in R12.

After resolving that issue (now all legal entities are created) we have found that other scripts seems to have failed to populated CE tables with the corresponding bank information.
We need a data fix / action plan to resolve this upgrade issue.

It is expected that upgrade should go correctly.


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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