Skip to main content

PART MIGRATION

  • March 5, 2024
  • 6 replies
  • 109 views

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+11
  • Hero (Employee)
  • 106 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+11
  • Hero (Employee)
  • 106 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)
  • 1306 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?