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
Million Knowledge Articles and hundreds of Community platforms