My Oracle Support Banner

Why Is the UTC Time Zone Setting in ODI Studio, Standalone Agent, and J2EE Agent Not Affecting Job Executions that Use the SYSDATE and SYSTIMESTAMP Timezone? (Doc ID 2181153.1)

Last updated on JULY 26, 2023

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


When setting UTC time with ide.conf for Oracle Data Integrator (ODI) Studio or agent configuration files, the ODI log file reflects the UTC time which was set, but the running ODI jobs which are using the database SYSDATE and SYSTIMESTAMP functions do not reflect the UTC time which was set.  Why does this happen?


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.