Bind for the Math Variable Date Format Is Behaving Differently in V10 and V11
Last updated on JUNE 29, 2017
Applies to:Oracle Insurance Policy Administration J2EE - Version 22.214.171.124 and later
Information in this document applies to any platform.
On : 126.96.36.199 version, Activity
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
Million Knowledge Articles and hundreds of Community platforms