ORA-20124: Error.NULLVALUE: Field [DEFAULT_ADDR_FLAG] is mandatory for Customer Order Line and requires a value.

Could you please share your datamigration job please.

​@N.GEORGI  Yes sure.

Please see the attached.

Thank you!

I have removed the line 750, and modified the 760.

Could you please test ? 

This action, is to verify if the error is comming from the IC_CUST_ORD_LINE_LOAD or not

Kind regards

​@N.GEORGI 

I tried as you suggested, but I still get the error.

Thanks!

Hi ​@DisnaMarakkala 

I had a quick look into your migration job and I was wondering why you changed the method list attributes for customer_order_line?

Excerpt:

That makes no sense and I recommend to create the migration job again instead of changing the flags, the On New and On Modify toggles back to the orginal ones.

If you have a group of similar column names (Client and DB column name) then keep it as it is.

The Client and DB column name must always have the same settings for On New/On Modify.

Exceptions to change flags or On New/On Modify:

• E.g. you have a PARTY_TYPE and PARTY_TYPE_DB column delcared as Key fields (flags P and K) then it is necessary to add a Minus flag to the Client column name, e.g. PARTY_TYPE, otherwise you’ll probably not be able to update records
• If you want to use a “key manipulation” , e.g. COMM_METHOD, then it makes sense to change the flags
• If you want to exclude fields to be updated then it makes sense to set the On Modify to No

There is also no need to remove a line from the source mapping. 

I always recommend to map only the DB column and not the Client column if there is a DB column because then there shouldn’t be any problem with the language you’re connected to the client of IFS Cloud.

Can you try out this please?

/Jens

​@Jens 

Thank you for your response!

I will try what you suggested and let you know how it goes.

Regards,

Disna.