ARABIC FONT CONFIGURATION FOR REPORTS 12C

 Arabic Characters do not Display Correctly in PDF Format using Arabic Transparent Font or Simplified Arabic font

For 12c Oracle reports 

Solution

The Arabic Transparent font does not have all Glyphs, so you need to replace artro.ttf and artrbdo.ttf with the Arial font.

 

PDF SUBSETTING IS NOT WORKING WITH SOME SPECIFIC ARABIC FONTS

 

 

Testcase with step-by-step instructions 

========================== 

  (Database used with NLS_LANG AR8MSWIN1256)

 

 

1. Make sure to set the environment variables for the Report Server in the windows registry.

  - Set REPORTS_PATH to the system font directory such as C:\Windows\Fonts

  - NLS_LANG=ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

    OR

- NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256

 

2. Open uifont.ali under ORACLE_HOME\user_projects\domains\base_domain\config\fmwconfig\components\ReportsToolsComponent\RepTools1\guicommon\tk\adminset the font alias

   entries at [PDF:Subset] section.

.

 [ PDF:Subset ]

 

Arial..Italic.Bold.. = "Arialbi.ttf"

Arial..Italic... = "Ariali.ttf"

Arial...Bold.. = "Arialbd.ttf"

Arial..... = "Arial.ttf"

"Arabic Transparent"..Italic.Bold.. = "ARIALBI.TTF".....

"Arabic Transparent"..Italic... = "ARIALI.TTF".....

"Arabic Transparent"...Bold.. = "Arialbd.ttf"

"Arabic Transparent"..... = "artro.ttf"

 

Tahoma = "tahoma.ttf".....ar8mswin1256

Arial = "Tahoma"

"Tahoma Bold" = "tahomabd.ttf".

 

3. Copy uifont.ali in below location

Oracle_Home\user_projects\domains\base_domain\config\fmwconfig\components\ReportsToolsComponent\RepTools1\tools\COMMON

 

4. Restart WLS_REPORTS

 

5. Open report in builder and choose arial font on fields you want to show in Arabic and save it.

 

6. Run the report with an URL like:

 

http://localhost:9002/reports/rwservlet?server=rep_wls_reports_inproc+report=D:\projects\test_lang.rdf+userid=***/***@**+desformat=pdf+destype=cache