Bank Account Created But Not Assigned To The Right Customer
Last updated on MARCH 22, 2018
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:
When we create a new bank account for a customer the bank account is not created correctly, appears a message that says that the bank account exist, but when we want to add the bank account to the customer we can not selected, if we look trhough DB the bank account exist but ishow the account owner as -99.
The customer existed prior but had no bank account assigned. The bank account is new (added after upgrade).
The test case we have is for the bank account '111112222. This bank account exists but was not assigned to the customer correctly. The user concerned then tried to create the bank account again through the customer screen and got the error that the account already exists. I checked the tables and there is a record (actually 2) in the table Iby_Ext_Bank_Accounts for this account. I then checked the table Iby_Account_Owners which should have a record that links the account to the customer that owns it. A record exists but the column Account_Owner_Party_Id has the value -99.
See query below
From Apps.Iby_Ext_Bank_Accounts Ibybanks,
and Owners.Ext_Bank_Account_Id = Ibybanks.ext_Bank_Account_Id
And Ibybanks.Bank_Account_Num_Electronic = '111112222';
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