Problem :
Special characters, umlauts/diacritics or currency symbols are not shown correctly on the reports. Opera 5.5 |
Cause :
Incorrect NLS_LANG configuration of the weblogic server
Solution: 
The NLS_LANG parameter has to be updated in the rwserver.conf - the path is slightly different on Opera 5.6 with WebLogic 12c.
Locate the rwserver.conf in the subfolder within the path below.
On WebLogic 11g (Opera 5.5) - D:\ORA\operainstance\config\ReportsServerComponent
The subfolder name is "rep + HOSTNAME + the database username (for example: repOPERASERVEROPERA when the hostname is OPERASERVER and the database schema is OPERA)
Open the rwserver.conf and locate the line:
<engine class="oracle.reports.urlengine.URLEngineImpl" engLife="50" id="rwURLEng" maxEngine="1" minEngine="0"/>
Under this line, add the entries below and update it with the NLS_LANG parameter. Most common is NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
<environment id="DEFAULT">
<envVariable name="NLS_LANG" value="AMERICAN_AMERICA.WE8MSWIN1252"/>
</environment>
After this, restart the report servers and the WLS_REPORTS server component to activate the change.