My Oracle Support Banner

EAP: Import Financial Sanction List Got Diacritics Corrupted on the MS SQL Server Platform (Doc ID 3012771.1)

Last updated on MARCH 28, 2024

Applies to:

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

Symptoms

Financial sanction import gets diacritics corrupted.
Accented characters like ö, ü, é, à etc. are not readable in the tables.
For example, the name Köprülü (probably Turkish) is in the database Köprülü.
This issue occurs on only MS SQL Server platform.


Step:
----------------------------------
1. Input data in the XML file
2. Put the data source XMLfile on network location
3. Log in to DEMO environment as VP1
    Navigate Banking > Financial Sanctions > Import Financial Sanction List
    Create Run Control with Import Type File and Layout OFAC, enter file path and name
4. Run process IMPORT_FILES
5. Find latest SDN_ID by below SQL
    SQL: select * from PS_SDN_HEADER where SDN_LIST_TYPE = 'OFAC'
6. Check name in the table PS_SDN_ENTRY
    SQL: select * from PS_SDN_ENTRY where SDN_ID = x
    SDN_LAST_NAME is corrupt: Köprülü
    Input is Köprülü, characters ö and ü are wrong in table.
7. Check more diacritics in the table PS_SDN_AKA_LIST
    SQL: select * from PS_SDN_AKA_LIST where SDN_ID = 4
    SDN_LAST_NAME is corrupt: ëèéäÅŽœŸÇÔìø
    Input is ëèé䊎œŸÇÔìø, all characters are wrong in table.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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