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 21, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.