How to Modify webutil.cfg in Forms 12C Using Fusion Middleware Control (FMWC)/EnterpriseManager(EM)

 In Forms 12c, as well as previous versions of Forms, Enterprise Manager(EM) - also called Fusion Middleware Control (FMWC) - should always be used to create/modify configuration files. It should be changed through the EM/FMWC console interface.

Note that you should use these tools, rather than directly editing configuration files, to perform all administrative tasks unless a specific procedure requires you to edit a file. Editing a file may cause the settings to be inconsistent and generate problems.

The option to edit webutil.cfg is available from the "Advanced Configuration" of FMWC. Choose "Miscellaneous" under the "SelectCategory" OPTION

ption.

Configure Icons in 12c forms reports application

 

HOW TO CONFIGURE  ICON IN 12C Forms Application

·       Make a directory icon in the java directory

·       Put all the gif icons in icon folder located in E:\Oracle\Middleware\Oracle_Home\forms\java\iCon

 

·       Then open Registry.dat from the below location. E:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\config\fmwconfi g\servers\WLS_FORMS\applications\formsapp_12.2.1\config\oracle\forms\registry\registry. dat

Insert the below lines in the registry.dat file 

 

default.icons.iconpath=//serverip:7777/forms/java/icon default.icons.iconextension=gif

 

 

Restart WLS_FORMS and run the application

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