PIM: Item Transaction Tab Throwing Warning message When Performing A Search, Query has exceeded 200 rows. Potentially More Rows Exists, Please Restrict your Query.

(Doc ID 2305989.1)

Last updated on SEPTEMBER 10, 2017

Applies to:

Oracle Product Hub - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Catalog items

ACTUAL BEHAVIOR
---------------
Getting below message even when there is only one search result

Warning
1.Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.
2.Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.

EXPECTED BEHAVIOR
-----------------------
Need to understand is this correct behaviour

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) PIM > Search an Item and open it
2) Then click on the transaction tab from top menu.
3) Now click on more And search for a serial number And click on Go.

Where only one row is fetched and get the warning message showing more than 200 rows exist.

Message :

Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.

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