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) (Doc ID 2212188.1)

Last updated on MAY 09, 2017

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.

Symptoms

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



REPLICATION STEPS:

1. Manager Self Service Fluid Homepage
2. Select My Team tile
3. Notice the above errors are received.

Changes

 

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