SAP Knowledge Base Article - Public

3501105 - System Crashes While Uploading ISO20022 Bank Statement XML File

Symptom

System crashes while uploading a new bank statement XML file in ISO20022 Bank Statement format (Camt.053.001.02).

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Go to the Bank Statements view.
  3. Click New and click Bank Statement File Upload.
  4. Enter Company, Bank and Import Format ISO20022 Bank Statement.
  5. Click Add, click File.
  6. Add the respective XML file.
  7. Click Start File Upload.
  8. System crashes.

Cause

The XML file has not been formatted according to ISO-Standards, which results in a system crash (backend dump).

Example of common errors:

1) In file header, tag <BkToCstmrStmtV02> is present.

Correct tag: <BkToCstmrStmt> 

2) Date denomination in the statement transactions is incorrect (MMDD), for example:

<BookgDt><Dt>0724</Dt></BookgDt>

Correct date denomination to be used is YYYY-MM-DD: <BookgDt><Dt>2024-07-24</Dt></BookgDt>

3) Format of <ValDt><Dt> is YYYYMMDD: <Dt>240724</Dt>

Correct format to be used is YYYY-MM-DD: <Dt>2024-07-24</Dt>

Resolution

The ISO20022 Bank Statement XML file should be corrected as per above instructions. Once the changes are done, the new XML file could be successfully uploaded in the system.

Keywords

CAMT.053.001.02; bank statement; <BkToCstmrStmt>; <BkToCstmrStmtV02>; <BookgDt>; <ValDt><Dt> , KBA , AP-PAY , Payment Processing , How To

Product

SAP Business ByDesign all versions