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!

ODI-40469: Value was incorrect for column 31: "value" is not a valid representation for a Number

3173245Apr 13 2017 — edited Aug 10 2017

Hi Experts ,

While loading data from TXT file to ORACLE, ODI job is failing and .BAD and .ERROR file is created.

.ERROR file:

Line 176783: ODI-40469: Value was incorrect for column 31: String 001-105 Orville, NY is not a valid representation for a Number

Line 176783: ODI-40469: Value was incorrect for column 45: String CLOSED is not a valid representation for a Number

Line 176783: ODI-40469: Value was incorrect for column 66: String 03/23/2015 is not a valid representation for a Number

ORACLE datatypes of this columns are VARCHAR2 ,VARCHAR2 ,DATE but not sure why its showing like "not a valid representation for a Number"

Thanks

This post has been answered by 3173245 on Aug 10 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2017

Added on Apr 13 2017

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

27 comments

2,548 views