My Oracle Support Banner

Getting Error:"This Query Is Not Allowed Because It Would Return All Rows"after Submit Request (Doc ID 2724060.1)

Last updated on SEPTEMBER 12, 2021

Applies to:

Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Request Processing



Get the below error after submitting a concurrent request.


ERROR
-----------------------

"This query is not allowed because it would return all rows"






STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to [View] -> [Request]
2. On form [Find Requests] select [Specific Requests] then select Phase [Completed] -> Click [Find]
3. On form [Request] -> Click [Submit a New Request]
4. On form [Submit Request] -> select a concurrent request and click [Submit]
5. On form [Decision] -> Select [No]
Actual Result: Display the error


Changes

 

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
Changes
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.