My Oracle Support Banner

ETL9.2: Getting Peoplecode Error Invalid Date In Function AddToDate. (180,113) (Doc ID 2000653.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Time Reporting

When attempting to open timesheet to report time for employee 200024193 empl_rcd #2 they receive the following error:

AddToDate #Parms=4
PSAPPSRV.2688 (2875) 1-2745179 15.38.19 0.000000 ErrorReturn-> 113 - Invalid date in function AddToDate. (180,113) FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Name:DetermineAccess PCPC:21191 Statement:312 Called from:FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Name:LoadEEAttributes Statement:571 Called from:FUNCLIB_TL_WEEK.TR_PCH_GRID_LOAD.FieldFormula Name:PunchGridLoad Statement:30 Called from:FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Name:ExternalTSEntry Statement:150 Called from:TL_MSS_EE_SRCH_PRD.GBL.TL_MGR_SRCH_VW.LAST_NAME.FieldChange Statement:25
PSAPPSRV.2688 (2875) 1-2745180 15.38.19 0.001000 <<< end-ext Nest=03 LoadEEAttributes FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Dur=1.069355 CPU=1.029607 Cycles=3837
PSAPPSRV.2688 (2875) 1-2745181 15.38.19 0.000000 <<< end-ext Nest=02 PunchGridLoad FUNCLIB_TL_WEEK.TR_PCH_GRID_LOAD.FieldFormula Dur=1.330470 CPU=1.294809 Cycles=3892
PSAPPSRV.2688 (2875) 1-2745182 15.38.19 0.000000 <<< end-ext Nest=01 ExternalTSEntry FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Dur=1.442234 CPU=1.404009 Cycles=4018
PSAPPSRV.2688 (2875) 1-2745183 15.38.19 0.000000 <<< end Nest=00 TL_MSS_EE_SRCH_PRD.GBL.TL_MGR_SRCH_VW.LAST_NAME.FieldChange Dur=1.651993 CPU=1.606811 Cycles=4066

The issue can be reproduced at will with the following steps:
1.navigate to Manager Self Service>Time Management>Report Time>Timesheet and search for Employee ID <EMPLID> for current date <DATE>...two records returned...empl rcd 0 and empl rcd 2
2. click on hyperlink for empl rcd 2
3. this is where the error is given about Invalid date in function AddToDate. (180,113)


Due to this issue, users cannot report the time worked for this employee record to be paid.

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.