GPESP: GPES_SS_CRA Ends With Error SQL.FETCH OBJECT ISN'T OPEN ON A SELECT
(Doc ID 2437096.1)
Last updated on JULY 21, 2020
Applies to:PeopleSoft Enterprise HCM Global Payroll Spain - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Legislative
GPES_SS_CRA engine, sometimes ends with a "sql.fetch object isn't open on a select" error.
It was found that it happens with this two specific sqls: &SQL_CRA_RPT_RetroPeriods and &SQL_SEV_NOTIN_RETRO_EEs, and the reason is because they are created in the main engine code, and the fetch instructions were inside functions, and the found the sql's closed
The issue can be reproduced at will with the following steps:
1. running GPES_SS_CRA
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