Error font when export pdf on oracle bi publisher

[Huy Nguyen]

Hi Tom,
I have a problem when I export pdf from oracle bi publisher which related to Vietnamese font(Arial or Time New Roman font). I directly test on word, it give me the same problem as oracle apex. I try to add those above fonts on directory such as {ORA_HOME}\jdk\jre\lib\fonts ] directory. But it is unsuccessfully. How can I deal with that?

Present problem
https://ibb.co/hfdbGtC

Desire

https://ibb.co/F0kLm8y

That image I export rtf template.


Thank you in advance and your time.

[ErmanArslansOracleBlog]

Who is Tom?

Please upload the screenshots (dont share urls - links..)

[Huy Nguyen]

I am sorry you, Erman

When I created that post, I could not insert the image, it showed me that quote:
Internal Error: Missing Template ERR_ZERO_SIZE_OBJECT

so I gave that url.

[ErmanArslansOracleBlog]

This seems like a font issue. A font issue for specific characters.. Seems like the bold fonts for those characters are missing.. What is that character set? Which language does those characters belong?

[Huy Nguyen]

I knew that. that fonts is  UTF-8 (Vietnamese follow  Table 23-2 Valid Values for the IANA-Defined Character Sets).  It is Vietnamese language.

[ErmanArslansOracleBlog]

This is a PDF output  right?
Seems like font mapping issue. It seems you are using a font which have no bold feature for printing those special characters.

Somehow there is a mapping issue emerging for those special characters which needs to be printed bold..
What is the font of those problematic characters?

Check this document -> http://ermanarslan.blogspot.com/2016/12/ebs-r12-xml-publisher-pdf-report-font.html

That document is a good one.. That will you the clue..

Also check the following MOS notes ->

PDF output generated using RTF template Shows Cyrillic Character Incorrectly in BIP Desktop Tool and in EBS XML Publisher (Doc ID 2261243.1)
BI Publiser: Report PDF Output Not Displaying Correct Font ' HP Simplified' with Bold Characters (Doc ID 2632802.1)

[Huy Nguyen]

Sorry Erman. My network is in my office which has a problem. So now I newly respond to you

Your link is very clear. But I test on my word, it is unsuccessfully.  I describe those step I created:

-  in my directory C:/Windows/Font, I have a file name times.ttf

- I haven't found file named xdo.cfg in BI publisher. I follow guide of MOS Doc ID 2261243.1.
I replace xdo example.cfg  to xdo.cfg and add

<config version="1.0.0"  xmlns="http://xmlns.oracle.com/oxp/config/">
   
    <properties>
       

       
        <property name="system-temp-dir">c:/Temp</property>

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

       
        <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>


   
    <fonts>

     
     
       <truetype path="C:\WINNT\fonts\wingding.ttf" /> 
     

     
       <truetype path="C:\WINNT\fonts\GnuMICR.ttf" /> 
     

       
        <truetype path="C:\WINNT\fonts\timesbd.ttf" />
       
       
        <truetype path=" C:\WINNT\fonts\times.ttf" />
       
       
        <truetype path=" C:\WINNT\fonts\timesi.ttf" />
       


     
       <truetype path="C:\WINNT\fonts\3of9.ttf" /> 
     
         
    </fonts>
</config>


I try to change path C:\Windows\Fonts\times.ttf or C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\fonts or D:\App\Oracle\Product\db_home\WINDOWS.X64_193000_db_home\jdk\jre\lib\fonts

It still has not changed whe export pdf. I don' know which point I have mistake.

[ErmanArslansOracleBlog]

Did you configure your xdo.cfg  correctly?

As you  see in my post; the format is as follows ;

<fonts>

<truetype path="/home/applmgr/timesbd.ttf" />


<truetype path=" /home/applmgr/times.ttf" />


<truetype path=" /home/applmgr/timesi.ttf" />

</fonts>

[Huy Nguyen]

Yeah, I see that. Now I check BI puplisher xml by word on my computer. I config xdo.cfg in BI puplisher forder in my computer. According to oracle server, I use window server, I have just found forder with path as
/jdk/jre/lib/fonts/times.ttf. I could not find your path (path="/home/applmgr/)( I wonder that location for Linux system)

[ErmanArslansOracleBlog]

The paths/locations that I used in that blogpost are just examples..
You can use your own paths.. You don't need to put those ttfs under /home/applmgr, you can place them anywhere you want, into any directory which is accessible by your application OS user.

[Huy Nguyen]

Thank you, Erman. How can I  find the path exactly I add font? You can give me some good idea.

[ErmanArslansOracleBlog]

You can put them anywhere you want, and then do your configuration accordingly.

for instance in the example above; I put the ttf files under the directory /home/applmgr and then configured my xdo.cfg accordingly.

[Huy Nguyen]

Thank you for your answer.