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 JULY 20, 2017

Applies to:

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

Symptoms

On : 9.2 version, Cash Advances

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

ERROR
-----------------------
"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.


STEPS
-----------------------
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

Please see replication steps document for more details.


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

Cause

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