My Oracle Support Banner

EPY: When Pay Calculation Run, Receive error in PSPEARRY_S_JOB "ORA-01841: (full) Year Must Be Between -4713 And +9999, And Not Be 0" (Doc ID 2602226.1)

Last updated on NOVEMBER 14, 2019

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information in this document applies to any platform.

Symptoms


When running an On-cycle Pay calculation, the Pay Calculation log shows the below error message 

ERROR
-------------
Application Program Failed
 Action Type : SQL SELECT
 In Pgm Section : SQLRT: EXECUTE-STMT
 With Return Code: 01841
 Error Message : ORA-01841: (full) year must be between -4713 and +9999, and not be 0
 Stored Stmt : PSPEARRY_S_JOB
 SQL Statement : SELECT A.PAGE_NUM ,A.LINE_NUM ,A.SEPCHK ,A.BENEFIT_RCD_NBR ,
  A.DED_TAKEN ,A.DED_SUBSET_ID ,A.DED_TAKEN_GENL ,A.DED_SUBSET_GENL ,
  C.PER_ORG ,C.EMPL_TYPE ,C.LOCATION ,C.EMPLID ,C.STD_HOURS ,C.EMPL_STATUS ,
  C.DEPTID ,C.COMP_FREQUENCY ,C.BUSINESS_UNIT ,C.SETID_DEPT ,
  C.SETID_JOBCODE ,C.COMPRATE ,F.NAME ,D.SEX ,D.BIRTHDATE ,
  C.ANNL_BENEF_BASE_RT ,C.SHIFT_RT ,C.SHIFT_FACTOR ,C.FLSA_STATUS ,
  C.DIRECTLY_TIPPED ,C.SAL_ADMIN_PLAN ,Q.FREQUENCY_TYPE ,
  Q.FREQ_ANNUAL_FACTOR ,Q.EFF_STATUS ,C.STD_HRS_FREQUENCY ,
  S.FREQ_ANNUAL_FACTOR ,S.EFF_STATUS ,C.POI_TYPE  ,C.BENEFIT_SYSTEM ,
  A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.OFF_CYCLE
  FROM PS_PAY_EARNINGS A ,PS_JOB C ,PS_PERSONAL_DT_FST D ,PS_NAMES F ,
  PS_PER_ORG_ASGN K ,PS_FREQUENCY_TBL Q ,PS_FREQUENCY_TBL S
  WHERE A.COMPANY=:1 AND A.PAYGROUP=:2 AND A.PAY_END_DT=:3
  AND A.OFF_CYCLE=:4 AND A.SINGLE_CHECK_USE IN ('N','C') AND A.OK_TO_PAY='Y'
  AND A.PAY_LINE_STATUS IN ('I', 'P', 'U') AND A.EMPLID=C.EMPLID
  AND A.EMPL_RCD=C.EMPL_RCD AND A.EMPLID=D.EMPLID AND A.EMPLID=F.EMPLID
  AND C.EFFDT= (SELECT MAX(G.EFFDT) FROM PS_JOB G WHERE G.EMPLID=C.EMPLID
  AND G.EMPL_RCD=C.EMPL_RCD AND G.COMPANY=A.COMPANY AND G.EFFDT<=:5)
  AND C.EFFSEQ= (SELECT MAX(H.EFFSEQ) FROM PS_JOB H WHERE H.EMPLID=C.EMPLID
  AND H.EMPL_RCD=C.EMPL_RCD AND H.COMPANY=A.COMPANY AND H.EFFDT=C.EFFDT) 
  AND F.NAME_TYPE = 'PRI' AND F.EFFDT=(SELECT MAX(V.EFFDT) FROM PS_NAMES V 
  WHERE F.EMPLID=V.EMPLID AND F.NAME_TYPE = V.NAME_TYPE AND V.EFFDT<=:6 ) 
  AND A.EMPL
ID=K.EMPLID AND A.EMPL_RCD=K.EMPL_RCD 
  AND K.SERVICE_DT IS NO
T NULL AND Q.FREQUENCY_ID=C.COMP_FREQUENCY 
  AND Q.EFFDT= (SEL
ECT MAX(R.EFFDT) FROM PS_FREQUENCY_TBL R 
  WHERE R.FREQUENCY_I
D=C.COMP_FREQUENCY AND R.EFFDT<=:7 ) 
  AND S.FREQUENCY_ID=C.ST
D_HRS_FREQUENCY AND S.EFFDT= (SELECT MAX(T.EFFDT) 
  FROM PS_FR
EQUENCY_TBL T WHERE T.FREQUENCY_ID=C.STD_HRS_FREQUENCY 
  AND T
.EFFDT<=:8 ) 
  ORDER BY A.COMPANY ASC ,A.PAYGROUP ASC ,A.PAY_E
ND_DT ASC ,A.OFF_CYCLE ASC ,
  A.PAGE_NUM ASC ,A.LINE_NUM ASC ,
 A.SEPCHK ASC



Changes

 Tax Update was applied

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
Changes
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.