My Oracle Support Banner

Bank Account Created But Not Assigned To The Right Customer (Doc ID 1483741.1)

Last updated on JANUARY 24, 2020

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.


On R12.1.3 in an upgraded environment:

After upgrading from 11i to Release 12.1.3, when creating a new bank account for an existing customer the user receives a message that the bank account exist.  When trying to add the bank account to the customer the user cannot select it.  This bank account exists, but was not assigned to the customer correctly.  Checking the data in the tables and find two records in table IBY_EXT_BANK_ACCOUNT for this account and find table IBY_ACCOUNT_OWNERS (links the account to the customer that owns it) has ACCOUNT_OWNER_PARTY_ID with value -99.

This existing customer had no bank accounts assigned before the upgrade. The bank account was created after the upgrade.

Check the data using the query below:

Select Owners.Account_Owner_Party_Id
From Apps.Iby_Ext_Bank_Accounts Ibybanks,
Apps.Iby_Account_Owners Owners
Where 1=1
and Owners.Ext_Bank_Account_Id = Ibybanks.ext_Bank_Account_Id
And Ibybanks.Bank_Account_Num_Electronic = '&bank account';


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.