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 12.2.1.0.0 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.

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)

Applies to:

Goal

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!