Skip to main content

PART MIGRATION


Forum|alt.badge.img+1

Please any one can tell what this error mean is.

 

ORA-20110: InventoryPartUnitCost.N-0

 

 

6 replies

Forum|alt.badge.img+10
  • Hero (Employee)
  • 99 replies
  • March 5, 2024

HI @dvidanage 
could you please give some more information what steps you are performing when you get the error. Is it related to a migration job or in a background job?
Thanks


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • March 5, 2024

Hi Makede

 

I'm going to migrate parts through CSV file. Actually, upload in no error. while migration I'm getting this error. I checked parts one by one. 

 

Thanks


Forum|alt.badge.img+10
  • Hero (Employee)
  • 99 replies
  • March 5, 2024

Which migration method are you using (MIGRATE_SOURCE_DATA)?


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 3 replies
  • March 5, 2024

 

Using these two jobs.


Forum|alt.badge.img+5
  • Do Gooder (Employee)
  • 26 replies
  • March 8, 2024

usually these errors are business errors. It can indicate that some parts you are trying to migrate giving validation errors during insert/update. First thing you have to look at is to check with business consultant for the reasons which will receive such error and then look at your loading csv data for any missing mandatory information (or incorrect data)


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1143 replies
  • March 8, 2024

@dvidanage  I did a quick SQL to see if there’s a place in PL/SQL packages where N-0 error would be thrown. I couldn’t find any. Can you provide the full error message?


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