RDF类型报表-PDF中文乱码

在Oracle R12中，遇到了客户一张客户化的报表：

报表的输出格式是布局在RDF文件（非RTF）中，在并发请求输出时，PDF会出现中文乱码，而HTML和excel显示正常：

 

根据资料：

查看$OA_JRE_TOP/lib/fonts目录下是否包含类似ALBAN*.ttf 的文件

如果没有，从EBS的$FND_TOP/resource 下拷贝一份，

    使用命令：

         cp $FND_TOP/resource/ALBAN*.ttf        $OA_JRE_TOP/lib/fonts

原理：默认情况下，XMLP不支持中文，原因仅仅是缺少字体。因为XMLP采用Java编写，理论上Java支持任何语种。EBS自带了中文字体，但没有安装到XMLP目录。因此要做个拷贝.

XMLP默认输出格式为HTML的时候，打开时所使用的字体是$OA_JRE_TOP下的。使用EXCEL和PDF时使用的是$FND_TOP下面的字体。

注意：上述情况描述的是XML的报表，但并非我们的报表；

 

随后，向Oracle提交SR；给出的回复：11i ，R12 的RDF不支持PDF输出中文

Metalink ID ： 443778.1

In Oracle Applications 11i with Oracle Reports 6i, PDF output is supported for only Latin-1 character sets such as US7ASCII, WE8ISO8859P1 or WE8MSWIN1252. Any other single-byte, multi-byte or Unicode character set such as UTF8 or WE8ISO8859P15 is not supported.

 

 

FIX

 

E-Business Suite (EBS) does not support the generation and/or the printing of Oracle Reports base reports in the PDF format on an instance installed with the UTF8 character set.

Select ONE of the following two viable options in order to workaround this UTF8 and PDF limitation:

1)    Install and configure the BI Publisher product, create / design custom templates to produce reports in PDF format. Setup Bi Publisher as per Note 422508.1 "About Oracle XML Publisher Release 5.6.3" and Note 338990.1 "How To Print XML Publisher PDF Reports Via The Concurrent Manager?" BI Publisher supports generating and printing reports in the PDF format under any character set, including UTF8.


2)    Use another supported format like Postscript. The Postscript format is fully supported under the UTF8 character set. It has few limitations. Ensure Pasta / IX library is installed as per Note 356501.1 "How to Setup Pasta Quickly and Effectively"

Note:     Oracle Reports 10g base PDF format is not supported in EBS Release 12 in UTF8 / AL32UTF8 environment. BI Publisher product is still required in EBS Release 12.

 

 

SO，没办法，动手开发RTF模板。