Solved

Sales Price List Part - Data Migration Error

+7

Hi

I am migrating into Sales Price List Part (SALES_PRICE_LIST_PART)

Method List is set to New and Modify.

Ran the migration job and all records were imported.

When I re-run the Migration Job I get an error ORA-20112: SalesPriceListPart.EXIST2: The Sales Price List Part object already exists.

Does anyone know why I get this error? teh record does exist so it should be doing an update now, not an insert!

Cheers,

Graham

Best answer by Makede

HI @GDrysdale

could you please post a hardcopy of your mapping. Is there any key field which is not mapped by you?

Did this topic help you find an answer to your question?

+10

HI @GDrysdale

could you please post a hardcopy of your mapping. Is there any key field which is not mapped by you?

+7

Just like that!.

There was key field MIN_DURATION not mapped. Strange that it worked fine for the insert without the key field. Must default to -1.

Set the Default = -1 and it worked fine.

Really appreciate the help. Was pulling my hair out!

2 replies