How to Configure and Run Reports12c on any Browser Like (Firefox, Chrome,
Explorer).
===================================================================================
====================================
Before Configure Reports Server We Need to Set <<Under Code>> In Reports Forms.
===================================================================================
====================================
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
BEGIN
repid := find_report_object('PRODUCT_REPORT');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_SERVER, 'rep_wls_reports_oracle');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME, 'D:\WASIMSOFT\REPORTS\
PRODUCT_LEDGER.rdf');
v_rep := RUN_REPORT_OBJECT(repid);
message(v_rep);
WEB.SHOW_DOCUMENT('http://localhost:9002/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?server=rep_wls_reports_oracle');
END;
===================================================================================
====================================
Step-1
=============
Run your All Created BaseFile
Run Forms Builder and Login Reports
Then Make Sure Under my Directories url is same with your Directories url:-
go to this link C:\Oracle\Middleware\reports\conf\
copy (reports_ohs.conf) file
and past to C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\config\
fmwconfig\components\OHS\instances\ohs1\
then past the under code in the (reports_ohs.conf) file
<Location /reports>
SetHandler weblogic-handler
WebLogicHost localhost
WeblogicPort 9002
</Location>
===================================================================================
====================================
Step-2
=============
Again Make Sure Under my Directories url is same with your Directories url:-
go to this link C:\Oracle\Middleware\oracle_common\common\bin\
then run (WLST.cmd) file then follow under code:-
connect("weblogic1","weblogic1", "localhost:7001")
createReportsServerInstance(instanceName=’ittechbd’, machine=’AdminServerMachine’)
exit()
===================================================================================
====================================
Step-3
=============
Login WebLogic Server by Using Under url:-
http://localhost:7001/em
then click on ittechbd_domain > weblogic domain
click on -system mbean browser
-Application Defined MBeans
-oracle.reportsApp.config
-Server: WLS_REPORTS
-Application: reports
-ReportsApp
-rwservlet
then configure (Attributes under)
-2 allowhtmitags access value RW= yes
-27 WebcommandAccess value RW= L2
Then Click on Apply.
===================================================================================
====
Then configure -ReportsApp>rwserver (Operations under)
-click on 8 addEnvironment
-Id of the environment value= EN
Then click on Invoke then click on refresh.
===================================================================================
====
Then configure -rwserver>ReportsApp.Environment>click on EN (Operations under)
-click on 1 addEnvVariable
-EnvVariable Name value= NLS_LANG
Then go to Windows Regstry Editor:-
-HKEY_LOCAL_MACHINE
-SOFTWARE
-ORACLE
-KEY_OracleHome1
-Copy NLS_LANG and data url = AMERICAN_AMERICA.WE8MSWIN1252
past to under commend:-
-EnvVariable Value value= AMERICAN_AMERICA.WE8MSWIN1252
Then click on invoke.
===================================================================================
====
Again go to -rwserver>ReportsApp.Environment>click on EN (Operations under)
-click on 1 addEnvVariable
-EnvVariable Name value= Remove (NLS_LANG) and add (REPORTS_PATH)
Then go to Windows Regstry Editor:-
-HKEY_LOCAL_MACHINE
-SOFTWARE
-ORACLE
-KEY_OracleHome1
-add project form and report path end of url then Copy REPORTS_PATH and data
url
= C:\Oracle\Middleware\reports\templates;C:\Oracle\Middleware\reports\printers;D:\
WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS
past to under commend:-
-EnvVariable Value value= Remove (AMERICAN_AMERICA.WE8MSWIN1252) and add (C:\
Oracle\Middleware\reports\templates;C:\Oracle\Middleware\reports\printers;D:\
WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS)
D:\WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS
Then click on invoke.
===================================================================================
====
Again go to -rwserver>ReportsApp.Environment>click on EN (Operations under)
-click on 1 addEnvVariable
-EnvVariable Name value= Remove (REPORTS_PATH) and add (USER_NLS_LANG)
Then go to Windows Regstry Editor:-
-HKEY_LOCAL_MACHINE
-SOFTWARE
-ORACLE
-KEY_OracleHome1
-Again Copy NLS_LANG and data url =AMERICAN_AMERICA.WE8MSWIN1252
past to under commend:-
-EnvVariable Value value= Remove (C:\Oracle\Middleware\reports\templates;C:\Oracle\
Middleware\reports\printers;D:\WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS)
and add Again past (AMERICAN_AMERICA.WE8MSWIN1252)
Then click on invoke.
=======================================222=========================================
=======
go to -rwserver>ReportsApp.Engine>click on rwEng (Attributes under)
- 4 DefaultEnvId value= EN
- 13 MaxEngine value = 5
Then click on Apply.
===================================================================================
====
Again go to -rwserver>ReportsApp.Engine>click on rwURLEng (Attributes under)
- 4 DefaultEnvId value= EN
- 13 MaxEngine value = 5
- 15 MaxEngine value = 1
Then click on Apply.
===================================================================================
====
Step-4
=============
Again Make Sure Under my Directories url is same with your Directories url:-
go to - C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\config\
fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration
-open rwserver.conf
-stop this code <!--<security class="oracle.reports.server.RWJAZNSecurity"
id="rwJaznSec"/>-->
two line after remove Under this code
(securityId="rwJaznSec")
Then save.
===================================================================================
====
Step-5
=============
Again Make Sure Under my Directories url is same with your Directories url:-
copy this link - C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\config\
fmwconfig\components\ReportsToolsComponent\ittechbdReportsTools
Then go to this link - C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\
config\fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config
- open default.env
- go to end of page
- the past this code- COMPONENT_CONFIG_PATH=C:\Oracle\Middleware\user_projects\
domains\ittechbd_domain\config\fmwconfig\components\ReportsToolsComponent\
ittechbdReportsTools
- set forms and reports Path like this under:-
FORMS_PATH=D:\WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS;C:\Oracle\Middleware\forms;C:\
Oracle\Middleware\user_projects\domains\ittechbd_domain\config\fmwconfig\
components\FORMS\instances\forms1;D:\WASIMSOFT\FORMS;D:\WASIMSOFT\REPORTS
===================================================================================
====
Step-6
=============
Again Make Sure Under my Directories url is same with your Directories url:-
go to - C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\config\
fmwconfig\servers\WLS_FORMS\applications\formsapp_12.2.1\config\oracle\forms\
registry
- open Registry.dat
- find out this code - app.ui.lovButtons=false
- Then change like this - app.ui.lovButtons=true
- find out this code - app.ui.requiredFieldVABGColor=255,0,0
- then change like this - app.ui.requiredFieldVABGColor=255,255,153
Then save.
===================================================================================
====
Step-7
=============
Create Batch File For Run OHS_Server
===================================
Again Make Sure Under my Directories url is same with your Directories url:-
go to this link- C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\bin
Run startComponent.cmd or Create Batch file
StartOHS_Server.bat
C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\bin\startComponent.cmd
ohs1
Node Manager Info:-
Username:- weblogic1
Password:- weblogic1
Stop All BaseFile:-
Run cmd then past under code:-
cd C:\Oracle\Middleware\user_projects\domains\ittechbd_domain\bin
stopManagedWebLogic.cmd WLS_FORMS
stopManagedWebLogic.cmd WLS_REPORTS
stopWeblogic.cmd
stopNodeManager.cmd
stopComponent.cmd ohs1
http://oracle:9001/forms/frmservlet
check report server is run by using under url:-
http://localhost:9002/reports/rwservlet/getserverinfo
===================================================================================
====
