My Oracle Support Banner

EEX 9.2 : Error in Fluid While Using Split Functionality and Per Diem Expense Type (Doc ID 2538115.1)

Last updated on JANUARY 22, 2020

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Error appears in Fluid while user is trying to use Split functionality by adding Per Diem Expense type


     1.- Create an Expense Report in Fluid and add an Expense with Expense Type LUNCH
     2.- Click on Receipt Split button
     3.- Click on + button and select Per Diem in Expense Type


     " A fatal PeopleCode SQL error occurred. Please consult your system log for details. "

     " Invalid SQLExec update for this type of PeopleCide program.
       EX_SHEET_LINE.EXPENSE_TYPE.FiledChange Name:expense+processing PCPC:26359 Statement:331
       Called from:EX_SHEET_LINE.EXPENSE_TYPE.FieldChange Name:ExpenseTypeFieldChange Statement:463
       Called from:EX_EXP_TYPE_POPUP.MENUITEM1.EXPENSE_TYPE_SEARCH.ItemSelected Statement:29
       SQLExec commands with UPDATE,INSERT, or DELETE statements are only allowed in SavePreChange, SavePostChange, and Workflow type PeopleCode programs. "

To gather more information concerning this scenario and its related problem, refer to the available Replication steps containing the complete configuration and the replication steps necessary to reproduce the issue.


NOTE: In the <images or examples> <above or below> and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.




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.