Configuring BIDI / Arabic / Hebrew Reports in 11g R2 – REP-56048: Engine rwEng-0 crashed

Recently I have been getting MANY frustrated inquiries regarding how to properly configure Hebrew / Arabic / BIDI reports for Forms/Reports 11g R2.

In general I get 2 types of errors from customers when running with Hebrew reports:

Firstly,  instead of seeing Hebrew / Arabic characters when a report is run they see various symbols @#!$%^&*.  When this happens most people decide to replace the uifont.ali file that comes with Reports 11g R2 with the uifont.ali file that supported BIDI characters from 10g systems. Once they do this replacement they get the second error which is error message REP-56048: Engine rwEng-0 crashed and the report server crashes when they run a Report containing Hebrew characters.

After see many SR’s on the subject I decided I would write a handy whitepaper for you all on how to configure Hebrew reports on 11g R2 with ease.

The guide to Hebrew reports for Windows can be downloaded here

I know developers have been getting similar errors running Arabic reports so this may help them as well. If it works for Arabic please let me know in the comments section. Thanks

Fixing running Oracle Reports from a menu item in Forms during upgrade

You may find that when you upgrade your forms application from client server. The reports you have that are run from the menu bar have stopped working. This is due to the change from using RUN_PRODUCT to using the RUN_REPORT_OBJECT() built-in.

In order to use the RUN_REPORT_OBJECT() built-in you need to have a report object in the form from which you want to call the report. If you need to add a report object across the board you can checkout some past posts for how to do form manipulations in patch either using JDAPI or Form to XML functionality. Full details of the solution is found in the below document.

 

Reports_menu_from_Forms.zip