ETL9.0: Fatal PeopleCode SQL Error - Timesheet - After Applying HRMS Bundle # 25 (Doc ID 1914267.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

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

Symptoms

HRMS 9.0 Bundle 25 - DB2 environment

User is getting a Fatal PeopleCode SQL error when trying to access a Timesheet. This issue started to occur after Bundle 25 was applied in their environment. The issue appears to be DB2 specific.

Error:
SQL.error in DescribedCol.(2,279)FUNCLIB_TL_WEEK.TR_WEEK_INIT_FUNC.FIELDFORMULA.


Steps to Recreate:
Navigation: Manager Self Service, Time Management, Report time, Timesheet.

Business Impact:
DB2 customer is unable to open Timesheet page after applying Bundle 25.

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