How Can Unassigned Bank Accounts Be Found With The Search Supplier Bank Account Assignment Page? (Doc ID 1308665.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.

Symptoms

On 12.1.1 instance, we have applied the <Patch 9448624>:R12.IBY.B to deliver the new "Search Supplier Bank Account Assignment" page.

We then try the following:

1 - When creating a new bank account with account number XXXXXXX, we get a message that "The external bank account already exists"
2 - But when searching for the account number in the 'Search Supplier Bank Account Assignment' page, no results are returned.

These results seem to be contradictory!

We have already confirmed that <Patch 8746155>:R12.IBY.B and <Patch 9251608>:R12.CE.B are applied, and that this bank account is not a duplicate (the select script from <Patch 10144798>:R12.IBY.B was used to confirm this).

Expected behaviour
If this bank account number XXXXXXX does indeed exist, it should be findable on the 'Search Supplier Bank Account Assignment' page.
Otherwise, we should be able to create this bank account for the given supplier.

Business impact
Not able to perform supplier bank account search and link bank account to a particular supplier, causing supplier service delay.

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