My Oracle Support Banner

CRM Self Service - Case Component Giving Too Many Rows Error (Doc ID 2619252.1)

Last updated on DECEMBER 16, 2019

Applies to:

PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Case Component

Self Service - Case Component giving too many rows error

There are over 4000 rows of product data (PROD_ITEM table) entries in the system which are recently uploaded. However system is now giving error about having too many rows in self-service create cage page.
There is a self service product item view that does not have a limit on the number of rows it is displaying for the Product Dropdown within the self service case page.

The following error occurs when accessing the Self service Create Case page:

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.

The issue can be reproduced at will with the following steps:
1. Log in as SS user
2. Create case




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.