How to troubleshoot Oracle EBS R12-a request with Excel to view the output format as "text" garbled _oracle

Prerequisites for Recurrence:

The output format is "text" of the Concurrent Program: effective responsibility and user.

How to show Excel options when viewing output: System administrator installation browser options Add a row of "file format" to "Text" records, "MIME type" and "description" select "File format" is the same line in Excel.

EBS needs to have installed Simplified Chinese language, so "effective responsibility and user" inside will have Chinese.

Submit the "Effective responsibility and user" request, click "View Output", then "Viewer" select "Microsoft Excel", you can see the content is garbled xls file, if the XLS file name with Chinese then the filename will be garbled.

Workaround:

It is OK to change the value of the profile "Fnd:native CLIENT ENCODING" location layer to "ZHS16GBK".

REF:

1.EBS XML publisher Chinese garbled http://www.jb51.net/article/72762.htm

The above content is small to share the Oracle EBS R12-in Excel to see the output format of "text" request garbled problem, I hope to help.