SAP Knowledge Base Article - Public

2874598 - Error Message "File Validation Failed. Create an incident" During Migration of Purchase Order

Symptom

The following error message is displayed during Purchase Order migration:

File Validation Failed. Create an incident

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center.
  2. Go to Overview view.
  3. Search and find the activity Migration of Purchase Orders.
  4. Upload the migration file.
  5. Choose Execute Migration button and choose Step-by-Step option.

Error: File Validation Failed. Create an incident

Cause

There are many causes of this issue. Few causes are given below:

  1. Could be there is missing information in your migration file.
  2. In the Migration Adaptation field, the migration type code should be always numeric.
  3. A Purchase Order with Item Type 2 (Service Item) or 4 (Limit Item) may be migrated without a Product ID or Product Description being maintained for the item.
  4. It is likely that the field Price Unit on the Items tab of the Migration of Purchase Orders file is mistaken to be e.g. a Currency or UOM field. The current value of the field Price Unit is not correct.
  5. The Excel file must not contain more than 35 line items, as this is a system limitation during migration.

Resolution

Respective Action to be taken for above mentioned causes are given below:

  1. At item level either enter value 'X' to To-Stock column or provide Account assignment details.
  2. Enter 1 under Migration Adaptation field or place cursor on the field to see the other options available.
  3. When Item Type is 2 (Service Item) or 4 (Limit Item), either Product ID or Product Description should be supplied, and it is mandatory to have one of them.
  4. The field Price Unit expects a number (generally 1). It indicates the number of product units. This is to specify, for how many eaches/liters/kilograms (or whatever the UoM is) the indicated price applies.
  5. The number of line items must always be kept below 35 in the excel file. If the file contains more than 35 line items split them into two separate files and create a Purchase Order.

If an error still occurs, the migration template details can be used to create a Manual Purchase Order. If incorrect or incomplete information is entered, the respective error will be displayed, which can then be used to correct the migration template details accordingly.

Keywords

Migration of Purchase Orders; Purchase Orders upload; Purchase Orders; Migration Adaptation; Error in migration of purchase order; File validation failed; Create an incident , KBA , AP-POP-PO , Purchase Order , Problem

Product

SAP Business ByDesign all versions