Tuesday, June 21, 2011

How can one avoid having question marks displayed in seeded text reports? Pasta Configuration

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:


How can one avoid having question marks displayed in seeded text reports?


Problem Description: Arabic characters display like ??? on HTML


run concurrent request "Active Users" and from the language choose Arabic,view the request log and or request output shows ???


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="<server>:0.0"
export DISPLAY
"

please  add the following :

IX_PRINTING="<Path_of_fnd_top>/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.



Also


do the following

1 - Remove TK_LOCALE="bidi" from the files adcmctl.sh , gsmstart.sh

2 - Set the following in the pasta_bidi.cfg file AND ixlib.cfg file :

dolayout=n
doshaping=y
direction=rtl
bidialgorithm=oracle

3 - Bounce the concurrent managers for the update to take effect .

4 - Run the "Generate concurrent processing environmnent variable" concurrent program in order to check that the variables TK_LOCALE is well unset .



References:


As described in Note How 839520.1 , please set the variables REPORTS_PRINTER_CODE_BEFORE and REPORTS_PRINTER_CODE_AFTER  manually in the $APPLFENV file , so without using autoconfig


This can be done by proper setup of PASTA using the following documents:
Note 816879.1 - HOW TO CONFIGURE PASTA FOR ARABIC
Note 839520.1 - How to Setup EBS, VPasta, And Pasta for BIDI Languages 

Note 552977.1 : Arabic Is Printing in Reversed Order


In order to know teh version of pasta , please run the executable FNDPSTAX from the $FND_TOP/bin directory:

$ cd $FND_TOP/bin
$ FNDPSTAX



enable the debug option of pasta using the Metalink Note 267026.1



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: