My Oracle Support Banner

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 JULY 04, 2023

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for Currency on 03-July-2023 ***


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.