Arabic Is Printed in Reverse Order

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 Is Printed in Reverse Order

Symptoms:

Arabic is printing in wrong direction.
< !--[if !supportLineBreakNewLine]-->
< !--[endif]-->

- There are some parameters in pasta.cfg , .prt files and profile options need to be set correctly.
- There are two patches must be applied.
- Changing the printer driver for Pasta printing.

Solution:

To implement the solution, please execute the following steps:
1. Update pasta.cfg file (in $FND_TOP/$APPLRCS) in these lines to be:

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

2. In the pasta.cfg file : apply the following changes:

A. Area: %% ============== Font Name ======================== %%
From:
Font.Default.Plain=<FND_TOP>/<APPLRSC>/ADUO.ttf
Font.Default.Bold=<FND_TOP>/<APPLRSC>/ADUOB.ttf
Font.Default.Plain=<FND_TOP>/resource/ALBANWTJ.ttf
Font.Default.Plain=<FND_TOP>/resource/ALBANWTK.ttf
Font.Default.Plain=<FND_TOP>/resource/ALBANWTS.ttf
Font.Default.Plain=<FND_TOP>/resource/ALBANWTT.ttf
Font.Default.Plain=<FND_TOP>/resource/ALBANYWT.ttf
To:
Font.Default.Plain=<FND_TOP>/<APPLRSC>/ADUO.ttf ==> Put the physical path for <FND_TOP>/<APPLRSC>
Font.Default.Bold=<FND_TOP>/<APPLRSC>/ADUOB.ttf ==> Put the physical path for <FND_TOP>/<APPLRSC>

B. Area: %%%% ============= Language Specific Settings ============== %%%%
From:
%% For Western European (Latin-1) languages
[AMERICAN,CATALAN,GERMAN,DANISH,SPANISH,LATIN AMERICAN SPANISH,FRENCH,CANADIAN
FRENCH,ENGLISH,ITALIAN,ICELANDIC,NORWEGIAN,DUTCH,PORTUGUESE,BRAZILIAN
PORTUGUESE,SWEDISH,FINNISH]

Font.Default.Plain = printer:Courier
Font.Default.Bold = printer:Courier-Bold
To:
%% For Western European (Latin-1) languages
[AMERICAN,CATALAN,GERMAN,DANISH,SPANISH,LATIN AMERICAN SPANISH,FRENCH,CANADIAN
FRENCH,ENGLISH,ITALIAN,ICELANDIC,NORWEGIAN,DUTCH,PORTUGUESE,BRAZILIAN
PORTUGUESE,SWEDISH,FINNISH]

Font.Default.Plain=<FND_TOP>/<APPLRSC>/ADUO.ttf ==> Put the physical
path for <FND_TOP>/<APPLRSC>
Font.Default.Bold=<FND_TOP>/<APPLRSC>/ADUOB.ttf ==> Put the physical
path for <FND_TOP>/<APPLRSC>

3. PSTDL.prt, PSTLL.prt, PSTPL.prt, PSTWL.prt, L.prt, W.prt, and P.prt in $FND_TOP/reports should contain the following layout:

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

4. If you find the following Lines in the .prt files then remove them then add them to the Environment file :

REPORTS60_PRINTER_CODE_BEFORE=&5
export REPORTS60_PRINTER_CODE_BEFORE
REPORTS60_PRINTER_CODE_AFTER=&4
export REPORTS60_PRINTER_CODE_AFTER

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.

5. Two Patches must be applied for 11i before 11.5.10.2 (RUB5).
Patch: 3288588 and
Patch:3291188
If it is not applied, kindly apply these two patches.

6. From the System Administrator responsibility > Install > Viewer Options
add new record

File Format: 'Text'
Mime Type: 'apps/bidi'
Description: 'Pasta Viewer for bi-di'

7. Change profile 'Viewer: Application for Text' to be:

'Pasta viewer for bi-di' instead of 'Browser'

For all levels (Site, Responsibility and User).
8. Change the type of the printer to be:
--Pasta Universal instead of Pasta Post Script
9. According to
Note:291791.1 Oracle Applications Concurrent Processing Rollup Patch G
the section of : Native Client Encoding in Report Viewer:

Online Report Review allows users to view the output of Concurrent Requests.
The Report Viewer is now able to honor the FND: Native Client Encoding profile option.
When enabled, the Report Viewer will convert the output file into the character
set specified in the FND: Native Client Encoding profile. To enable this support,
there is an Allow Native Client Encoding checkbox for each MIME type in the Viewer
Options form.

10. Stop Concurrent Managers and make sure that all FNDLIBR processes are gone
11. Start Concurrent Managers again and rerun the report.

References:

Arabic Is Printed in Reverse Order [ID 552977.1]

NOTE:203718.1 - Arabic is Not Properly Aligned in Oracle Applications Reports
NOTE:291791.1 - Oracle Applications Concurrent Processing Rollup Patch G

Get Oracle Certifications for all Exams
Free Online Exams.com