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
- Go to Liquidity Management work center
- Go to Bank Directory View
- Click on New and select Bank Directory File Upload
- Select the Format as SAP Template or SAP Template (ZIP)
- Under the file section of screen, Click on Add and select File.
- Click on Browse and select the file
- Click on Add
- Click on Next
- 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