Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reports 12c using Windows TTF font problem on linux

fehersSep 12 2019 — edited Jul 3 2020

Hi,

I have a WLS stack with Forms and Reports 12c on a OEL7.

WLS, Forms and Reports in-process server are up and running. I call a sample report from forms (picked up from my production environment) using RUN_REPORT_OBJECT.

The next barrier I face to now is the latin2 chars in my reports.

Steps I do the following.

0. Copied c:\windows\fonts\*.ttf to wls server $DOMAIN_HOME/reports/fonts dir.

1. Open the rdf file under my Windows 10 machine and set Arial font on the item.

2. Save it, copy to wls server

3. Compile it with rwconverter.sh

4. run report from form

The result:

If I don't set NLS_LANG in rwserver.sh then latin2 characters are partially bad.

If I set NLS_LANG any other than AMERICAN_AMERICA.WE8ISO8859P1 then GREEK characters comes in the picture.

My charset should be EE8ISO8859P2 or EE8MSWIN1250.

Whether or not comment arial font mapping in unifont.ali the result is the same.

I followed the steps described at https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&sourceId=300416.1&id=852698.1  with no success.

If I run directly the report without forms the result is also the same.

Report Builder: Release 12.2.1.3.0

Relevant variables:

declare -x DISPLAY="localhost:1"

declare -x DOMAIN_BASE="/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains"

declare -x DOMAIN_HOME="/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain"

declare -x FORMS_BUILDER_CLASSPATH="/opt/oracle/Oracle/Middleware/Oracle_Home/jlib:/opt/oracle/Oracle/Middleware/Oracle_Home/jlib/frmbld.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/jlib/importer.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/jlib/debugger.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/jlib/utj.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/jlib/ewt3.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/modules/oracle.bali.share/share.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/jlib/dfc.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/modules/oracle.help/ohj.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/modules/oracle.help/help-share.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/modules/oracle.help/oracle_ice.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/modules/oracle.bali.jewt/jewt4.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/forms/java/frmwebutil.jar:/opt/oracle/Oracle/Middleware/Oracle_Home/forms/java/frmall.jar"

declare -x FR_HOME="/opt/oracle/Oracle/Middleware/Oracle_Home"

declare -x FR_INST="/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig/components/FORMS/instances/forms1"

declare -x HOME="/opt/oracle/Oracle/Middleware/Oracle_Home"

declare -x HOSTNAME="wlstest"

declare -x LANG="hu_HU.UTF-8"

declare -x LD_LIBRARY_PATH="/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/jdk/jre/lib/amd64:/opt/oracle/Oracle/Middleware/Oracle_Home/lib:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/lib:/opt/oracle/Oracle/Middleware/Oracle_Home/oracle_common/jdk/jre/lib/amd64/server"

declare -x ORACLE_HOME="/opt/oracle/Oracle/Middleware/Oracle_Home"

declare -x ORACLE_INSTANCE="/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig/components/FORMS/instances/forms1"

declare -x PATH=".:/opt/oracle/Oracle/Middleware/Oracle_Home/bin:/opt/oracle/Oracle/Middleware/Oracle_Home/forms/mesg:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/opt/oracle/Oracle/Middleware/Oracle_Home/.local/bin:/opt/oracle/Oracle/Middleware/Oracle_Home/bin:/opt/oracle/Oracle/Middleware/Oracle_Home/bin"

declare -x PWD="/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/reports"

declare -x USER="oracle"

declare -x WLS_HOME="/opt/oracle/Oracle/Middleware/Oracle_Home/wlserver"

TIA, Sandor

This post has been answered by fehers on Sep 21 2019
Jump to Answer
Comments
Post Details
Added on Sep 12 2019
2 comments
3,731 views