Bank Account Created But Not Assigned To The Right Customer

(Doc ID 1483741.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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

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 = '111112222';

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