Remittance File Includes Special Characters and is not Accepted by the Bank (Doc ID 1286774.1)

Last updated on AUGUST 14, 2023

Applies to:

Goal

We use customer payments for Spain and France and the payment files contains special characters such as accents. The bank is rejecting the file because the bank cannot accept special characters such as letters with accents.

The character set allowed by SWIFT:

a b c d e f g h i j k l m n o p q r s t u v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
0 1 2 3 4 5 6 7 8 9
/ - ? : ( ) . , ' + { }
CR LF Space

Can anything be done from the Oracle side to "replace" these special characters such that they do not appear in the payment file?


Current behaviour from Oracle side is as follows:

Payments uses the character set specified by the ICX_CLIENT_IANA_ENCODING profile option when determining the encoding for the XML extract. In this case, ICX_CLIENT_IANA_ENCODING was correctly set to UTF-8 such that the extract generation is successful and handles the special characters correctly. UTF-8 encoding is seen at start of XML extract:

<?xml version = '1.0' encoding = 'UTF-8'?>
<FundsCaptureInstruction> .....

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.