My Oracle Support Banner

EEX 9.2: Adjustment Cash Advance Does Not Go To Paid Status When Applied Against Expense Report In Peopletools 8.55 (Doc ID 2292491.1)

Last updated on JULY 21, 2020

Applies to:

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


After applying tools 8.55, an adjustment cash advance does not go to paid status when applied against expense report .

It goes in PENDING status which is causing a failed insert statement into PS_EX_SHEET_ADV table.



1. Create and expense report.
2. Add a transaction with a credit amount.
3. In the Action box select Adjustment Cash Advance.
4. Click OK button


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.


Please see the replication steps document for more details.

NOTE: In 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.