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

Last updated on SEPTEMBER 14, 2016

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

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