R12: AP: Duplicate Lines Inserted Into IBY_EXTERNAL_PAYEES_ALL When Creating External Bank Account

(Doc ID 1923996.1)

Last updated on APRIL 02, 2018

Applies to:

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

Symptoms

Problem Statement:

Clicking the GO button on the Bank Accounts screen multiple times results in multiple erroneous entries to the IBY_EXTERNAL_PAYEES_ALL table.

Steps To Reproduce:

1. Using Payables Manager responsibility, navigate to Suppliers > Entry

2. Create a supplier. At this time, a row for the supplier is inserted into iby_external_payees_all.

3. Click on Address Book link (left side). Create a new address for the supplier, assigning to an Operating Unit.
When the new site is created, an another row for the site is inserted in to iby_external_payees_all.

4. Click on Banking Details link (left side).
In Banking Details page, select 'Address' for Account Assignment Level and click the 'Go' button twice.
** Make note of the 2 second delay between click of the 'Go' button.

5. Click 'Create' button in Bank Accounts region. In Create Bank Account page, create a bank account and click 'Apply' button.

6. In Banking Details page, remain 'Address' for Account Assignment Level and only click 'Save' button.

7. You can see that 2 rows(the duplicate rows) for the address are inserted into iby_external_payees_all because the 'Go' button was clicked twice previously.

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