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