Skip to main content

Hello,

I try to upload Purchase Order lines. As there is no particular notes, I let empty the Note_id field.

This brings the following error : 

ORA-01400: cannot insert NULL into ("IFSAPP"."PURCHASE_ORDER_LINE_TAB"."NOTE_ID")

Any idea about how to avoid such error ?

Thanks in avance

@mduchaff can you show a printscreen of your mig job? Normally NOTE_ID shouldn’t be mapped to any source_column and then you shouldn’t get the error message.


Thanks Marcel. Here is the current mapping :

I’ll try not to map it and let you know


@mduchaff - As already suggested, remove the source mapping for the NOTE ID field and that should solve your problem. 


@mduchaff if you empty the Source Column for NOTE_ID it should work.


Hi ​@mduchaff 

I assume you’re using the view name purchase_order_line with the method purchase_order_line_api.

Instead of using this please either use the view name purchase_order_line_part or purchase_order_line_nopart depending on your requirement and then a value for note_id will be generated automatically when you insert a new record.

/Jens

 


Thanks Jens. Your solution seems good.

I’m going to try it.


So, now, I’m getting another error message.

Getting ride off the missing NOTE_ID : Sounds good.


Reply