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

While uploading the bank directory using Excel, the error message 'File processing failed; contents of file are inconsistent' is displayed.

SAP Business ByDesign

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.

• Usually Bank Directory File Upload for SAP Template is done through a .csv file format, but the uploaded file is other format (For Example : .txt format).
• The maximum file size exceeds 25 MB. 

• The bank directory file must be a text file in character-separated values (CSV) format.
• If necessary, 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 ensure that order of the bank data in the file is in a specific order.
• Before uploading the file, please ensure it is in the correct format and that all required fields are arranged in the specified order.
• If bank directory file size is larger than 25 MB, compress the file into ZIP format before uploading or divide the data into smaller files.
• Additionally, while uploading the existing bank directory through Excel template, please select the "Overwrite Existing Entries" checkbox on the new bank directory upload screen in the UI. This will ensure that the existing bank directory entries are updated successfully.

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

Band Directory, File Upload, issue, template, error occurs, directory file , KBA , SRD-FIN-CLM , Cash and Liquity Managment , Problem