EEX9.2:Unable To Delete Expense Report with Zero Amount in Mobile Expenses (Doc ID 1681974.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

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

Symptoms

If an Expense Report is added from Mobile Expenses and then user decides to delete  all the lines in the expense report, the Expense Report will show zero amount. Such an Expense Report cannot be deleted from Mobile Expenses.

If such an Expense Report is opened online in the PIA system , and if we try to delete this Expense Report , a PeopleCode error is displayed.

Issue Replication steps:

1-Create Expense Report from the mobile application.
2- Add one line with $5
3-Delete the 5$ line. Now the Expense Report total will be 0$
4-Notice that we are now unable to delete this Expense Report from the Mobile Expense Application.
5- Open this Expense Report in the PIA and try to delete it

Error:

 When accessing the application to delete the expense report with zero amount error appears :
                         A fatal PeopleCode SQL error occurred. Please consult your system log for details.
                         SQL error in Exec. (2,280) EX_HDR_WRK.DELETE_LBL.SavePreChange PCPC:2671 Statement:26
                         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 related to complete configuration and the replication steps necessary to reproduce the issue.

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