Arabic Characters shows unreadable in concurrent request outputs

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Arabic Characters shows unreadable


Active user concurrent request output shows Arabic characters as:


+---------------------------------------------------------------------------+
ãßÊÈÉ æÍÏÇÊ ÇáÊØÈíÞÇÊ: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

FNDSCURS module: ÇáãÓÊÎÏãæä ÇáäÔØæä
+---------------------------------------------------------------------------+

æÞÊ ÇáäÙÇã ÇáÍÇáí åæ 04-07-2010 13:33:24

+---------------------------------------------------------------------------+


+-----------------------------
| ÈÏÇíÉ ÊäÝíÐ ÈÑäÇãÌ ÇáÊÒÇãä...
+-----------------------------


Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
ARABIC_UNITED ARAB EMIRATES.AR8ISO8859P6

FileName
----------------

URL
------
https://support.us.oracle.com/oip/faces/filedownloadservlet?ObjectType=SR&ObjectNo=3-1902837891&FileName=Active_Users_040710_view_log.mht







****


select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
AR8ISO8859P6
select * from nls_database_parameters where parameter = 'NLS_LANGUAGE';
AMERICAN
select * from nls_database_parameters where parameter = 'NLS_TERRITORY';
AMERICA

the value of profile option 'FND: NATIVE CLIENT ENCODING' ?
AR8MSWIN1256




Solution:


 follow steps detailed in note 555686.1


Details from note: 555686.1

Please check that the TK_LOCALE and IX_PRINTING are set properly in the environment ,

You can run the request
"Generate concurrent processing environment information"
to check how the TK_LOCALE and IX_PRINTING is set.
Solution

1- Shutdown the managers.

2- take a backup from the files :
adcmctl.sh , gsmstart.sh Under the $COMMON_TOP/admin/scripts

3- In the 2 files >> edit >> under the display section

the section that is like
"
#
# Set the DISPLAY variable regardless of how it is set in the
# current environment.
#
DISPLAY="fasmwi:0.0"
export DISPLAY
"

i want to add the following :

IX_PRINTING="/p01/oramwip/mwipappl/fnd/11.5.0/resource/ixlib.cfg"
export IX_PRINTING

TK_LOCALE="bidi"
export TK_LOCALE

Please do not forget to adjust the above path as in your instance.

4- Restart the managers and retest the issue.


Besides try the below


From the System Administrator responsibility
>Install >Viewer Options
ADD new record
File Format: 'Text'
Mime Type: 'apps/bidi'
Description: 'Pasta Viewer for bi-di'

Change profile 'Viewer: Application for Text' to be 'Pasta viewer for bi-di' instead of 'Browser'

FND: NATIVE CLIENT ENCODING This profile option needs to match the database characterset to ensure a proper output. If this profile option is different from DB characterset, then it's common to find issues when printing, exporting, generating reports. Therefore, the recommendation for this profile option is that it should match the database characterset.

Also Try:

1- please add teh following lines to the .prt files in $FND_TOP/reports

nls locale "arabic"
nls datastorageorder "logical"
nls contextuallayout "no"
nls contextualshaping "yes"
code "4" esc "[4m"
code "5" esc "[5m"

2- In the enviroment file that you source before starting the concurrent manager :

set both the IX_Printing and
IX_Rendering to the full path of Pasta.cfg file used .

3- add teh following lines to the environment file ( .env file)
REPORTS60_PRINTER_CODE_BEFORE=&5
export REPORTS60_PRINTER_CODE_BEFORE
REPORTS60_PRINTER_CODE_AFTER=&4
export REPORTS60_PRINTER_CODE_AFTER

4- Stop Concurrent Managers and make sure that all FNDLIBR processes are gone
5- restart and re-test the arabic report 

Also Try:

A- in the pasta_bidi.cfg file please change the
bidi_algorithm=unicode
to
bidi_algorithm=oracle

B)-
1- login to sysadmin
2- Install -> viewer options
3- search on file format =text and Mime type= text/plain
4- toggle the value for 'Allow native encoding' ( ensure that the checkbox is not checked)

c) rebounce teh concurrent manager so that changes take effect 

Get Oracle Certifications for all Exams
Free Online Exams.com