Skip to main content
Solved

Excel migration is not working

  • November 18, 2025
  • 5 replies
  • 59 views

Forum|alt.badge.img+9
  • Sidekick (Customer)

Hello, I want to insert new part_no in view ENG_PART_REVISION through excel data migration, but it retrieves error: ORA-20111: EngPartMaster.FND_RECORD_NOT_EXIST: The Engineering Part Master does not exist. 

 

How can I solve it?

Best answer by Abdul

Hi ​@Ed22,

As ​@matt.watters mentioned, the system automatically creates the Part master with Engineering Part creation, however, the system does not create the Part master automatically when creating an Engineering Part using a migration job unless migration job specifically design to create a Part master first and then create Engineering Part.

In last comment, I suggested to create Part master first (either manually or using a separate mig job) and then create Engineering Part record using excel migration.

 Hope this helps.

5 replies

Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • November 18, 2025

Hi ​@Ed22,

I doubt whether system would allow you to directly create Engineering Part, since Part Catalog is a pre-requisite to create an Engineering Part or Inventory Part. 

Can you please check by creating the Part Catalog manually before creating an Engineering Part through excel migration.


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • November 18, 2025

Yes, I can create manually part_no in ENG_PART_REVISION 


matt.watters
Ultimate Hero (Partner)
Forum|alt.badge.img+26
  • Ultimate Hero (Partner)
  • November 18, 2025

@Ed22 From a non-data migration perspective - when creating a new engineering part, users cannot create records in the view ENG_PART_REVISION. New engineering parts are registered in ENG_PART_MASTER_MAIN. When a new part is entered here, a record in the Part master is created.

 

 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Customer)
  • November 18, 2025

Yes, but previously I must changed revision in ENG_PART_MASTER_MAIN, so I created excel data migration on this view ENG_PART_MASTER_MAIN, but I read that this view is not editable, so I must used view ENG_PART_REVISION and this worked for changing revision,but for creating new part_no is not working


Abdul
Superhero (Partner)
Forum|alt.badge.img+20
  • Superhero (Partner)
  • Answer
  • November 18, 2025

Hi ​@Ed22,

As ​@matt.watters mentioned, the system automatically creates the Part master with Engineering Part creation, however, the system does not create the Part master automatically when creating an Engineering Part using a migration job unless migration job specifically design to create a Part master first and then create Engineering Part.

In last comment, I suggested to create Part master first (either manually or using a separate mig job) and then create Engineering Part record using excel migration.

 Hope this helps.