E-QR: The Heading Text in Query Manager Adds an Extra '=' for a Prompt Field (Doc ID 2123556.1)

Last updated on APRIL 04, 2016

Applies to:

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

Symptoms


When attempting to create a PS Query with prompts the heading text behaves differently - it is displayed with different text depending where is run Query Manager versus Query Viewer.

There is a prompt heading text inconsistency between Query Manager and Query Viewer pages, the "=" sign should not display in the Query Manager page. The prompt heading should reflect the same text. For example, if the user wants to specify a very descriptive text to the prompt values, like 'greater than', the PS Query adds a extra '=' sign that will not reflect the correct prompt meaning that user wanted to specify. It will show as 'greater =' which is not correct.

Steps
-------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Create a new PS Query (e.g. SB_HEADING_TEXT)
4. View Query SQL

SELECT TO_CHAR(A.PAY_END_DT,'YYYY-MM-DD'), A.CONTRACT_NUM, A.ACCT_PLAN_ID
 FROM PS_CA_ACCTG_LN_PC A
 WHERE ( A.PAY_END_DT > :1)

5. Hit Run Tab
The Query Prompt Window shows as 'Pay End Date > Than'
6. After entering the prompt value the query results are displayed in a different page, this time the prompt heading shows as 'Pay End Date > Than = 1900-01-01 '
7. Navigate to Reporting Tools > Query > Query Viewer
The Query Prompt Window shows as 'Pay End Date > Than'

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