GP UK - Unable To Generate Payslip For March'16 Calendar (Doc ID 2174036.1)

Last updated on AUGUST 19, 2016

Applies to:

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

Symptoms

The payslip generation process failing with below error:

File: e:\pt85317c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert the value NULL into column 'GPGB_RSLT_VAL_YTD', table 'PSHPRD92.dbo.PS_GPGB_PSLIP_ED_W'; column does not allow nulls. UPDATE fails.
[Microsoft][SQL Server Native Client 11.0][SQL Server]
Failed SQL stmt: UPDATE PS_GPGB_PSLIP_ED_W SET GPGB_RSLT_VAL_YTD = ( SELECT ROUND((B.CALC_RSLT_VAL),(2),1) FROM PS_GP_RSLT_ACUM B ,PS_GP_PIN C WHERE B.EMPLID=PS_GPGB_PSLIP_ED_W.EMPLID AND B.EMPL_RCD=PS_GPGB_PSLIP_ED_W.EMPL_RCD AND B.CAL_RUN_ID='NWPAM 2015M12' AND B.CAL_RUN_ID=PS_GPGB_PSLIP_ED_W.CAL_RUN_ID AND B.GP_PAYGROUP=PS_GPGB_PSLIP_ED_W.GP_PAYGROUP AND B.CAL_ID=PS_GPGB_PSLIP_ED_W.CAL_ID AND B.RSLT_SEG_NUM=PS_GPGB_PSLIP_ED_W.RSLT_SEG_NUM AND B.SLICE_BGN_DT=PS_GPGB_PSLIP_ED_W.SLICE_BGN_DT AND PS_GPGB_PSLIP_ED_W.GPGB_PIN_NUM_YTD=B.PIN_NUM AND PS_GPGB_PSLIP_ED_W.USER_FLD1=B.USER_KEY1 AND PS_GPGB_PSLIP_ED_W.USER_FLD2=B.USER_KEY2 AND PS_GPGB_PSLIP_ED_W.USER_FLD3=B.USER_KEY3 AND C.PIN_NUM=B.PIN_NUM AND B.ACM_THRU_DT >= B.SLICE_END_DT AND C.PIN_CODE IN ('COURT ORDER YTD GBR','COURT FEE YTD GBR') AND B.EMPLID BETWEEN '032701' AND '036220' ) WHERE EXISTS ( SELECT 'X' FROM PS_GP_RSLT_ACUM B ,PS_GP_PIN C WHERE B.EMPLID=PS_GPGB_PSLIP_ED_W.EMPLID AND B.EMPL_RCD=PS_GPGB_PSLIP_ED_W.EMPL_RCD AND B.CAL_RUN_ID='NWPAM 2015M12' AND B.CAL_RUN_ID=PS_GPGB_PSLIP_ED_W.CAL_RUN_ID AND B.GP_PAYGROUP=PS_GPGB_PSLIP_ED_W.GP_PAYGROUP AND B.CAL_ID=PS_GPGB_PSLIP_ED_W.CAL_ID AND B.RSLT_SEG_NUM=PS_GPGB_PSLIP_ED_W.RSLT_SEG_NUM AND B.SLICE_BGN_DT=PS_GPGB_PSLIP_ED_W.SLICE_BGN_DT AND PS_GPGB_PSLIP_ED_W.GPGB_PIN_NUM_YTD=B.PIN_NUM AND PS_GPGB_PSLIP_ED_W.USER_FLD1=B.USER_KEY1 AND PS_GPGB_PSLIP_ED_W.USER_FLD2=B.USER_KEY2 AND PS_GPGB_PSLIP_ED_W.USER_FLD3=B.USER_KEY3 AND C.PIN_NUM=B.PIN_NUM AND B.ACM_THRU_DT >= B.SLICE_END_DT AND C.PIN_CODE IN ('COURT ORDER YTD GBR','COURT FEE YTD

Replication steps
==============
Run GPGB_PSLIP_X

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