My Oracle Support Banner

EEX 9.2: Fatal PeopleCode SQL Error When Creating Adjustment Cash Advance From Expense Report With Credit Balance (Doc ID 2288712.1)

Last updated on FEBRUARY 21, 2023

Applies to:

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


When a user attempts to create an Adjustment Cash Advance from an expense report with credit balance, a SQL error is displayed.

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

 SQL error in Exec. (2,280) EX_SHEET_HDR.SHEET_ID.SavePostChange PCPC:2703 Statement:18

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

The issue can be reproduced at will with the following steps:

1. Navigate to Employee Self-Service> Travel and Expenses> Expense Reports> Create/Modify
2. Create an expense report with a credit balance
3. Enter the required credit reference
4, From the Actions drop down, choose Adjustment Cash Advance
5. Check the certification box and click OK.
6. Receive the above PeopleCode SQL error

The issue has the following business impact:
Due to this issue, users cannot create adjustment cash advance




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.