EAP: Print Invoice Error Maximum Number Of Records Found Matching Specified Key(s) -- Others Not Included In The Liist (4,2)

(Doc ID 2247802.1)

Last updated on MARCH 24, 2017

Applies to:

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


Error received through Print Invoice. The issue is with the Payment Terms ID Prompt Record, PYMT_TR_EFF_VW, which contians 435 rows. This is more than the Max 300 rows. When this amount is less than or equal to 300, the error does not occur.

Error: Maximum number of records found matching specified key(s) -- others not included in the list (4,2)
When performing a Lookup the database returned more rows than can be accommodated in the list box.
Use a Partial Key value or Advanced Search to limit the number of rows returned or specify more characters to further qualify the key value

1. Go to eSettlements > Self Service Invoice > Print Invoice
2. Select an invoice ID from the list
3. Upon loading of the print invoice, the error appears


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