My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.