My Oracle Support Banner

Query Has Exceeded 200 Rows (Doc ID 386402.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Configurator Developer - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to create a large design chart (rule type) with more than 200 rows,
the following error occurs.

ERROR
Warning
1. Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.
2. Rule validated successfully

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility : Oracle Configurator Developer
2. Navigate: Workbench: Rules > Edit Design Chart: Create a 13x36 design chart (rule type)
3. Receive Warning
Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.

Cause

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
Symptoms
Cause
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.