Bind for the Math Variable Date Format Is Behaving Differently in V10 and V11

(Doc ID 2282175.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

On :  11.0.1.0 version, Activity

Problem Description
A MathVariable date handling inconsistency exists between v10.2.0 and v11.0.1.
In v10, the ToText function would convert a date value to a string and the result would be MM/DD/YYYY format.
In v11, the ToText function is converting the date value to a string and the result is in YYYY-MM-DD format.
The lack of consistency caused problems when these values are passed to database functions or downstream systems that are expecting MM/DD/YYYY.

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