EBS XML Publisher Chinese garbled problem and solution _oracle

Due to native environment problems, the XML Publisher report cannot be run and the XML page cannot be displayed.

XML input cannot be viewed using an XSL style sheet. Please correct the error and click the Refresh button, or try again later.

An XML document can have only one top-level element. Error processing resource ' http://***.***.com:8001/oa_cgi/fndwrr.exe?temp_id=2326230111 '. 12th Line, Location: 2
<ITEM_LIST>
-^

But you can run out on a co-worker's computer.

After setting the $oa_jre_top/jre/lib/fonts font, I have two local JRE, of which 1.6.0_07 no similar alban*.ttf files. Add later to resolve.

Turn:

Problem Description: In the process of using XMLP to do a report, often encounter garbled situation.

There are two causes of garbled characters: Character set problems and font definitions.

Character set caused by garbled: general garbled into irregular.

Font definition caused by garbled: general garbled is the rule, generally for (reverse?)

I. The issue of character sets

Workaround:

1. When outputting XML in Pl/sql, the header information is encoded as:

Output (' <?xml version= "1.0" encoding= "' | |
Fnd_profile.value (' icx_client_iana_encoding ') | | ' "?> ');

2. Modify EBS System Preferences: Client character encoding modified to: Unicode (UTF-8), modify preferences affect the configuration file

Fnd:native the value of the CLIENT encoding.

3. Directly modify the value of the Fnd:native client encoding, so that the client's code is consistent with the server.

4. Attention MATTERS:

Oracle's character set naming (non-international standards) and XML specification (IANA International standards) are inconsistent, and we cannot set the XML character set directly against Oracle's character set, depending on the following table mapping settings (or through the utl_gdk.charset_ Map to get the mapping relationship):

Two. The problem of font definition

Solution steps:

1. See if the $oa_jre_top/jre/lib/fonts directory contains files similar to Alban*.ttf.

2. If not, a copy of the $fnd_top/resource from the EBS,

To use the command:

CP $FND _top/resource/alban*.ttf $OA _jre_top/jre/lib/fonts

3. Restart application. The problem will be solved.

4. Principle: By default, XMLP does not support Chinese because it is only missing fonts. Because XMLP is written in Java, theoretically Java supports any language. EBS has its own Chinese fonts, but it is not installed in the XMLP directory. So make a copy.

5. XMLP The default output format is HTML, the font used when opening is $oa_jre_top. Use Excel and PDF to use the font below $fnd_top