GP ESP: SQL error in Cret@ Collective Data ESP (Doc ID 2128579.1)

Last updated on APRIL 19, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When it is accessed the component 'Cret@ Collective Data ESP ' and mark a ' Reporting Status ' other than ' All ', an SQL error appears.

ERROR
-----------------------
Error in PeopleCode ScrollSelect processing. (2,213)
GPES_CRT_COL_RES.GBL.DERIVED_GPES.SEARCH_BUTTON.FieldChange PCPC:3419 Statement 33

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
-----------------------
The issue can be reproduced at will with the following steps:
1. access the component ' Cret@ Collective Data ESP'
2. mark a ' Reporting Status ' other than ' All '

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