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.

Symptoms

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.
 

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