EEX9.2: Getting Warning Message "(4,2)" On Approve Transaction Page When More Than 300 SetIds are Present In the System (Doc ID 2078927.1)

Last updated on NOVEMBER 19, 2015

Applies to:

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

Symptoms

If the system has more than 300 SetIds, a warning message is received when an Approver opens the Approve Transaction page.

Steps
The issue can be reproduced at will with the following steps:
1. Make sure there are more than 300 SetIds in the system
2. Create and Submit ER
3. Go to Manager Self Service > Travel and Expense Center > Approvals > Approve Transactions

Actual Result
Getting the following 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 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."

Expected Result
Transactions should be displayed without any warning message.

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps containing the complete configuration and the replication steps necessary to reproduce the issue.

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