Solved

Sales Price List Part - Data Migration Error

Userlevel 1

+5

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

icon

Best answer by Makede 18 January 2023, 13:14

Userlevel 4

+10

HI @GDrysdale

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

Userlevel 1

+5

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!

Sign up