My Oracle Support Banner

R12: Payables: On Creating a Supplier Bank Account, System Gives 'The External Bank Account Already Exists' Error (Doc ID 1342935.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

On creating a supplier bank account, system errors with 'The External Bank Account Already Exists' 

Steps to Reproduce:

  1. Log in to Payables Responsibility
  2. Navigate Suppliers->Entry
  3. Query existing supplier
  4. Navigate to Banking Details page
  5. Select Account Assignment Level
  6. Click on Create Button
  7. Add details of Bank Account
  8. Click on Save, system shows "The External Bank Account Already Exists" error message
  9. Navigate Home Page->Suppliers->Search Supplier Bank Account Assignment
  10. Query for assignment for Bank Account details of step 7, no assignment is displayed
  11. Run following query and verify bank account detail of step 7 gets retrieved:This is to check Orphan Bank Accounts
SELECT *
FROM iby_ext_bank_accounts eba
WHERE NOT EXISTS (SELECT 'OWNER'
FROM iby_account_owners
WHERE account_owner_party_id <> -99
AND ext_bank_account_id = eba.ext_bank_account_id)
AND NOT EXISTS (SELECT 'ASSIGNMENT'
FROM iby_pmt_instr_uses_all
WHERE instrument_type = 'BANKACCOUNT'
AND instrument_id = eba.ext_bank_account_id)
AND NOT EXISTS (SELECT 'UPGRADE_ASSIGNMENT'
FROM iby_upg_instruments
WHERE instrument_type = 'BANKACCOUNT'
AND instrument_id = eba.ext_bank_account_id);

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.