Arabic in pdf reports

Arabic is not possible in 6i pdf reports. The two solutions which is possible are following :

1. Use xml publisher and develop all reports in xml.

2. Install Acrobat distiller software in ur PC (client machine). Develop report in 6i. And register that report output format as PostScript format. But in this you will have to install Acrobat Distiller on every users PC who is using this report.

arabic report coming as question marks ???????

The standard report was not coming with arabic data though character set supports Arabic :

There are two solutions :

1. Try set profile option FND: NATIVE CLIENT ENCODING to ARISO..... or ARWINS.....


OR


2. Use pasta viewer to view non english language :

login through sysadmin > install > viewer > add a new line
text apps/bidi pasta viewer


-----------------------------------------

search .prt file you are using with the help of below query --


SELECT PRINTER_DRIVER_NAME, USER_PRINTER_DRIVER_NAME, PRINTER_DRIVER_METHOD_CODE, SPOOL_FLAG, SRW_DRIVER, COMMAND_NAME, ARGUMENTS, INITIALIZATION, RESET
FROM FND_PRINTER_DRIVERS
WHERE PRINTER_DRIVER_NAME = (SELECT PRINTER_DRIVER
FROM FND_PRINTER_INFORMATION
WHERE PRINTER_STYLE = (SELECT PRINT_STYLE
FROM FND_CONCURRENT_REQUESTS
where request_id = <>) AND PRINTER_TYPE = (SELECT PRINTER_TYPE
FROM FND_PRINTER
WHERE PRINTER_NAME = (SELECT PRINTER FROM FND_CONCURRENT_REQUESTS where request_id = <>)))



insert these lines in .prt file at the end

----------------------------------------
nls locale "arabic"
nls datastorageorder "logical"
nls contextuallayout "no"
nls contextualshaping "yes"
-------------------------------------------


set this in system profile options :
Viewer: Application for Text = pasta viewer

OFA client error odbc32.dll or odbcnt.dll

While installing Oracle Financial Analyzer client software you get some error regarding odbc32.dll or odbcnt.dll

rename odbc32.dll and odbcnt.dll in c:/windows/system32

and press retry

default values in discoverer plus login page

If you want these values default on your discoverer 10g plus/Viewer login page.

Connect to :
Database :

Edit your URL as follows :

http://disc-host.disc-domain:disc-port/discoverer/viewer?connectionAccessType=APPS&Database=database-SID

http://disc-host.disc-domain:disc-port/discoverer/viewer?connectionAccessType=APPS&Database=database-SID


replace the original value for bold characters