ETL9.0: User getting Fatal SQL error 'SQL error in DescribeCol. (2,279)' accessing Timesheets in Timekeeper (Doc ID 1518499.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9 and later
Information in this document applies to any platform.
Reviewed on Feb 11th, 2013

Symptoms

On :  9 version, Time Administration

Users are getting a Fatal SQL error accessing Timesheets in Timekeeper , bundle #19.

Unable to access Timesheets in Timekeeper application.  User clicks on Timesheets link through PIA and recieves a SQL error.  This is not happening for all users but a majority.

ERROR
-----------------------
A fatal peoplecode sql error occurred.
Click OK

SQL error in DescribeCol. (2,279)
TL_COMMONEmployeeList.GetEmployees.OnExecute Name: EmployeeList
PCPC:1759 Statement 57


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to MSS> time management> report time> timesheet
2. click on the link the above fatal sql error occurred.

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

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