My Oracle Support Banner

EAP - Invalid Value Error On BNK_ID_QUAL_VW COUNTRY Code When Loading Data Via VNDR_ID_EXCEL CI (Doc ID 2600647.1)

Last updated on OCTOBER 17, 2019

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When loading data via VNDR_ID_EXCEL CI the following error occurs on BNK_ID_QUAL_VW COUNTRY code.

Invalid value -- press the prompt button or hyperlink for a list of valid values (15,11)
Error changing value. {VNDR_ID_EXCEL.VNDR_LOC_SCROL(1).VENDOR_LOC(1).VNDR_BANK_ACCT(1).BANK_ID_QUAL} (91,34)
Error saving Component Interface. {VNDR_ID_EXCEL}


The issue can be reproduced at will with the following steps:

1. Navigate to Suppliers > Supplier Information > Add Update > Supplier for Supplier ID = 0000000045
2. Check the “Correct History” check box
3. Select the Location tab > Then the click the “Payables” link next to Options
4. Under the Supplier Bank Account Options Bank ID Qualifier ‘005’ only becomes available when the country is GBR    
5. Search for Bank ID Qualifier ‘005’ whilst country = ‘USA’ and no matching values are found.    
6. Change the country code on the Supplier Bank Accounts page to GBR and search again for Bank ID Qualifier = “005” returns the UK back code.
7. Upload Vendor CI template to PUM28 instance with:
    Setid = SHARE
    Supplier ID = 0000000045
    Short Supplier Name = ROBERTHALV
    Supplier Name = Robert Halves
    Entered by = VP1
    Open For Ordering = Y
    Address Sequence Num = 01
    Description = Headquarters
    Address type = BUSN
    Effective Date = 01/01/2000
    Country = USA
    Address ln 1 = 101 Main St
    City = San Francisco
    Supplier Loc =1
    Description = Headquarters
    Effective Date = 01/01/2000
    Sequence = 01
    Bank Acct Seq Nbr = 01
    Bank id qual = 005
    External bank ID = RXE Test
    Bank Account type = 03
    Bank account # = 999999
    DFI Qual = 02
    DFI ID = RXEHSBCtest
    Beneficiary Bank = RXE Test Bank
    Beneficiary Branch = RXE Test Branch
    Country = GBR

Changes

 

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
Changes
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.