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
- Go to the Liquidity Management work center.
- Go to the Bank Statements view.
- Click New and click Bank Statement File Upload.
- Enter Company, Bank and Import Format ISO20022 Bank Statement.
- Click Add, click File.
- Add the respective XML file.
- Click Start File Upload.
- 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