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 11.1.1.5.0 and laterOracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
Symptoms
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?
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |