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>

Friday, September 28, 2012

How To: BI Publisher 8 Desktop Preview Template does not work


When previewing a vanilla BI Publisher template (srvreqaa.rtf) for "Service Request Activity - All" report that comes with the Siebel installation in BI Publisher Desktop the following error is thrown :

ConfFile: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\config\xdoconfig.xml
Font Dir: C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts
Run XDO Start
Template: C:\Documents and Settings\Administrator\Desktop\aclist_sample.rtf
RTFProcessor setLocale: en-us
FOProcessor setData: E:\Sia811\siebsrvr\XMLP\DATA\BIP Accounts Sample.xml
FOProcessor setLocale: en-us
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:442)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: oracle.xdo.parser.v2.XPathException: Extension function error: Class not found 'com.siebel.xmlpublisher.reports.XSLFunctions'
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)

Some of the standard Siebel templates contain references to functions that are included in specific .jar files and if these are not loaded prior to opening the RTF template, then the preview will fail with the aforementioned error.

 In order to resolve the behavior the following procedure can be used :

1) Locate the following files which should be available in the %SIEBEL_CLIENT_ROOT%\CLASSES folder :
SiebelXMLP.jar
Siebel.jar
XSLFunctions.jar
SiebelCustomXMLP.jar
SiebelCustomXMLP_SIA.jar

2) Close all Microsoft Word sessions

3) Create a .bat file (startword.bat), and run it before opening the RTF template.
 
The .bat file should contain the following text :
echo %1
set _JAVA_OPTIONS=-Xbootclasspath/a:D:\811\Client\CLASSES\SiebelXMLP.jar;D:\811\Client\CLASSES\Siebel.jar;D:\811\Client\CLASSES\XSLFunctions.jar;D:\811\Client\CLASSES\SiebelCustomXMLP.jar;D:\811\Client\CLASSES\SiebelCustomXMLP_SIA.jar;
"D:\Program Files\Microsoft Office\Office12\Winword.exe" %1

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