#COE #BA01 Escape Character substitution for Special Characters in XML Payment Files

[RyanMuller]

Hello,

We have banks in some countries which have issues processing special characters in our XML payment files from SAP. The feedback from those banks is that what is in the file needs to match the legal entity name which is problematic particularly with the & special character being prevalent in our legal entity names.

In our legacy environment we substitute with escape characters on the bank payment XML files so banks interpret the values appropriately like:

How can we do these same substitutions in the Payment Media format config? The only option seems to be to exclude the special characters completely which doesn't allow us to maintain the legal entity name accurately.

Best,

Ryan

[OwenLiu]

Hi Ryan,

If you have received solution, could you please share the same?

Best Regards,
Owen

[RyanMuller]

Hi owen.liu:

Ondrej's answer was good enough. We validated that the payment files when you looked at them in notepad showed the special character substitution, but when you looked at the xml thru a browser like Chrome or Excel, the special character substitution didn't appear. We conveyed this information to the bank for their validation and the response seemed satisfactory to them.

[Ondrej_ZATOPEK · Accepted solution]

Dear Ryan,

what exactly is happening at the moment? The DME engine should automatically replace these characters when the file is generated. I am not sure which formats you are using. If you are using CGI formats, you need to remove the characters from the set of characters to be excluded in Map Format Data for Payments SSCUI.

When the characters are not excluded, they should be automatically escaped.

Regards,

Ondrej

[RyanMuller · Accepted solution]

o.zatopek We're using a CGI format and not excluding '&' as character in that mapping SSCUI. When we send the file to the bank (in this case in India) thru the 2YM API and they're saying they cannot interpret the characters.

Best,

Ryan

[Ondrej_ZATOPEK]

Hi Ryan,

could you please open an incident on FI-AP-AP-B1 and prepare an example? I am not sure how exactly is the scenario integrated with DME engine. DME engine should by default replace characters like & < >.

Regards,

Ondrej