ECM: Request Control over Special Characters in SEPA Payment File Generated by Financial Gateway (Doc ID 1552109.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Goal

The valid characters for SEPA are specified in the following table:
ISO20022 STANDARD CHARACTER ENCODING TABLE
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 / - ? : ( ) . , ‘ + space

However, PeopleSoft does not have any control on the characters that are put in the bank files. Request to define the characters that should be excluded from the file or that should be replaced by UTF8 standard characters.

STEPS
1. Navigate to Vendors > Add/Update > Vendor, and set up vendor with a special character (Ï) in the field Address 2
2. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry, and create of a voucher for this vendor. The layout for this voucher is SEPA_CT and the payment method is EFT.
3. Navigate to Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager, and launch the Pay Cycle to pay this voucher.
4. Navigate to Financial Gateway > Process Payments > Payment Dispatch, and launch the payment dispatch to generate the bank file.

The bank file is generated and the special character has been put in the file.

The files generated with special characters are rejected by Treasury applications and banks.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms