ETL8.9: Invalid Date. (180,112) FUNCLIB_TL_WEEK.TR_ELP_GRID_LOAD.FieldFormula (Doc ID 1177492.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 8.9 and later
Information in this document applies to any platform.

Symptoms

  When attempting to access timesheet from search page,
the following AWE error occurs.

ERROR
-----------------------
Invalid Date. (180,112) FUNCLIB_TL_WEEK.TR_ELP_GRID_LOAD.FieldFormula Name:ElapsedGridLoad PCPC: 1143 Statement: 28
Called from: TL_MSS_EE_SRCH_PRD.GBL.TL_MGR_SRCH_VW.NAME.FieldChange Statement 61

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. The users navigate to the Approve Reported Time Summary page (TL_MSS_TIMESHEET). Using the default view by ‘Day’ and the current date, they enter a value for EmplID, press ‘Get Employees’, and get the message displayed ‘There were no employees found with Reported Time to approve based upon your selection criteria’.
2. Realizing that the employee has unapproved reported time in the future, they change the view by to ‘All Time After’ and press ‘Refresh’. The employee is displayed and our users click on the name.
The system takes them to the Timesheet page (TL_RPTD_ELP) where, for this exception time reporter, their timesheet is displayed for the month.
3. From this page, users then select the hyperlink to ‘Return to Select Employee’. They are returned to the Approve Reported Time Summary page (TL_MSS_TIMESHEET).
4. They change the view by to ‘All Time Before’ and without refreshing their user name click on the name. It is at this point that the users incur the error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users get an error and Customer believes it should be programming in place to safeguard from incurring this PeopleCode 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