EEX9.1: Fatal SQL Error While Creating Expense Report With Expense - Issue with Tools 8.51 and Below Only

(Doc ID 1550432.1)

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