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

The following error message is displayed during Purchase Order migration:

File Validation Failed. Create an incident

SAP Business ByDesign

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

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.

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.

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