EAP: VOUCHER PAY GROUP MAXIMUM NUMBER OF RECORDS FOUND MATCHING SPECIFIED KEYS (Doc ID 1930056.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Upgrading from 8.9 to 9.2 Environment contains over 600 Vendor Pay Groups. Receive a Warning Message when adding a new Voucher or opening an existing Voucher and going to the Payments page. Users cannot add Vouchers correctly, because they do not get a list of all the available Pay Group (PYMNT_GROUP_CD) values through the Voucher Payments page.

This works fine in release 8.9. It appears there was code added to the VCHR_EXPRESS Component for 9.2. Page Name: VCHR_PAYMENT_PNL > Record = PYMNT_VCHR_XREF > Field: PYMNT_GROUP_CD Prompt Table Edit > Prompt Table = VNDR_PAYGRP_TBL

Message:
Maximum number of records found matching specified key(s)--others not included in list (4,2)
When performing a Lookup, the database returned more rows than can be accommodated

Steps:
1. Set Up Financials/Supply Chain Product Related Procurement Options Vendors Vendor Pay Group Codes > 600 existing values for one SetID
2. Accounts Payable > Vouchers > Add/Update > Regular Entry > Find an Existing Value > enter Business Unit and Voucher ID value > click Search icon > go to Payments page
3. Warning Message: Maximum number of records found matching specified key(s)--others not included in list (4,2)
When performing a Lookup, the database returned more rows than can be accommodated
  a. Users are not able to see a list of all the available Pay Groups


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