My Oracle Support Banner

EGL: PSQUERY: Prompt Table Set In The Query Is Not Showing Any Prompt Values. (Doc ID 1388422.1)

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****

Symptoms

ISSUE STATEMENT
---------------
When a query is setup using  PS Query using a prompt value on any chartfield table, the prompt does not return values.
 

ENVIRONMENT
---------------
Application & Version: Tools 8.51.10
Bundle/Patch: FSCM 9.1
Environment: Production
 
STEPS
---------------
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.
 
IMPACT
---------------
Significance to business operation is major since the issue is with all queries that try to edit prompt with chartfield tables.

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.