EGL: PSQUERY: Prompt Table Set In The Query Is Not Showing Any Prompt Values.
Last updated on JUNE 05, 2018
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.
****Checked for Currency on Sept-2-2013****
****Checked for Currency on Feb-20-2015****
When a query is setup using PS Query using a prompt value on any chartfield table, the prompt does not return values.
Application & Version: Tools 8.51.10
Bundle/Patch: FSCM 9.1
The issue can be reproduced with the following steps:
1. Navigate to Reporting Tools > Query, Query Manager.
2. Search and select a query that uses GL_ACCT_BUGL_VW as a prompt.
3. Run the click on the hourglass for Account. No value returned.
Significance to business operation is major since the issue is with all queries that try to edit prompt with chartfield tables.
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