ETL9.2: Fatal SQL Error (180,112) On "Elapsed Timesheet" Link From Request Absence Page. (Doc ID 2046691.1)

Last updated on AUGUST 21, 2015

Applies to:

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

Symptoms

After clicking on Absence Request from timesheet and then click on Elapsed Timesheet link to return to timesheet, it throws peoplecode error -

Invalid date. (180,112) FUNCLIB_TL_WEEK.TR_ELP_GRID_LOAD.FieldFormula
Name:FormatDateStrings  PCPC:247  Statement:5
Called from:TL_RPTD_ELP.Activate  Statement:4
An invalid date has been encountered in a PeopleCode program.
Review the PeopleCode program to determine the cause of the error

STEPS
-----------------------
1. Navigate to MSS>Time Management>Report Time>Timesheet
2. Click on any name to get to the detail timesheet of the employee
3. Once on the timesheet detail page, click on the Request Absence link
4. On the Request Absence page, click on the Elapsed Timesheet link on the
grid to return to timesheet and it would trigger the Invalid date. (180,112) error

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