GPES: When Clicking The "Search" Button On The "Review FIE File ESP" Page, the Error Occurs: "Error in PeopleCode ScrollSelect processing. (2,213)"
(Doc ID 2999494.1)
Last updated on JANUARY 23, 2024
Applies to:
PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
When clicking on the the "Search" Button on the "Review FIE File ESP" page, the following error messages are displayed:
A SQL error ocurred. Please consult your system log for details.
Error in PeopleCode ScrollSelect processing. (2,213) GPES_FIE_REVIEW.GBL.GPES_FIE_WRK.SRCH_BTN.FieldChange PCPC:7035 Statement:102
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.
A SQL error occurred during processing of the PeopleCode ScrollSelect (or ScrollSelectNew, RowScrollSelect, RowScrollSelectNew) built-in function.
This error may have been described by a preceding message.
Examine the error messages and the PeopleCode program containing the ScrollSelect call to determine the cause of the error.
Steps to replicate the issue:
1. Navigate to Global Payroll & Absence Mgmt > Social Security / Insurance > Review FIE File ESP
Choose an Authorization Key and fill out the relevant information and click on Search, the above Error Messages are displayed
Changes
The Error started occurring after the Patch 5529264 - TAX UPD 2023 - LOAD ABSENCE EVENTS AUTOMATICALLY FROM FIE FILE has been applied.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |