Skip to main content

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

 

HI @GDrysdale 

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

 


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!


Reply