"Numeric value out of range" SQL Error on Performance Tile of Employee Self Service on the Fluid Home Page. (Doc ID 2181769.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

PeopleSoft Enterprise HCM ePerformance - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Appraisal ID's(EP_APPRAISAL_ID) > 999 and landing on the Employee Self Service in Fluid Mode, the Performance title has following error message on it.

ERROR
-----------------------
[Microsoft][ODBC Driver 11 for SQL Server]Numeric value out of range
[Microsoft][ODBC Driver 11 for SQL Server]Numeric value out of range
Failed SQL stmt: SELECT EMPLID, EMPL_RCD, EP_APPRAISAL_ID, PERIOD_BEGIN_DT, (CONVERT(CHAR(10),PERIOD_BEGIN_DT,121)), PERIOD_END_DT, (CONVERT(CHAR(10),PERIOD_END_DT,121)), EP_REVIEW_TYPE, EP_TEMPLATE_ID, (CONVERT(CHAR(10),EP_TMPL_EFFDT,121)), EP_REVIEW_STATUS, EP_APPROVAL_STATUS, EP_EE_REVIEW_FLG, EP_EMPL_ACK_IND, (CONVERT(CHAR(10),EP_EMPL_ACK_DT,121)), RATING_MODEL, REVIEW_RATING, EP_PRE_REVW_RATING, EP_MANAGER_ID, EP_EE_FIRST_NAME, EP_EE_LAST_NAME, EP_EVALUATEE_NAME, EP_MGR_FIRST_NAME, EP_MGR_LAST_NAME, EP_MANAGER_NAME, EP_DOC_USAGE_IND FROM PS_EP_APPR_SEL2_VW ORDER BY EMPLID
PSAPPSRV.3200 (697) [2016-06-01T11:47:42.240 PS@SAP7002811A (FIREFOX 46.0; WIN7) ICPanel](0) An error has occurred which prevents this transaction continuing
PSAPPSRV.3200 (714) [2016-06-01T11:49:31.080 GetCertificate](3) Returning context. ID=PS, Lang=ENG, UStreamId=114931080_3200.714, Token=PSFT_HR/2016-06-01-04.49.31.999115/PS/ENG/WJMzJccMIdoSTAAtIUviVODLQu4=

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login in to Application
2. Home Page>Employee Self Service>Performance tile, SQL Error triggers.

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