When using Arabic language in NLS_LANG, the day and month names are written in Arabic, and if the RWSERVLET character set is not Arabic, RWSERVLET will fail to interpret the characters specified in the parameter form.
Check detailed explanation on NLS setup:
http://oracleapps4u.blogspot.com/2011/03/report-builder-national-language.html
This is due to the fact that language and territory specified in NLS_LANG affect the date items as following:
NLS_LANG=language_territory.charset
language : Specifies the language for day and month names.
territory : Specifies the territory and its conventions for calculation of week and day numbers.
territory : Specifies the territory and its conventions for calculation of week and day numbers.
To Display Date in Arabic
Use this solution to display day and month names in Arabic
Define Arabic character set for RWSERVLET
1. Edit the file ORACLE_HOME/reports/conf/rwservlet.properties.
2. Define the parameter DEFAULTCHARSET (Check the below post for the supported values for DEFAULTCHARSET: http://oracleapps4u.blogspot.com/2011/04/supported-values-for-defaultcharset-in.html )
2. Define the parameter DEFAULTCHARSET (Check the below post for the supported values for DEFAULTCHARSET: http://oracleapps4u.blogspot.com/2011/04/supported-values-for-defaultcharset-in.html )
For example:
DEFAULTCHARSET=windows-1256
3. Restart the OC4J OC4J_BI_Forms for the changes to take effect.
Use this solution if you want to display English names for day and month in combination with Arabic text.
(1) Use environment variable NLS_DATE_LANGUAGE to specify English date language. For example, in Unix/Linux platforms, you can define it in $ORACLE_HOME/bin/reports.sh:
NLS_DATE_LANGUAGE=English; export NLS_DATE_LANGUAGE
- OR -
(2) Use NLS_LANG=AMERICAN_territory.AR8MSWIN1256.
Check out the blog post for the setups involved in developing Arabic PDF report:
http://oracleapps4u.blogspot.com/2011/03/report-builder-national-language.html
