11g Fusion Middleware: Forms And Reports Architecture

FORMS:

$MW_HOME=/as10g/jay_uat/product/middleware/11.1 (Top level directory used by fusion middleware)

configuration and log files of opmn managed process will be under $ORACLE_INSTANCE i.e /as10g/jay_uat/product/middleware/11.1/fr_inst_uat2

Fusion Middleware forms architecture Flow:

Verification url for typical installation would be http://hostname:port/forms/frmservlet/

Initially Request will go to http server . Apache conf files will be under $ORACLE_INSTANCE/config/OHS/ohs1/httpd.conf  and location match for  forms
will be  defined in $ORACLE_INSTANCE/config/OHS/ohs1/moduleconf/forms.conf . This forms.conf will have the hostname and port number of  WLS_FORMS managed server.

<Location /forms>
 SetHandler weblogic-handler
 WebLogicCluster    jaydev16.domain.com:9005 (port number which has been defined in $DOMAIN_HOME/config/config.xml)
 DynamicServerList OFF
</Location>

Based on this file it will attach the request from http://hostname:port/forms/frmservlet/  to the correct managed server.


Custom Application Forms Architecture:

This is the url http://jaydev16.domain.com:8060/forms/frmservlet?config=snflwr_05000000_proxy_JAYUAT

so for this ,basic forms url should work.so as a first troubleshooting stuff,we have to make sure http://jaydev16.domain.com:8060/forms/frmservlet is working.

weblogic WLS_FORMS managed server config files will be under $DOMAIN_HOME/config/fmwconfig/servers/WLS_FORMS/applications/formsapp_11.1.1/config/

for WLS_FORMS ,main config files will be formsweb.cfg. It will have location match section  like this. which has java file location and database connectivity etc

[snflwr_05000000_proxy_JAYUAT]
baseHTML=/as10g/jay_uat/snflwr/5.0.0.0/appserver/web_files/forms/base.htm
baseHTMLjinitiator=/as10g/jay_uat/snflwr/5.0.0.0/appserver/web_files/forms/basejpi.htm
baseHTMLjpi=/as10g/jay_uat/snflwr/5.0.0.0/appserver/web_files/forms/basejpi.htm
baseHTMLie=/as10g/jay_uat/snflwr/5.0.0.0/appserver/web_files/forms/baseie.htm
userid=SAPUB/xxxxxxxxxxxxxx@JAYUAT
envfile=/as10g/jay_uat/snflwr/5.0.0.0/appserver/conf/formservlet.ini

envfile is one of the important parameter. The forms rum time process (client) will use this file to set the environment (like $TNS_ADMIN,$ORACLE_INSTANCE).
based on this only it will resolve database name.Here anyfile which connnects through
http://jaydev16.domain.com:8060/forms/frmservlet?config=snflwr_05000000_proxy_JAYUAT will use /as10g/jay_uat/snflwr/5.0.0.0/appserver/conf/formservlet.ini file to set the environment.

so if there is any problem in database connectivity from forms,make sure formsweb.cfg is pointing to correct env file and check that env file is having proper values or not

if we don't specify any env file,there is another one file called default.env will be used.

Reports :

Similar to forms,For reports http://hostname:port/reports/rwservlet/ should work as basic test.
Similar to forms ,location match reports will be defined under $ORACLE_INSTANCE/config/OHS/ohs1/moduleconf/reports_ohs.conf. so based on this file,it will
attach the request to propert managed server WLS_REPORTS.

<Location /reports>
 SetHandler weblogic-handler
 WebLogicHost jaydev16.domain.com
 WebLogicPort 9009 (WLS_REPORTS port number which has been defined in $DOMAIN_HOME/config/config.xml)
</Location>

and also one more thing there is one file called rwnetwork.conf .port number defined in
that file should be same in all the places.Below are locations .

$ORACLE_INSTANCE/config/ReportsToolsComponent/ReportsTools/rwnetwork.conf
$ORACLE_INSTANCE/config/ReportsServerComponent/rep_snflwr_05000000_JAYUAT/rwnetwork.conf
$DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.1.2.0/configuration/rwnetwork.conf



Reports URL:(THis is just sample url to explain important parameters)
https://JAYUAT.domain.com:8061/reports/rwservlet?cmdkey=snflwr_report_JAYUAT&server=rep_snflwr_05000000_JAYUAT&delimited_hdr=no&delimiter=none&destype=cache&mimetype=application/pdf&mode=default&report=saad6010


cmdkey --> It will be having database credentials.it will be defined in $DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_11.1.1.2.0/configuration/cgicmd.dat



;;;;;;;;;;;;;;;;;;;;;;;;;;
snflwr_report_JAYUAT: userid=SARPT/xxxxxxxxxxxxxx@JAYUAT %*
;;;;;;;;;;;;;;;;;;;;;;;;;;


server --> Report server name.we have created on report server(rep_snflwr_05000000_JAYUAT)
 under opmnctl.

Config files:$ORACLE_INSTANCE/config/ReportsServerComponent/rep_snflwr_05000000_JAYUAT/rwserver.conf

This file will have the details of where it has to pick the reports.

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="1" maxIdle="30" callbackTimeOut="60000" classPath="/
as10g/jay_uat/snflwr/5.0.0.0/appserver/reports/IDADataMatrix.jar:/as10g/jay_uat/snflwr/5.0.0.0/appserver/reports/LinearBarCode.jar">
   <property name="sourceDir" value="/as10g/jay_uat/snflwr/5.0.0.0/appserver/reports:/as10g/jay_uat/snflwr/5.0.0.0/appserver/ext/reports"/>