Oracle Apps: Enable Arabic for Reports

 Q:   I have Toad for Oracle 9.5  installed on XP professional and have Oracle 10.2.0.3.0. I have Arabian characters in my DB and I need to view the same in Toad data grid. but how can I enable the same? Please suggest me the navigation path also to achieve the same?

Q:  Oracle Repot Builder / SQL Plus / Toad / PL-Sql Developer, Arabic Data is showing as ???????????????

Q:   How to enable Arabic for Oracle EBS R12 Reports?

Q:  How to set NLS_CHARACTERSET at client side for Oracle Apps Reporting?

Answer:

Steps 1:  Set Operating System Regional and Language Options.

From the Start Menu, go to ‘Settings’.
Click on ‘Control Panel’.
Double Click on the “Regional and Language Options” control panel.
go to advanced an right check all arabic languages

and windows will ask you to restart Server

Step 2: Set NLS_LANG Characterset

From the Start Menu, go to ‘Run’.
write regedit and press OK.

HKEY_LOCAL_MACHINE –>SOFTWARE–>ORACLE–>ORACLEHOME

Go to the Registry value from NLS_LANG=