Position Management ORGCHART SQR does not display Chinese Characters (Doc ID 2161715.1)

Last updated on JULY 15, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue : Position Management Orgchart SQR does not display Chinese Characters

Actual behavior:
---------------------
When attempting to run the Build Organization Chart Reports with Chinese characters in the CSV output report generated all the Chinese characters are shown with junk characters.

Expected behavior:
-------------------------
The output report generated should display correctly the Chinese characters when running the SQRs with Chinese language.

Steps
-------
The issue can be reproduced at will with the following steps:

1) Under Personal Information - Modify Person - Edit Name (in correct History mode) For the Employee KU0037 , Changed name in Simplified Chinese.
2) Under Setup HCM - Foundation tables - Departments changed the Description for 2 departments 15000 and 21300 , in the Chinese equivalent names.
3) Logging in English and run the ORGCHART SQR under the following navigation : Organizational Development > Position Management > Create Organization Structure > Build Organization Chart. Chinese characters are not displayed.
4) Logging in Simplied Chinese language and running the ORGCHART SQR . Chinese characters are not displayed here as well.



Cause

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