Four Stars

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

3 REPLIES
Eight Stars

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

Is there any null value for cust_id from source?
Four Stars

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

but now im getting

 

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

 

 

Eight Stars

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

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