E-QR: "Values for Tree Prompts are missing" Error For Copied Query Scheduled With IN-TREE Criteria

(Doc ID 2342127.1)

Last updated on MARCH 14, 2018

Applies to:

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

Symptoms

On : PeopleTools 8.55.08 version, Query


Copied Query containing IN-TREE criteria cannot be scheduled via Schedule Query due to the following error message. However, the same Query runs fine via online Query Manager or Query Viewer.
 
ERROR
---------------
"Values for Tree Prompts are missing. Tree prompt values needs to be updated. "
 
Replication
---------------
The issue can be reproduced with the following steps:
1. Submit affected Query via Schedule Query
2. Monitor to completion via Process Monitor online tool
3. Observe reported error in message log content
 

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