My Oracle Support Banner

EAM 9.2: When Accessing the Administrator Extended Absence Page GP_ABS_EA_ADM, the Following SQL Error/SQL Injection Occurs : "A SQL error occurred, please consult your system log for details." "Error in PeopleCode ScrollSelect processing. (2,213)" (Doc ID 2890690.1)

Last updated on AUGUST 23, 2022

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


While accessing the Administer Extended Absence Page (GP_ABS_EA_ADM) and by entering a Character in the Employee ID Search Field, the following Error is thrown:

Steps to replicate the issue:
   1. Login as an Administrator and 
       Navigate to Main Menu>Global Payroll and Absence Management>Payee Data>Maintain Absences>Administer Extended Absence or
       Workforce Administrator Fluid Homepage, choose Absence Administration Tile, Administer Extended Absence Tile
   2. Filter the Search Criteria by Show Requests by Status: Pending and in the Employee ID Search Field, enter an apostrophe ( ' ).
   3. The Error message above is thrown after clicking on Search




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.