Sunday, January 13, 2013

Hebrew data not shown correct in Oracle Reports with Text format

Hi All,

Here the new issue that was found during the upgrade R11 to R12.1.3.
After the upgrade all reports in Text format not show the Hebrew correct.
The columns are right to left with data left to right.

Here the simple action plan to fix this issue - VPASTA!!!!

1. Log-in to Oracle Application > System Administrator > Install > Viewer Options 
2. Add the following line:
File Format: Text
Mime Type: apps/bidi
Description:  Pasta Viewer for bidi




3. Go to Profile > System and look for "Viewer: Application for Text:
4. Choose the Pasta Viewer for bidi in SITE level.


5. Add the following lines to your custom*.env file or to .bash_profile / .profile


TK_LOCALE="bidi"
export TK_LOCALE

6. Add the following lines to $FND_TOP/reports/<your_file>.prt
nls locale "arabic"
nls datastorageorder "logical"
nls contextuallayout "no"
nls contextualshaping "yes

* You can find the needed prt file according the concurrent name and it's style

7. Re-login with appl user and restart concurrent manager.
$INST_TOP/admin/scrips/adcmctl.sh stop
$INST_TOP/admin/scrips/adcmctl.sh start

Oracle Notes:
How to Setup EBS, VPasta, And Pasta for BIDI Languages [ID 839520.1]
HOW TO CONFIGURE PASTA FOR ARABIC? (Doc ID 816879.1)

Good Luck ...


1 comment:

  1. Hi Arty,
    Great post, I am quite sure others will save
    allot of time and pain by having this information.
    Keep it Up!
    Liron

    ReplyDelete