My Oracle Support Banner

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.



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) 

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

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.


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.