Some Banks Accounts of Branch Did Not Migrate Over To Cash Management (Doc ID 1419206.1)

Last updated on JUNE 10, 2015

Applies to:

Oracle Cash Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

 

R12 Upgrade:  There were few banks and accounts which were not upgraded during the normal upgrade from 11i.:

No rows in the following sql:

1) select * from ce_bank_accounts ;


2) select * from ce_bank_acct_uses_all ; However shows Roows in the following: 3). Query to find the Branches that did not upgrade     ------------------------------------------------------------------- select bb.bank_branch_id, bb.bank_name, bb.bank_branch_name, bb.country from ap_bank_branches bb, ce_upg_bank_rec cb, ce_bank_branches_v cbv where cb.source_pk_id(+) = bb.bank_branch_id and   cb.party_id = cbv.branch_party_id(+) and   cb.bank_entity_type(+) ='BRANCH' and  cbv.bank_branch_name is null order by bb.bank_name; 4). Query to find the Bank Accounts that did not upgrade     ---------------------------------------------------------------------       select pay.bank_account_id , pay.bank_account_name , pay.bank_account_num       from ap_bank_accounts_all pay, ce_bank_accounts cash,            ce_upg_bank_accounts cuba       where pay.account_type  in ('INTERNAL','PAYROLL')       and pay.bank_account_id = cuba.source_pk_id(+)       and cuba.ce_bank_account_id = cash.bank_account_id(+)       and cash.bank_account_name is null       order by pay.bank_account_name; 


There exists a custom  process to validate checks, check number, and account numbers sent to banks for employees to clear their checks [Positive Pay]. Because the accounts are not existing the ce_bank_accounts table, the process is failing to generate a file. 
 
All the un-migrated accounts were type "PAYROLL" and same bank branch id "17577" .

Changes

Upgrade

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