My Oracle Support Banner

ESOCIAL: GPBR_ES_ILB ERROR IN SQL SERVER. (Doc ID 2539409.1)

Last updated on OCTOBER 09, 2019

Applies to:

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

Symptoms

Error running GPBR_ES_ILB process in SQL Server database:


ERROR
-----------------------
File: e:\pt857p03b_1811162112-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 42000) 818
Failed SQL stmt: INSERT INTO PS_GPBR_BWPL_TAO (PROCESS_INSTANCE, COMPANY, WPLACE_CODE_BRA, WPLACE_LOC_BRA, ESTABID, GPBR_SERVICE_TAKER, TP_INS_TYPE_BRA, TP_INSCR_BRA, GPBR_ES_MAP_DT, GPBR_ACTION, NUMROWS, GPBR_ROW_SEQUENCE, GPBR_ES_PS, GPBR_DRIVER_SEQ) SELECT 280207, B.COMPANY, C.WPLACE_CODE_BRA, C.WPLACE_LOC_BRA, CASE WHEN C.WPLACE_LOC_BRA = '1' THEN D.ESTABID WHEN C.WPLACE_LOC_BRA = '2' THEN E.ESTABID ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '2' THEN E.ID_SRV_TKR_BRA ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '3' THEN F.TP_INS_TYPE_BRA ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '3' THEN F.TP_INSCR_BRA ELSE ' ' END, C.EFFDT, 'ADD', 0, 1, X.GPBR_ES_PS, ROW_NUMBER() OVER (ORDER BY B.COMPANY) FROM PS_GPBR_RCRSLT_T4 A, PS_GPBR_BESE_TAO4 X, PS_COMPANY_TBL_BRA B, PS_WPLACE_TBL_BRA C LEFT OUTER JOIN PS_WPL_ESTAB_BRA D ON D.COMPANY = C.COMPANY AND D.WPLACE_CODE_BRA = C.WPLACE_CODE_BRA AND D.EFFDT = C.EFFDT LEFT OUTER JOIN PS_WPL_SRV_TKR_BRA E ON E.COMPANY = C.COMPANY AND E.WPLACE_CODE_BRA = C.WPLACE_CODE_BRA AND E.EFFDT = C.EFFDT LEFT OUTER JOIN PS_WPL_THIRD_P_BRA F ON F.COMPANY = C.COMPANY AND F.WPLACE_CODE_BRA = C.WPLACE_CODE_BRA AND F.EFFDT = C.EFFDT WHERE X.COMPANY = B.COMPANY AND X.PROCESS_INSTANCE = 280207 AND X.GPBR_EVENT_CD = 'S-1060' AND X.EFF_STATUS = 'A' AND C.COMPANY = B.COMPANY AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_WPLACE_TBL_BRA C1 WHERE C1.COMPANY = C.COMPANY AND C1.WPLACE_LOC_BRA = C.WPLACE_LOC_BRA AND C1.WPLACE_CODE_BRA = C.WPLACE_CODE_BRA AND C1.EFFDT <= X.GPBR_ES_LAST) AND C.EFF_STATUS = 'A' AND EXISTS( SELECT 'X' FROM PS_GPBR_RCRSLT_T4 A WHERE A.PROCESS_INSTANCE = 280207 AND A.OPRID = 'PS' AND A.RUN_CNTL_ID = 'aa' AND A.GPBR_ES_SOURCE = 'ILB' AND A.GPBR_EVNT_STATUS = 'A' AND A.GPBR_EVENT_CD = 'S-1060' AND A.COMPANY = B.COMPANY) AND NOT EXISTS( SELECT 'X' FROM PS_GPBR_DRIVER_DAT GDH , PS_GPBR_DRVWPL_XRF GDX WHERE GDH.GPBR_EVENT_CD = 'S-1060' AND GDX.GPBR_DRIVER_SEQ = GDH.GPBR_DRIVER_SEQ AND GDX.WPLACE_LOC_BRA = C.WPLACE_LOC_BRA AND GDX.WPLACE_CODE_BRA = C.WPLACE_CODE_BRA AND ((C.WPLACE_LOC_BRA = '1' AND GDX.ESTABID = D.ESTABID AND GDX.GPBR_SERVICE_TAKER = ' ' AND GDX.TP_INS_TYPE_BRA = ' ' AND GDX.TP_INSCR_BRA = ' ') OR (C.WPLACE_LOC_BRA = '2' AND GDX.ESTABID = E.ESTABID AND GDX.GPBR_SERVICE_TAKER = E.ID_SRV_TKR_BRA AND GDX.TP_INS_TYPE_BRA = ' ' AND GDX.TP_INSCR_BRA = ' ') OR (C.WPLACE_LOC_BRA = '3' AND GDX.ESTABID = ' ' AND GDX.GPBR_SERVICE_TAKER = ' ' AND GDX.TP_INS_TYPE_BRA = F.TP_INS_TYPE_BRA AND GDX.TP_INSCR_BRA = F.TP_INSCR_BRA)) AND GDH.GPBR_ES_MAP_DT = C.EFFDT) GROUP BY 280207, B.COMPANY, C.WPLACE_CODE_BRA, C.WPLACE_LOC_BRA, CASE WHEN C.WPLACE_LOC_BRA = '1' THEN D.ESTABID WHEN C.WPLACE_LOC_BRA = '2' THEN E.ESTABID ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '2' THEN E.ID_SRV_TKR_BRA ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '3' THEN F.TP_INS_TYPE_BRA ELSE ' ' END, CASE WHEN C.WPLACE_LOC_BRA = '3' THEN F.TP_INSCR_BRA ELSE ' ' END, C.EFFDT, X.GPBR_ES_PS

Process 280207 ABENDED at Step GPBR_ES_BLD.LoadBWPL.Step01 (SQL) -- RC = 8601 (108,524)

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

PSAESRV completed service request at 07.30.05 2019-03-29


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!


In this Document
Symptoms
Cause
Solution
References


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