EGL9.2: Upon Using Journal ID as Filter Refine Crieteria for GL WorkCenter Budget Journal Exceptions Link, Getting "SQL error in Exec." Error
(Doc ID 2618932.1)
Last updated on JUNE 01, 2020
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Upon using Journal ID as filter refine criteria to GL forrkCenter Budget Journal Exceptions link getting below error:
Steps to replicate:
1. Navigate to the GL WorkCenter and click on the Budget Journal Exceptions link and click on the Refine Filters icon.
2. Enter a Journal ID into the Search and click done. Receive error: 'A fatal PeopleCode SQL error occurred. Please consult your system log for details'
SQL error in Exec.
FS_FILTER_BUILDER.Configuration.Values.OnExecute Name:DoSaveEdit PCPC:27055 Statement:420
Called from:EOWC_EDITVIEWVA_FL.GBL.EOWC_VIEWBY_VAL.SaveEdit Statement:2
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document