Configure Oracle 12C - Reports Step-6

Oracle 12C Reports Configurations

Open Internet Browser  and goto: http://localhost:7001/em
Enetr Username: weblogic
Password:OrAcLe_2016

click SIGN IN

1.  In the Upper Right ,click Weblogic Domain
   It expands to display, multiple componnets ,
   click System MBean Browser
2. on the System MBean Browser page :
   expand    : oracle.reportsApp.config
   then     : Server: WLS_REPORTS
   then    : Application: reports
   then      : ReportsApp
3. Select rwservlet on  the right  Application Defined MBeans: ReportsApp:rwservlet :
   Change the following
   PARAMETER                     VALUES:
   WebcommandAccess L2
   allowhtmltags yes
   server                       Insight_Rep_Srvr
4. After you finish , click APPLY

ReportsApp:rwserver

1. From the left menu , choose rwserver
   ** from the right Application Defined MBeans: ReportsApp:rwserver
2. Choose Operations tab :
   click addEnvironment
   Value : AR
   click Invoke
3. on the same page modify AR to EN
   click Invoke
4. on the upper right , click Refresh circle arrow
5. on the left menu , expand ReportApp.Environment , you should find AR , En  variables
6. On the left menu , expand ReportApp Engine (Application Defined MBeans:ReportsApp.Engine:rwURLEng):
   click rwURLEng
   change Value of DefaultEnvId                   : EN
   change Value of JvmOptionsJvmOptions: -Xmx1024m (to avoid REP-69 : Java heap space)
7. After you finish , click APPLY,
8. On the left menu , expand ReportApp Engine (Application Defined MBeans: ReportsApp.Engine:rwEng):
   click rwEng
   change Value of DefaultEnvIdDefaultEnvId : AR
9. After you finish , click APPLY

Apply Arabic Display (Right to Left) :

1. on the left menu , expand ReportApp.Environment :
   click AR
2. Choose Operations tab :
   click addEnvVariableValue
   NLS_LANG  ARABIC_EGYPT.AR8MSWIN1256click Invoke
3. on the same page Change existing Value to  USER_NLS_LANG
   click Invoke
4. on the same page modify 
   Change existing Value to  REPORTS_TMP
   next line Value : C:\TMP
   click Invoke
5. Goto C:\ and create TMP Folder
6. on the same page modify 
   Change existing Value to  : REPORTS_BIDI_ALGORITHM
   with new line value : UNICODE
   click Invoke
7. on the same page modify 
   Change existing Value to  : REPORTS_ENHANCED_BIDIHANDLING
   with new line value : Yes
   click Invoke
8. on the same page modify 
   Change existing Value to  : REPORTS_ARABIC_NUMERAL
   with new line value : HINDI
   click Invoke
9. on the same page modify 
   Change existing Value to  : REPORTS_PATH
   with new line value : D:\Oracle\Middleware\reports\templates;D:\Oracle\Middleware\reports ; \printers;c:\Windows\Fonts;d:\WorkArea\REPORTS;
   click Invoke**open Regedit,  add the same path to the following KEY:
   HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OracleHome1\REPORTS_PATH

Apply English Display (Left to Right) :

1. On the left menu , expand ReportApp.Environment :
   click EN
2. Choose Operations tab :
   click addEnvVariable
   Value
   NLS_LANG  AMERICAN_AMERICA.AR8MSWIN1256click Invoke
3. on the same page Change existing Value to  USER_NLS_LANG
   click Invoke
4. On the same page Change existing Value to  REPORTS_TMP
   next line Value        :C:\TMP
   click Invoke
5. On the same page Change existing Value to : REPORTS_ARABIC_NUMERAL
   with new line value : ARABIC
   click Invoke
6. on the same page modify 
   Change existing Value to  : REPORTS_PATH
   with new line value : D:\Oracle\Middleware\reports\templates;D:\Oracle\Middleware\reports ; \printers;c:\Windows\Fonts;d:\WorkArea\REPORTS;
   click Invoke
   **open Regedit,  add the same path to the following KEY:HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OracleHome1\REPORTS_PATH
7. On the same page modify 
   Change existing Value to  : REPORTS_BIDI_ALGORITHM
   with new line value         : UNICODE
   click Invoke
8. On the same page modify 
   Change existing Value to  : REPORTS_ENHANCED_BIDIHANDLING
   with new line value         : Yes
   click Invoke

Fixing Arabic Font doesn't display :

Replace uifont.ali in the following paths with attached uifont.ali:

1. D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\ReportsToolsComponent\INSIGHT_Rep_Tools\tools\COMMON
2. D:\Oracle\Middleware\user_projects\domains\insight\config\fmwconfig\components\ReportsToolsComponent\INSIGHT_Rep_Tools\guicommon\tk\admin

you're done :-)

 

Update #1: 

• Open Registry --> TK_PATH  ( C:\oracle\Middleware\tools\common )
• add uifont.ali file 
  

Update #2 : 

How To Access http://localhost:9002/reports/rwservlet/showjobs , it's very useful to see jobs queue , showenv, serverinfo etc....

1.  open Web Browser then Goto :  http://localhost:9002/reports/rwservlet/showjobs
2. If you prompted to enter User name and Passwrod , then
• Stop WLS_REPORTS
• Edit  rwserver.conf in this path
  D:\Oracle\Middleware\user_projects\domains\SitKSA\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf
• Remove line which has SECURITY
• Remove   word : Security_Id 
• Remove  securityId="rwJaznSec"
• Save and restart WLS_REPORTS
3. REP-52262: Diagnostic output is disabled.
• FIX Web Webcommandaccess
4. When logging to localhost:9002/reports cannot login?
• It may be as aresult of SSL , so you do have 7002 & 9002