ETL 9.2: Receiving Error On Load Time & Labor Step In 9.2 (Doc ID 1642486.1)

Last updated on MARCH 03, 2023

Applies to:

Symptoms

 9.2 version, TL Integrations,Receiving below error on Load Time & Labor step in 9.2 . The process is run from PAYROLL FOR NORTH AMERICA>PAYROLL PROCESSING USA>CREATE AND LOAD PAYSHEETS>LOAD TIME AND LABOR . Please advise what need to be done to fix it.

PeopleSoft Payroll -- Version 9.2
Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
 
Load Time & Labor to Payroll started at 10:35:53.66.
 
Application Program Failed
 Action Type : SQL FETCH
 In Pgm Section : SQLRT: DA000-FETCH
 With Return Code: 08603
 Error Message : [Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification (SQLSTATE 22005) 0
 
 
Application Program Failed
 In Pgm Section : FETCH-PAY-CALENDARS(FETCH)
 With Return Code: 08603
 Error Message : [Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification (SQLSTATE 22005) 0

 
Load Time & Labor did not finish at 10:35:53.80 !!!!!

Text from cobol trace:

Connect=HCMDEV1/HCADMIN/?
10:35:53.694 115 0.000 0.000 #3 RC=0 GETSTMT Stmt=PSPLDTL1_S_CAL, length=656
10:35:53.695 116 0.000 0.000 #3 RC=0 COM Stmt=SELECT A.COMPANY ,A.PAYGROUP ,A.AGGR_ID ,A.PAY_BEGIN_DT ,A.PAY_END_DT ,A.PAY_SHEETS_RUN ,A.PAY_CONFIRM_START ,A.PAY_CONFIRM_RUN ,B.EFFDT ,B.EFF_STATUS ,B.PAY_FREQUENCY ,B.COUNTRY ,B.EMPL_TYPE ,B.ERNCD_REG_HRS ,B.ERNCD_OT_HRS ,B.ERNCD_REG_EARNS ,B.ERNCD_HOLIDAY ,B.ERNCD_HOL_NONSTAT ,B.FLSA_REQUIRED ,B.AUTO_PAYSHEET_UPD ,B.CURRENCY_CD ,PAY_OFF_CYCLE_CLS FROM PS_PAY_CALENDAR A ,PS_PAYGROUP_TBL B WHERE A.RUN_ID=:1 AND A.COMPANY=B.COMPANY AND A.PAYGROUP=B.PAYGROUP AND B.EFFDT= (SELECT MAX(C.EFFDT) FROM PS_PAYGROUP_TBL C WHERE B.COMPANY=C.COMPANY AND B.PAYGROUP=C.PAYGROUP AND C.EFFDT<=A.PAY_END_DT) ORDER BY A.COMPANY ASC ,A.PAYGROUP ASC ,A.PAY_END_DT ASC
10:35:53.695 117 0.000 0.000 #3 RC=0 Bind-1, type=SQLPBUF, length=10, value=2014011801
10:35:53.695 118 0.000 0.000 #3 RC=0 SSB column=1, type=SQLPBUF, length=10
10:35:53.695 119 0.000 0.000 #3 RC=0 SSB column=2, type=SQLPBUF, length=10
10:35:53.695 120 0.000 0.000 #3 RC=0 SSB column=3, type=SQLPDTE, length=10
10:35:53.695 121 0.000 0.000 #3 RC=0 SSB column=4, type=SQLPDTE, length=10
10:35:53.695 122 0.000 0.000 #3 RC=0 SSB column=5, type=SQLPBUF, length=1
10:35:53.696 123 0.000 0.000 #3 RC=0 SSB column=6, type=SQLPBUF, length=1
10:35:53.696 124 0.000 0.000 #3 RC=0 SSB column=7, type=SQLPBUF, length=1
10:35:53.696 125 0.000 0.000 #3 RC=0 SSB column=8, type=SQLPDTE, length=10
10:35:53.696 126 0.000 0.000 #3 RC=0 SSB column=9, type=SQLPBUF, length=1
10:35:53.696 127 0.000 0.000 #3 RC=0 SSB column=10, type=SQLPBUF, length=5
10:35:53.696 128 0.000 0.000 #3 RC=0 SSB column=11, type=SQLPBUF, length=3
10:35:53.696 129 0.000 0.000 #3 RC=0 SSB column=12, type=SQLPBUF, length=1
10:35:53.696 130 0.000 0.000 #3 RC=0 SSB column=13, type=SQLPBUF, length=10
10:35:53.696 131 0.000 0.000 #3 RC=0 SSB column=14, type=SQLPBUF, length=10
10:35:53.697 132 0.000 0.000 #3 RC=0 SSB column=15, type=SQLPBUF, length=10
10:35:53.697 133 0.000 0.000 #3 RC=0 SSB column=16, type=SQLPBUF, length=10
10:35:53.697 134 0.000 0.000 #3 RC=0 SSB column=17, type=SQLPBUF, length=10
10:35:53.697 135 0.000 0.000 #3 RC=0 SSB column=18, type=SQLPBUF, length=1
10:35:53.697 136 0.000 0.000 #3 RC=0 SSB column=19, type=SQLPBUF, length=1
10:35:53.697 137 0.000 0.000 #3 RC=0 SSB column=20, type=SQLPBUF, length=3
10:35:53.697 138 0.000 0.000 #3 RC=0 SSB column=21, type=SQLPBUF, length=1
10:35:53.709 139 0.016 0.000 #3 RC=0 EXE
10:35:53.709 140 0.000 0.000 #3 RC=8603 Fetch
10:35:53.763 141 0.046 0.000 #0 RC=8603 ERR rtncd=8603 msg=[Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification (SQLSTATE 22005) 0
10:35:53.777 142 0.016 0.000 #3 RC=0 EPO error pos=0
10:35:53.778 143 0.000 0.000 #3 RC=0 Rollback
10:35:53.779 144 0.000 0.000 #3 RC=0 Disconnect

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.