My Oracle Support Banner

R12: Generic Data Fix (GDF): Duplicate bank accounts in IBY_EXT_BANK_ACCOUNTS (Doc ID 1265353.1)

Last updated on JANUARY 31, 2019

Applies to:

Oracle Payables - Version 12.0.0 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.


The goal of this document is to describe what the Generic Data Fix (GDF) <Patch 10144798> ("GDF: DUPLICATE EXTERNAL BANK ACCOUNTS") does, why it is needed, when and how to use it.  And also what code fix patches are available to prevent this issue from recurring.

Note: For more information on Generic Data Fix patches, including a complete list of GDF patches available, please see My Oracle Support <Note 874903.1>.

Some of the issues that these scripts will address are listed here for your reference:

  1. Getting error "The external bank account already exists" while trying to create a new bank account.
  2. Error when running iby_dup_bnkAcct_Fix.sql
  3. Unable to add or amend Bank Details page in Supplier records.  Getting error: "Attribute BankPartyid in ExtBankAccountsAM.ExtBankBranchesVO1 is required".
  4. "Remit-to Bank Account" not defaulting.
  5. User added additional lines to invoice after it was originally validated and paid. Now this invoice is partially accounted and needs revalidation.  However, "duplicate bank account" error occurs during validation.
  6. In 11i, same banks were assigned to multiple sites associated with multiple operating units. After upgrade, now that bank assignment is at the header level, system shows list of same banks under a single supplier.
  7. Supplier Site Contacts Open Interface Import Error - "Inconsistent data entered as compared to TCA".
  8. Create Accounting does not pick up the Payments.


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
 What does it do?
 Why is it needed?
 When to use it?
 How to use it?
 Known Root Cause Bugs/Notes for this Issue 
 Additional Bugs/Notes related to this GDF
 Standard Patching Process
 Patch Wizard
 Have more questions?

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