SiebelSupport

-Learning the sharing way :)

Tuesday, October 23, 2012

How to Install Special Fonts (MICR, Barcode) in BI Publisher Enterprise


There are special fonts installed by BI Publisher Desktop 10.1.3.2 and later.

On your PC under the installation directory:
BI Publisher Desktop\Template Builder for Word\fonts.
They are files:
  • B39R00.TTF
  • UPCR00.TTF
  • MICR___.TTF
There are also Albany fonts for BIDI languages Simplified and Traditional Chinese, Korean, Japananese....
These can be copied to the jdk/jre/lib/fonts directory on your server.
For an OAS 10.1.3.1 install this was:
D:\product\10.1.3.1\OracleAS_1\jdk\jre\lib\fonts.

For a Standalone OC4J install this was:
OraHome_2 (BIP)\jdk\jre\lib\fonts.
Each of these two locations had the default Lucida font files already installed.
After copying the files from the PC Desktop installation.
Logged into BI Publisher, selected Admin->Font Mappings.
The Albany and Lucida fonts were visible in the LOV.
The other fonts: B39R00.TTF, UPCR00.TTF and MICR___.TTF were not.
Logged onto the server and changed the file extentions from *.TTF to *.ttf for the three files.
Now they are visible in the LOV.
Created a font mapping using the MIRC___.ttf font.
Created a template to use the font.
Bounced the server, since the changes were made in the Admin area.
Ran the report in PDF and the font was embedded.

Monday, October 22, 2012

Barcode Font Does Not Appear In PDF Output



Barcode is shown in RTF/EXCEL output,in PDF it is coming as standard font but not in barcode. 

Solution

The fonts need to be declared in the xdo.cfg file that normally reside in $OA_JRE_TOP/jre/lib.
If the font mappings are not set in xdo.cfg the produced PDF does not includes them, so no barcode font will be shown.

To make sure that PDF output includes all the fonts, please do this:
  • Copy the font file (i.e. FRE3OF9X.TTF) in $OA_JRE_TOP/jre/lib/fonts
  • Add the following lines in xdo.cfg (must resides in $OA_JRE_TOP/jre/lib)

    <font family="Free 3 of 9 Extended" style="normal" weight="normal">
    <truetype path="/usr/java14/jre/lib/fonts/FRE3OF9X.TTF" />
    </font>
Please check what $OA_JRE_TOP is set to in your environment
and use this actual path in xdo.cfg


This is an example xdo.cfg
Please modify it to your needs:
<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
<!-- Properties -->
<properties>
<!-- System level properties -->

<!-- PLEASE SELECT A VALID TEMPFILE DIRECTORY!!! -->
<property name="system-temp-dir">D:/Temp</property>

<!-- PDF compression -->
<property name="pdf-compression">true</property>

<!-- Checkbox Appearance -->
<property name="rtf-checkbox-glyph">Wingdings;253;111</property>

<!-- PDF security ->
<property name="pdf-security">false</property>
<property name="pdf-open-password">user</property>
<property name="pdf-permissions-password">owner</property>
<property name="pdf-no-printing">true</property>
<property name="pdf-no-changing-the-document">true</property>
-->
</properties>


<!-- Font setting -->
<fonts>

<!-- Windows Wingdings font -->
<font family="Wingdings" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/WINGDING.TTF" />
</font>

<font family="GnuMICR" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/GnuMICR.ttf" />
</font>

<font family="Times New Roman" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/TIMES.TTF" />
</font>

<font family="Tahoma" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/TAHOMA.TTF" />
</font>

<font family="Tahoma" style="normal" weight="bold">
<truetype path="/usr/java14/jre/lib/fonts/TAHOMABD.TTF" />
</font>

<font family="Free 3 of 9 Extended" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/FRE3OF9X.TTF" />
</font>

<font family="IDAutomationHC39M" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/IDAutomationHC39M.ttf" />
</font>

<font family="BC 3of9" style="normal" weight="normal">
<truetype path="/usr/java14/jre/lib/fonts/B39R00.TTF" />
</font>
</fonts>
</config>

Labels

ADSI authentication ADSISecAdpt apiinstaller.jar Applet User Properties Barcode fonts in PDF Best Practices BI Publisher BI Publisher 11g BI Publisher Desktop BI Publisher Desktop 10.1.3.2 BI Publisher template error BIP Performance tuning BUG 19469254 Create iPad Reports CRM on Demand R19 Deployment Guide - IP2014 Desktop Integration Siebel Agent (DISA) EAI Object Manager EnableURLCredentials ENTERPRISE NAME IS TRUNCATED DURING MIGRATION INSTALL IN LINUX PLAT Escripting External Business Components (EBCs) Generate Trigger Get a 20% Discount on Oracle Training How To Incorrect missing encryption key Incremental Repository Merge (IRM) Install Barcode fonts in BIP Server Integration Object IP2014 IP2014 Patch Set 1 IP2014 Patchset 2 IP2015 IP2015 Patchset 1 (15.1) IsRecordSensitive JDeveloper jqmtoolbarrenderer.js LDAP LDAPSecAdpt log level of SWSE Menu in Siebel Open UI new theme in Siebel 8.1.1.11 Open UI NFS OBIEE Integration on Siebel 7.8.2 Oracle Database XE Oracle Fusion Middleware Oracle Integration Cloud Services (ICS) Oracle WebLogic Server Override Custom Theme In Open UI Without Deleting The User Preferences Files Of All Users Performance Tuning Quiz Release Notes Responsive Web Design REST SAI REST SAP BusinessObjects Data Quality SavePreferences SBL-DAT-00222 SBL-DAT-00522 SBL-DBC-00107 SBL-SEC-10001 and SBL-DAT-00565 SBL-SEC-10018 Siebel - Oracle Real-time Scheduler Integration SIEBEL 8.1.1.14 ENVIRONMENT VARIABLE INSTALL ISSUE Siebel 8.1.1.8 Fix Pack Siebel 8.1.1.9 / 8.2.2.2 Siebel Administration Siebel Analytics Siebel BI Publisher Reports Siebel Composer Siebel Composer Developer Preview Siebel CRM 15.0 Siebel CRM 8.1.1.10/8.2.2.3 Siebel CRM Innovation Pack 2015 Siebel Delta Files (SDF) Siebel Email Marketing Siebel Filesystem Siebel Innovation Pack 2016 Siebel License Keys Siebel Open UI Siebel Open UI Manifest Siebel Release 15.1 Siebel Reports Siebel RESTful Services Siebel Server Cloning SPF Symbolic URL Synergy Open UI Theme Synergy Theme Open UI - Siebel CRM Innovation Pack 2015 Videos What is Workflow Policy OR

Tags