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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Bank

ACTUAL BEHAVIOR
---------------
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.


EXPECTED BEHAVIOR
-----------------------
SHOULD MIGRATE DATA AS EXPECTED

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.upgrade from 11i to R12.2.4

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot

Cause

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