ODI Variable Refresh Statements For DATE Datatypes Appear To Be Incorrect After Upgrading From ODI 10g To 11g Format Changed On Date Value
(Doc ID 1409867.1)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
After having upgraded from Oracle Data Integrator (ODI) 10g to 11g, ODI Variable refresh statements which return a string with DATE content does not have the same content as in the previous version.
More specifically, in ODI 10g, the following SQL instruction:
returns values in the format:
However, in ODI 11g, the returned values are in the format:
This means that we will be obliged to manually modify all the related Variables.
Why is this occurring and is there a workaround?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!