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 and later
Information in this document applies to any platform.


On : 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.


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