E-QR: Error When Scheduling Queries - Error In Opening Query (50, 220)

(Doc ID 2129703.1)

Last updated on MAY 11, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.


On : PeopleTools 8.54 version, Query

Receive the error, "Error in opening query" when attempting to schedule a Query using a run control that is currently associated with a previously "deleted" Query.
The issue can be reproduced with the following steps:
1. Delete a test query which was previously scheduled in the system and associated to a particular run control.
2. Then try and submit a different Query by creating a new run control with the same name as was used to schedule the deleted Query.
3. Observe pop-up error.


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