EGL 9.2: GLS8510 Ledger Detail Report Report Runs to Error When No Chartfields are specified
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.
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