When Accessing My Team Page, or Any Page that Uses the Select Employee page in Fluid Mode, the Error Displays: "A SQL error occurred" (For SQL Server Databases Only)
Last updated on FEBRUARY 14, 2018
Applies to:PeopleSoft Enterprise HCM eProfile Manager Desktop - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise HCM eCompensation Manager Desktop - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On PeopleSoft HCM 9.2 : eProfile Manager Desktop, Microsoft SQL Server
When accessing the My Team page, or any Manager Self Service transaction that lands in the Select Employee page in Fluid mode, the following errors are received:
A SQL error occurred. Please consult your system log for details.
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
An Application Server log may show the error as follows:
Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the varchar value '....' to data type smallint. (SQLSTATE 22005) 245
Failed SQL stmt: SELECT FILL.SUPERVISOR_ID,FILL.SUPERVISOR_ERN,FILL.EMPLID,FILL.EMPL_RCD,FILL.DR_COUNT FROM PS_HR_DR_CNT5_VW FILL where supervisor_id = :1 and supervisor_ern = :2
1. Manager Self Service Fluid Homepage
2. Select My Team tile
3. Notice the above errors are received.
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