Question

Apps 10 - Migration ToolKit - CUSTOMER_ORDER migration - Error on MTK_CUSTOMER_ORDER_LINE_TAB rows


Badge

Hello,

 

In Apps 10, I am using the MTK to migrate Customer Orders, and receiving the following error for a collection of about 500 Customer Order Lines:

 

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

 

I saw a previous post for this issue, but in that post the OP was running a Simple Tool migration job, not using the MTK.

 

There is no DEFAULT_ADDR_FLAG column in MTK_CUSTOMER_ORDER_LINE_TAB; rather, the value for this column is derived within MTK_CUSTOMER_ORDER_API:  if the Ship Via Code on the Customer Order and Customer Order are the same, DEFAULT_ADDR_FLAG is set to ‘Y’; if they are not the same, DEFAULT_ADDR_FLAG is set to ‘N’.

 

Wondering if anyone has encountered this error before with the MTK.

 

Thank you in advance

Bob


0 replies

Be the first to reply!

Reply