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 APRIL 08, 2024

Applies to:

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

Symptoms

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 ( ' ) OR enter a "From" and Through" last name.
   3. The Error message above is thrown after clicking on Search

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.