Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01843: not a valid month

Ralph HAug 22 2018 — edited Aug 30 2018

I have a simple ODI mapping to move date from Table to Table where the source is Microsoft SQL Server and the target is Oracle. On the Source the date column is defined as datetime and on the target, date.

when I run the mapping I get ORA-01843: not a valid month. All the rows have valid dates.

I have other ODI mappings that source data from another Microsoft SQL Server source and they work without any error or having to resolve to changing the source column to CHAR and then using a TO_DATE function. How can I further debug this ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2018

Added on Aug 22 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

27 comments

3,747 views