ORACLE APPS Configration Setting

Recommended Desktop Settings for Oracle eBS Applications

ARABIC Language Setting  in ORACLE

arabic words are unreadable in my oracle database
Insert and retrieve Arabic Characters – Oracle 10g
Oracle connection to retrieve or insert Arabic values from database
Oracle toad arabic font problem (Vert Important)
Re: Arabic characters are displaying as question marks in forms 10g (PDF Report)
How to Show Arabic Characters in Your Client App


CMD prompt can't display Unicode characters that are stored in oracle database correctly

Steps for Setting Arabic Language on PC

Control Panel (Regional and Language).

1. Install the Arabic Language (e.g. Arabic (U.A.E) from Control Panel
2. Administrative - Tab Set the Arabic (U.A.E) for "Language for non-Unicode Programs".
3. Format Tab - Set the Format "Arabic (U.A.E) -- Important for TOAD
4. Restart PC

Environment Setting

1. Set the Environment Variable "NLS_LANG= AMERICAN_AMERICA.AR8MSWIN1256"

Registry Setting

1. Set the "NLS_LANG= AMERICAN_AMERICA.AR8MSWIN1256" for all the Oracle Homes

default.env [DevSuiteHome_1\forms\server\default.env]

1. Set the "NLS_LANG= AMERICAN_AMERICA.AR8MSWIN1256" for all the Oracle Homes

ORACLE Patch Set (Checking)

To get the information regarding the Patchset into the Server

SELECT a.app_short_name, a.subdir, a.filename, b.version 

FROM   apps.ad_files a, 

       apps.ad_file_versions b 

WHERE  a.FILENAME like :FILENAME  --'apaprvls.pls' 

AND    a.file_id = b.file_id 

AND    a.app_short_name = 'SQLAP' --- e.g. : ASF, AMS.... 

AND    b.creation_date = (SELECT MAX (creation_date) 

                          FROM apps.ad_file_versions ver 

                          WHERE ver.file_id = a.file_id)​