ESOCIAL: Event S-2299 With Error in SQL Server.

(Doc ID 2393532.1)

Last updated on MAY 11, 2018

Applies to:

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

Symptoms

Trying to create the XML for event S-2299, but the process does not run with success.
Identified that the problem occurs because of the use of unique Oracle commands but customer uses SQL Server.

ERROR
-----------------------
Process ABENDED at Step GPBR_ES_TERS.Prepare.LoudRetr (Action SQL) -- RC=8601
SQL Error: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Each expression GROUP BY  needs to have at least one column that is not an external reference.



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