EAP: Supplier Search Based On Supplier Short Name Filter Returns irrelevant Data (Doc ID 2060443.1)

Last updated on MARCH 18, 2016

Applies to:

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

Symptoms

Supplier Search based on Supplier short name Filter returns Extra rows, rows that do not satisfy the Filter Criteria

STEPS:
1. Login in French Environment and Create a Supplier, with short name ='TEST'
2. Login in English Environment and Create another Supplier with short name ='TEST1'
3. VENDOR_LANG table has 1 row for the Supplier entered in French Language environment
    VENDOR table has 2 rows, one for each Supplier created above
4. Login in French Environment and navigate to Suppliers > Supplier Information > Add/Update > Supplier and search with Supplier Short Name criteria as '1099'

Search result has Supplier with short name 'TEST' also available

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