ESOCIAL: GPBR_ES_PER With Error When Running in SQL Server. (Doc ID 2487801.1)

Last updated on JUNE 18, 2021

Applies to:

Symptoms

Running the program GPBR_ES_PER in SQL Server environment and getting the error:

ERROR
-----------------------
File: e:\pt85605d-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Each GROUP BY expression must contain at least one column that is not an outer reference.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 818

Failed SQL stmt: INSERT INTO PS_GPBR_STG_MISC01( GPBR_DRIVER_SEQ ,GPBR_DRV_SPLIT_SEQ ,EMPLID ,EMPL_RCD ,EMPL_CLASS ,ESTABID ,KEY_SIGN_NUM_01 ,PAYMENT_DT ,PERIOD_BEGIN_DT ,GPBR_PAY_TP ,GPBR_IND_RESBR ,RUN_TYPE ,GPBR_PAYROLL_TP ,GPBR_IDE_DMDEV ,GPBR_PRE_DRV_SEQ ,COUNTRY ,GPBR_IND_BENEF ,GPBR_NIF_BENEF ,ADDRESS1 ,NUM1 ,ADDRESS2 ,ADDRESS3 ,CITY ,POSTAL ,GPBR_NET_ERN_VAL ,GPBR_ES_PERIOD_TP2) SELECT XRF.gpbr_driver_seq , 1 , REC.emplid , REC.empl_rcd , REC.empl_class , REC.estabid , REC.key_sign_num_01 , REC.payment_dt , REC.period_begin_dt , CASE WHEN EMPL.gpbr_event_cd = 'S-2299' AND OVR.CAL_ID IS NULL...
O processo 574945 foi INTERROMPIDO na Etapa GPBR_ES_PER.Map-1210.STG01 (SQL) - RC = 8601 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Changes

Cause

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