EGL 9.2: GLS8510 Ledger Detail Report Report Runs to Error When No Chartfields are specified

(Doc ID 2344784.1)

Last updated on FEBRUARY 06, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ISSUE
---------------

When running GLS8510 (Ledger Details) if you do not specify any chartfields, you will get a warning message stating there are no chartfields selected fro the report.  However, even with no parameters, it does not stop the user from running the report. (When they run it, the message log shows errors) 


ERROR
---------------
SQL Error number ORA-00936 missing expression occurred. Process Request failed. 

STEPS
---------------
The issue can be reproduced with the following steps:
1. Go to Commitment Control > Budget Reports > Ledger Details
2. Run Report using no chartfields 

Please see replication screenshots for more details.

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