Payroll Runs To No Success When Calculating Payroll With Group List
Last updated on FEBRUARY 21, 2018
Applies to:
PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.2 version, COBOL
Payroll Runs to No Success when calculating Payroll for a Group
ERROR
-----------------------
Error Message : [Microsoft][SQL Server Native Client 11.0][SQL Server]The correlation name 'G' is specified multiple times in a FROM clause.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Stored Stmt : GPPTLGPI_S_TLTIME1
SQL Statement : SELECT A.SRC_CAL_RUN_ID ,A.EMPLID ,A.EMPL_RCD ,A.PRC_ORD_TS
,A.PIN_NUM ,D.DUR ,D.SEQ_NBR ,A.GP_PAYGROUP ,A.CAL_ID ,D.ORI
G_SEQ_NBR ,A.TRC_TYPE ,A.CURRENCY_CD ,D.CURRENCY_CD ,A.RATE
,D.OVERRIDE_RATE ,D.COMP_RATECD ,D.TL_QUANTITY ,A.PRD_TYPE ,
B.PI_VER_NUM ,F.PIN_NUM ,A.TL_PRD_BGN_DT ,A.TL_PRD_END_DT ,D
.ACCT_CD ,D.BUSINESS_UNIT ,D.COMPANY ,D.COUNTRY ,D.DEPTID ,D
.JOBCODE ,D.LOCATION ,D.PRODUCT ,D.STATE ,D.TASK ,D.USER_FIE
LD_1 ,D.USER_FIELD_2 ,D.USER_FIELD_3 ,D.USER_FIELD_4 ,D.USER
_FIELD_5 ,D.SETID_DEPT ,D.SETID_JOBCODE ,D.SETID_LOCATION ,D
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run GPPDPRUN with grouplist, Observe the error generated
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