Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Message: ORA-01400: cannot insert NULL into ("RELATE"."CST_CUSTOMER"."CUST_ID")

Hi all,

 

I am doing the Oracle fusion integration in talend i.e  from Fusion to Customer Engagement, so while mapping the tables from fusion  to Customer Engagement tables in database level, i'm facing this issue even though i mapped all columns correctly..can anyone help me in this? 

 

Regards

Rak**bleep**a

Labels (2)
3 Replies
Anonymous
Not applicable
Author

Is there any null value for cust_id from source?
Anonymous
Not applicable
Author

but now im getting

 

Message: ORA-00001: unique constraint (RELATE.PK1) violated

 

 

Anonymous
Not applicable
Author

Message is clear. You are trying to insert duplicate value for that field.

Data are being pushed to oracle correctly. Error is due due to data that your are trying to push