ODI Variable Refresh Statements For DATE Datatypes Appear To Be Incorrect After Upgrading From ODI 10g To 11g Format Changed On Date Value
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Data Integrator - Version 220.127.116.11.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?
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