HRMS Self-Service - Oracle error 1858: java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected has been detected

(Doc ID 2215656.1)

Last updated on DECEMBER 19, 2016

Applies to:

Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, EIT and SIT

When attempting to access person Extra Information records from Employee Self-Service, after changing the date format preferences, the following error occurs:

ERROR
Oracle error 1858: java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected has been detected in ValueSet.isIDValid.


STEPS
The issue can be reproduced at will with the following steps:
1. Access user preferences and change date format to e.g, 'yyyy/MM/dd'
2. Go to Employee Self-Service->Extra Information
3. Above error occurs when attempting to display existing records that contain date fields with custom valueset


Changes

User changed the Date format preferences to value like e.g. 'yyyy/MM/dd'

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