My Oracle Support Banner

"Invalid Character Value For Cast Specification" error on FMLA Leave Request Page after Tools Upgrade (Doc ID 2540034.1)

Last updated on FEBRUARY 05, 2021

Applies to:

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

Symptoms

After upgrading from Tools 8.53.10 to Tools 8.57.07, a user is trying to enter a new FMLA Leave and gets a SQL error below:


peopletools\src\pssys\wamupd.cppSQL error. Stmt #: 401  Error Position: 0  Return: 8602 - [Microsoft][SQL Server Native Client 11.0]Invalid character value for cast specification (SQLSTATE 22018) 0
Failed SQL stmt: SELECT PTPN_PRIORITY, PTPN_ENABLE, MESSAGE_NBR, MESSAGE_NBR01, MESSAGE_NBR02, MESSAGE_NBR03 FROM PS_PTPN_TBE_CFG_2 WHERE PTPN_BUSPROCNAME = :1 and PTPN_ACTIVITYNAME = :2 and PTPN_EVENTNAME1 = :3 and PTPN_WORKLISTNAME = :4

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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