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 12.2.1.4.200413 and later
Oracle Data Integrator - Version 12.2.1.4.200413 and later
Information in this document applies to any platform.

Symptoms

After migrating from Oracle Data Integrator (ODI) 11g to 12.2.1.4, 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.

Changes

 

Cause

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.