My Oracle Support Banner

After Upgrade to ODI 12c, Mapping Execution Fails with "ORA-01843: not a valid month" when Loading Data from DB2 with TIME Datatype (Doc ID 2709014.1)

Last updated on FEBRUARY 16, 2023

Applies to:

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


After migrating from Oracle Data Integrator (ODI) 11g to, an upgraded mapping which is moving data from DB2 to Oracle fails to execute with the following error:

The upgraded interface executed without issues in ODI 11g.




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.