Oracle Reports 12c Release (12.2.1), uses the new font mechanism to run a Unicode report on UNIX using the TTF / TTC fonts, generating report output that in most cases looks identical on both platforms.
Run a sample Unicode report on Windows:
Navigate to the EM MBean browser Weblogic Domain > System MBean Browser
Navigate to reports tools mbean for uifont.ali oracle.frcommon.config:type=uifont.ali,name=uifont-<componentName>
Add the following entry under the [PDF:Subsetting] section:
"Arial Unicode MS"="ARIALUNI.TTF"
Ensure there is no aliasing defined for Arial in the Global section. If there is, comment it out:
#Arial=Helvetica
Add the font ARIALUNI.TTF
to REPORTS_PATH
.
Set NLS_LANG
in the Windows registry to AMERICAN_AMERICA.UTF8
.
Open the sample report in Reports Builder.
Select File > Generate to File > PDF.
Save the report output.
Run the same Unicode report on UNIX:
Check whether the Unicode font used by the report is already available on the UNIX server machine in $DOMAIN_HOME/reports/fonts
and in the REPORTS_PATH
(for example, ARIALUNI.TTF
). If it is not available, copy it from the Windows machine to $DOMAIN_HOME/reports/fonts
.
Set NLS_LANG
in reports.sh
to AMERICAN_AMERICA.UTF8
.
Run the report using the following command line:
http://host:port/report=report_name.rdf&destype=cache&desformat=pdf&userid=user/password@db
For example:
http://host:port/report=Unicode.rdf&destype=cache&desformat=pdf&P_LANG_ID=JA&userid=oe/oe@mydb
Compare the output on UNIX with that on Windows to confirm that they are identical.