EEX9.1: Fatal SQL Error While Creating Expense Report With Expense - Issue with Tools 8.51 and Below Only
Last updated on JULY 05, 2016
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
When attempting to save or submit the expense report which have transaction date in past, the following error occurs:
Fatal SQL error occurred. (2,125) FUNCLIB_EX.MERCHANT_CD.FieldFormula Name:UpdatePreferredMerchantDropDownList PCPC:335 Statement:6
Called from:EX.SheetValidation.ExpenseLine.OnExecute Name:Validate_Field Statement:356
Called from:EX.SheetValidation.ExpenseLine.OnExecute Name:Validate_Line Statement:861
Called from:EX_HDR_WRK.PB_SUBMIT.FieldChange Statement:163
A SQL error has occurred, review the SQL to determine the cause of the error.
Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed
1. Create an expense report
2. Enter all the required fields and ensure that transaction date is a past date.
3. Save or submit the expense report.
Please see replication steps document 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