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

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

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.