ETL9.1 On SQL Server TimeSheet gets Fatal SQL Error FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula After Bundle 19

(Doc ID 2058431.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

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

Symptoms

On : 9.1 version, Technical
SQL Server

Fatal SQL error in timesheet page after Bundle 19

Fatal SQL error in time sheet page after Bundle 19. Screenshot attached. Uses TO_DATE built in function instead of %Datein, in a SQLExec.Think it is an Oracle function. We are on Microsoft SQL server 2012.

ERROR
-----------------------
SQL error in DescribeCol. (2,279)
FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula Name:ManageCommentsLinks
PCPC:27543 Statement:376
Called from:FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FieldFormula
Name:UpdateStatusGrid Statement:538
Called from:FUNCLIB_TL_WEEK.TR_ELP_GRID_LOAD.FieldFormula
Name:ElapsedGridLoad Statement:384
Called from:TL_MSS_EE_SRCH_PRD.GBL.DERIVED_ETEO.SAVE_PB.FieldChange
Statement:7


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. On SQL Server enter timesheet
2. Submit
3. Click on ok
4. It gives Fatal Peoplecode error. SQL error in DescribeCol. (2,279)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use timesheet at all.

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