My Oracle Support Banner

Table Rows Are Limited to 250 Error When Trying to Retrieve All Records of Workflow Status Using Advanced Search (Doc ID 2026332.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Agile PLM Framework - Version 9.3.1.1 to 9.3.2.0 [Release 9.3]
Oracle Agile Product Collaboration - Version 9.3.1.1 to 9.3.2.0 [Release 9.3]
Information in this document applies to any platform.

Goal

When attempting to search all record of attribute: Workflow Status through Advanced Search window using the "*" on the search field, the following error occurs.

ERROR
Table rows are limited to 250

STEPS
The issue can be reproduced at will with the following steps:
1. Login to Web Client
2. Go to Advanced Search
3. Set the following search criteria

Changes :  (blank)  : Object Search

Attribute              |   Operator    |     Value
----------------------------------------------------------------------
Workflow Status   |   Equal To    |     (blank)     

4. Press the Search To Add button on the Value field of Workflow Status
5. Enter the "*" on the search field and press Execute a Quick Search button

Solution

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
Goal
Solution
References


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