My Oracle Support Banner

E-QAS: QAS_EXECUTEQRYSYNC_OPER Prompt Value is not Being validated for Length Invalid Prompt Value Error Expected but not Occurring (Doc ID 2959726.1)

Last updated on AUGUST 31, 2023

Applies to:

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

Symptoms

QAS_EXECUTEQRYSYNC_OPER web service allows prompt values larger than the Query prompt is defined and does not throw an error even if prompt table is used
 
Expected behavior should look like the following
1) QAS web service to throw error if Prompt value string is longer than number of Prompt's characters.
2) If Prompt table used, error thrown indicating Prompt is an invalid value.
 
 
The issue can be reproduced with the following steps:
1. Create and run a Query with prompt table prompts
2. Use QAS to execute Query
3. Observe invalid prompt values can be used in QAS and still return results
 

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.