Documents Of Record And Regional Date Format Changes Causes Error java.lang.IllegalArgumentException at java.sql.Date.valueOf(Date.java:217) (Doc ID 1599008.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

On Production : 11.5.10.2 version, Documentation

When attempting to update documents of record after changing the date format
from:
MM-dd-yyyy ok
yyyy-MM-dd ok
dd-MM-yyyy ok

yyyy-MMM-dd ok
yyyy.MMM.dd ok
yyyy/MMM/dd ok

dd-MMM-yyyy ok
dd.MMM.yyyy ok
dd/MMM/yyyy ok

to:
MM.dd.yyyy error
MM/dd/yyyy error
yyyy.MM.dd error
yyyy/MM/dd error
dd.MM.yyyy error
dd/MM/yyyy error

the following error occurs.

ERROR
-----------------------
Error Page: You have encountered an unexpected error. Please contact the System Administrator
for assistance.

Click for exception details.



Output error
oracle.apps.fnd.framework.OAException: java.lang.IllegalArgumentException
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.per.selfservice.arch.server.PerOAApplicationModuleImpl.initPersonContext(PerOAApplicationModuleImpl.java:203)
at oracle.apps.per.selfservice.arch.server.PerOAApplicationModuleImpl.initializeWebValuesInternal(PerOAApplicationModuleImpl.java:132)
at oracle.apps.per.dor.server.DocsOfRecordAMImpl.initializeWebValues(DocsOfRecordAMImpl.java:721)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.initializeWebValues(OAWebBeanContainerHelper.java:529)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2170)
...
## Detail 0 ##
java.lang.IllegalArgumentException
at java.sql.Date.valueOf(Date.java:217)
at oracle.jbo.domain.Date.toDate(Date.java:335)
at oracle.jbo.domain.Date.(Date.java:278)
at oracle.apps.per.selfservice.arch.server.PerOAApplicationModuleImpl.initPersonContext(PerOAApplicationModuleImpl.java:196)
at oracle.apps.per.selfservice.arch.server.PerOAApplicationModuleImpl.initializeWebValuesInternal(PerOAApplicationModuleImpl.java:132)
at oracle.apps.per.dor.server.DocsOfRecordAMImpl.initializeWebValues(DocsOfRecordAMImpl.java:721)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into applications
2. From the Home page > Select Preferences > Set the date format preference to any of the following:
MM.dd.yyyy error
MM/dd/yyyy error
yyyy.MM.dd error
yyyy/MM/dd error
dd.MM.yyyy error
dd/MM/yyyy error

3. Navigate to Manager Self Service > Document of Record > Select the update action for an employee who has a document attached
  > Select to view the document and the error occurs


WHAT IS WORKING:
----------------------------
Revert the preference to any of the following to avoid the error:
MM-dd-yyyy ok
yyyy-MM-dd ok
dd-MM-yyyy ok

yyyy-MMM-dd ok
yyyy.MMM.dd ok
yyyy/MMM/dd ok

dd-MMM-yyyy ok
dd.MMM.yyyy ok
dd/MMM/yyyy ok



Changes

 Change the Preferences Date Format

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