ODI Integration Interfaces And Mappings Fail With IllegalArgumentException When Binding Oracle Date of Julian Calendar (Doc ID 1985771.1)

Last updated on JUNE 28, 2016

Applies to:

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

Symptoms

The following error is seen in Oracle Data Integrator (ODI) when executing an Interface / Mapping that loads data from Oracle TIMESTAMP into Oracle DATE:

java.lang.IllegalArgumentException
  at sun.util.calendar.ZoneInfo.getOffset(ZoneInfo.java:372)
  at oracle.jdbc.driver.DateCommonBinder.zoneOffset(OraclePreparedStatement.java:24119)
  at oracle.jdbc.driver.DateCommonBinder.setOracleCYMD(OraclePreparedStatement.java:24312)
  at oracle.jdbc.driver.TimestampBinder.bind(OraclePreparedStatement.java:24741)
  at ...

Cause

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 hundreds of Community platforms