EAR9.2: "Sort All" Field from Maintenance Worksheet Gets SQL Errors (Doc ID 2212549.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

When attempting to work the Maintenance Worksheet by setting up "Sort All" field as "Match", the following error occurs:

ERROR
-----------------------
 "A fatal PeopleCode SQL error occurred. Please consult your system log for details." After pressing "Ok", another one is received:

"SQL error in Exec. (2,280) WS_WRK.MAINTWS_GO.SavePostChange PCPC:17191 Statement 22
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. Go to Accounts Receivable / Receivables Maintenance / Maintenance Worksheet/ Create Worksheet / Update Worksheet page and sort the items in the worksheet application by setting "Sort All" field as "Match" option.

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