Skip to main content
Solved

Sales Price List Part - Data Migration Error

  • January 18, 2023
  • 2 replies
  • 305 views

Forum|alt.badge.img+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?
 

 

View original

Forum|alt.badge.img+10
  • Hero (Employee)
  • January 18, 2023

HI @GDrysdale 

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

 


Forum|alt.badge.img+7
  • Sidekick (Customer)
  • January 18, 2023

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings