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 OCTOBER 01, 2024

Applies to:

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

Goal

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?
 

Solution

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.