Calculated Field Fails During Save On Activity

(Doc ID 2330383.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.0.2.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.0.2.1 version, Math Engine

Activity screen is running a function with the [SystemDate] as a parameter on a Calculated Field. The screen loads successfully and will display the value on the screen. However when the OK button is pressed, the screen goes white and the following error is thrown - ORA-01722: invalid number.

ERROR
-----------------------
[9/13/17 14:35:24:646 EDT] 000000f3 SystemOut O [EL Warning]: 2017-09-13 14:35:24.626--UnitOfWork(-575306202)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Error Code: 1722
Call: SELECT to_char(?, 'MM/DD/YYYY') FROM DUAL
bind => [2017-05-16]
Query: DataReadQuery(sql="SELECT to_char(?, 'MM/DD/YYYY') FROM DUAL")
[9/13/17 14:35:24:669 EDT] 000000f3 RuntimeExcept E java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Error Code: 1722
Call: SELECT to_char(?, 'MM/DD/YYYY') FROM DUAL
bind => [2017-05-16]
Query: DataReadQuery(sql="SELECT to_char(?, 'MM/DD/YYYY') FROM DUAL")




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.) Configure a transaction with the following:

SystemDate
SystemDate
Date
SELECT to_char('[SystemDate]', 'MM/DD/YYYY') FROM DUAL
Yes

2.) Add the activity to a policy.
3.) Click the OK button
4.) Receive the error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
 Many of the activities are configured to use the [SystemDate] in a function. Cannot add activities to policies where this configuration exists.

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