Error - Select A Valid Value - When Enter Branch Name First and Similar Bank Names Exist (Doc ID 2279619.1)

Last updated on JUNE 22, 2017

Applies to:

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

Symptoms

In Oracle iSupplier Portal (Supplier Registration), Release 12.1.3, an error occurs when selecting the Branch Name after the Bank Name has been selected and multiple bank names are similar.


Error

Select a valid value.



Steps To Reproduce

The issue can be reproduced in a Vision Demo environment, using the following steps:

1. Logged in as user CHORTON.
2. Purchasing, Vision Operations > Supply Base > Suppliers
3. Searched for supplier Consolidated Supplies and click the Update icon.
4. On the Update Consolidated Supplies1 - 1014: Quick Update page, click the Banking Details link.
5. On the Update Consolidated Supplies1 - 1014: Banking Details page, click the Create button.
6. On the Create Bank Account page:
a. Select Country = United States
b. In the Bank region, select Existing Bank and enter Bank Name = Bank of America from the list of values (Bank Number = 163281189)
c. In the Branch region, select Existing Branch, and select Branch Name = New York from the list of values (Branch Number = 736198273)
d. Enter Account Number value = 001234567890
e. Click the Apply button.
Results = The bank account has been added successfully.

7. Back on the Update Consolidated Supplies1 - 1014: Banking Details page, click the Create button.
8. On the Create Bank Account page:
a. Select Country = United States
b. In the Bank region, select Create New Bank and enter Bank Name = Bank of America II (Bank Number = 321543765987)
c. In the Branch region, select Create New Branch, and enter Branch Name = New York II (Branch Number = null)
d. Enter Account Number value = 135790864213
e. Click the Apply button.

9. Back on the Update Consolidated Supplies1 - 1014: Banking Details page, both bank accounts are now appearing.
10. Remove both bank accounts from the supplier record by clicking the Cancel record.  Now, the supplier currently has no bank accounts assigned.
11. Still on the Update Consolidated Supplies1 - 1014: Banking Details page, click the Create button.
12. On the Create Bank Account page:
a. Select Country = United States
b. In the Bank region, select Existing Bank and enter Bank Name = Bank of America from the list of values (Bank Number = 163281189)
c. In the Branch region, select Existing Branch, and select Branch Name = New York from the list of values (Branch Number = 736198273)
d. Enter Account Number value = 001234567891
e. Click the Apply button.

Results = The bank account has been added successfully.

STEPS 13 AND 14 BELOW ARE THE PART TO REPRODUCE THE CUSTOMER'S ISSUE.
13. Still on the Update Consolidated Supplies1 - 1014: Banking Details page, click the Create button.
14. On the Create Bank Account page:
a. Select Country = United States
b. In the Branch region, select Existing Branch, and select Branch Name = New York II from the list of values (Branch Number = 736198273).
This automatically populated the existing Bank Name = Bank of America II from the list of values (Bank Number = 321543765987).
c. Now go back to Bank LOV and select Bank of America again.  There are four (4) results for the same bank.
d. Select Bank of America again.
e. Now go back to select the branch and click Apply.  The error occurs at this point.




Changes

Applied Patch 22190239:R12.POS.B - This patch resolves the issue of "Unable to search Bank branches without entering bank name while creating bank accounts in prospective registration".



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