SAP Knowledge Base Article - Public

1974996 - Bank Direcotory Upload Via Excel Fails With The Error : File Processing Failed; Contents Of File Are Inconsistent

Symptom

While uploading the bank directory using excel, you are getting the error message : "File processing failed; contents of file are inconsistent".

Reproducing the Issue

  1. Go to Liquidity Management work center
  2. Go to Bank Directory View
  3. Click on New and select Bank Directory File Upload
  4. Select the Format as SAP Template or SAP Template (ZIP)
  5. Under the file section of screen, Click on Add and select File.
  6. Click on Browse and select the file
  7. Click on Add
  8. Click on Next
  9. Click on Finish

Cause

Band Directory File Upload for SAP Template is done through a .csv file. You are trying to upload the file which is not in .csv fomrat. (For Example : .txt format)

The maximum file size is 25MB. If bank directory file size is larger than this, you must either compress the file into ZIP format before uploading or divide the data into smaller files.

Resolution

Your bank directory file must be a text file in character-separated values (CSV) format. If necessary, you can edit the file using a spreadsheet or text editor, then convert the file into the correct format while saving your changes. The CSV format requires that each field value be separated from the next by a semicolon (;), and that each row is one line in the text file, followed by a line break. Also You must ensure that order of the bank data in your file is in a specific order.

Before uploading the file, make sure to have the file in correct fomat with the fields in the file in specific order.

See Also

For further information on Fomat of the file and example template file, you can refer to the Help center document "SAP Format for Bank Directory Upload".

Keywords

KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1402 ; SAP Business ByDesign 1405 ; SAP Business ByDesign 1408 ; SAP Business ByDesign 1411 ; SAP Business ByDesign 1502