MWA In Oracle Applications

MWA In Oracle Applications

MWA is mobile web application. Using this we can have Oracle Application on mobile, MWA service is used in E-Business suite for running the applicaiton on mobile.

Configuration Files

• mwa.cfg: This file has information about the DBC file location, Log Dir Location, Telnet Port no Location, Error Logging Level etc.
This info will be used by Mobile Applications on runtime.
• default_key.ini: This file is used to map the keys of the mobile device to some specific functionality.
Use the default file if you don’t want to customize anything.
• deviceIP.ini: This file maps the configuration files and host name with the mobile device
MWA server start-up and shutdown:
• mwactl.sh: This file is used to start/stop the MWA listener on specific port.
Basically, if you develop and deploy a Mobile page into the instance, you have to bounce the MWA server by
Stopping and starting the Listener at your port to see your changes.

Start/stopping Listener

Start:
mwactl.sh start <port no>
Stop :
mwactl.sh -login <userid/pwd> stop_force <port no>

File Location

Directory Structure in R11
$MWA_TOP/bin
$MWA_TOP/secure

Directory structure in R12
$INST_TOP/admin/scripts
$INST_TOP/admin/install
(eg)In R12, INST_TOP may look like:
/u01/appldev/DEV/inst/apps/DEV_w-oraap01

MWA GUI Client Setup

In order to simulate the Mobile Device on your PC, you have to do the following setup:

Step 1:
Create 2 directories say C:\MWA\lib and C:\MWA\log
Extract the files from the patch 4205328 into C:\MWA\lib

Step 2:
Download jdk1.1.8 from java.sun.com and place it in C:

Step 3:
Create a batch file say Start_MWA.bat with the following contents
set MWA_GUI_TOP=C:\MWA\
set JAVA_TOP=c:\jdk1.1.8
%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.client.StartGUI

Step 4:
Whenever you run this batch file, you must be able to see the GUI client for MWA


The log files are located under $INST_TOP/logs (in R12).

Mainly we will be using the following log files to see our log files.
All the log files start with Telnet_port_no as a prefix.

Example log files for port no 10240:
[appldev@w-oraap01 logs]$ pwd
/u01/appldev/DEV/inst/apps/DEV_w-oraap01/logs
[appldev@w-oraap01 logs]$ ls -al 10240*
-rw-r--r-- 1 appldev dba 255626 Feb 8 13:28 10240.INV.log
-rw-r--r-- 1 appldev dba 83 Feb 8 13:26 10240.sta
-rw-r--r-- 1 appldev dba 154063 Feb 8 13:50 10240.system.log
-rw-r--r-- 1 appldev dba 3296 Feb 4 11:11 10240.WMS.log
[appldev@w-oraap01 logs]$

All the log information written using the “UtilFns” will be located under <port_no>.INV.log
All the system level log like page names, parameter passed to PLSQL APIs, LOVs etc can be found under <port_no>.system.log

Easiest way to look at log files:

Since the volume of information written in the log file is huge, it is tough to go through the entire file.
A simpler way to find the log information is to run the command
tail -f 10240.INV.log

By doing so, you can see the updated log information as and when you click on the fields on mobile application.

MWA Services in Oracle Apps

Login as applmgr user :
Go to $ADMIN_SCRIPTS_HOME
Stop Mobile Application Services :
./mwactl.sh -login apps/apps_password stop_force
./mwactlwrpr.sh stop apps/apps_password
Start Mobile Application Services :
./mwactl.sh -login apps/apps_password start
./mwactlwrpr.sh start apps/apps_password
Check Mobile Services are up and Runing:
ps -ef | grep mwa

Find port Number of Mobile Services :
grep mwa $CONTEXT_FILE
Connect to Mobile Services :
telnet hostname.domainname portnumber(mobile application service port_number)

How to check it is working or not:
Start  Run cmd telnet hostame:portnumber   press enter  , it will show 4 options select , appropriate option & give username & password.

netstat -a|grep 10220<port no>

Login to sysadmin/sysadmin.
system administrator–>Oracle Applications Manager–>Hosts—->view configuration .
you can find the “MSCA Server Port Number 10200-10205”
To test whether MWA is started . Type
“telnet hostname.domainname 10200”