Question

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

+3

Hi All,

I am using IFS Cloud 24R2. FNDMIG job using MIGRATE_SOURCE_DATA procedure.

Does anyone know how to avoid the above error when migrating customer_order_line ?

The DEFAULT_ADDR_FLAG has value ‘Yes’ and DEFAULT_ADDR_FLAG_DB has the value ‘Y’, but the error says it is NULL.

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

The source data will have below values.

Is something wrong with these values? Should we check on a value of another field in the data set for some validations?

Your thoughts, experiences and suggestions to solve this issue is much appreciated.

Thank you!

+9

Could you please share your datamigration job please.

+3

@N.GEORGI Yes sure.

Please see the attached.

Thank you!

+9

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

+3

@N.GEORGI

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

Thanks!

Sign up