My Oracle Support Banner

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 OCTOBER 25, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version 1.0.2 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:

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.