MWA Setup
This article will explain to you 
a. Where the Mobile Web Apps config files are located
b. MWA Startup and Shutdown Scripts and how those are used
c. Directory Structure for MWA in both 11i and R12
d. How to develop and test your pages
e. Where the log files are created, and tips to debug MWA Applications
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
Stop :
mwactl.sh -login stop_force
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
Development and Deployment:
The development of Mobile Applications can be done using any IDE like JDeveloper, Eclipse etc. After that in order to
test the application, we have to deploy it in the Apps instance say in a directory like $JAVA_TOP/xxx/custom/server.
In order to test it, we should have our own function in AOL. This function should refer to the Function Java Class
name of the Mobile Application
(eg) xxx.custom.server.CustomTestFunction
After doing so, we have to attach this function to submenu and then to the Mobile Navigation Menu
After doing so, your menu entry will come into your mobile application and you can test your new pages
MWA Error Logging and Debugging:
When you develop and test mobile applications, you may need to write some logging information which will be useful in debugging.
There are different levels of Logging that can be set for obtaining more debug information.
The different Log level from highest to lowest is as follows:
-
fatal
error
warning
debug
trace
This logging information can be set using the “mwa.LogLevel” variable in mwa.cfg file.
How to write logging information?
While we code, we can call the APIs to log the information. The methods used for logging can be found in the following Java helper class.
oracle.apps.inv.utilities.server.UtilFns
For example, we can use the following code snippets and based on the log level set, we can find this information from the log files.
UtilFns.trace("#########Trace Level Logs#########");
UtilFns.log("#########Log level logs#########");
UtilFns.error("#####Error Level logs#########");
There are lot of other utility APIs available in this helper class (UtilFns.java) which can be used for various other aspects.
Example code snippet for error logging:
public void fieldEntered(MWAEvent mwaevent)
{
UtilFns.trace("Inside Field Entered");
ses = mwaevent.getSession();
String s = UtilFns.fieldEnterSource(ses);
// Prints the Current Bean's ID
UtilFns.trace("CustomFListener:fieldEntered:fldName = " + s);
}
In the above snippet, we print a message “Inside Field Entered” when the user enters any field in the Mobile Application
Also, we print the name of the field using the line
UtilFns.trace("CustomFListener:fieldEntered:fldName = " + s);
Please note that, the above log messages can be found only when the log level is set to “trace” in mwa.cfg file.
Where to look for log information?
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 .INV.log
All the system level log like page names, parameter passed to PLSQL APIs, LOVs etc can be found under .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 which I used 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.
For MSCA/OAF consulting kindly contact us at
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Set as favorite
Bookmark
Email This
Hits: 12150
Comments
(103)
Subscribe to this comment's feed
FileSystemLogger
written by mmitraa , February 27, 2008
written by mmitraa , February 27, 2008
FileLogger.getSystemLogger().trace can also be used for tracing purpose....What is the basic difference between Utilfns.trace and FileLogger.getSystemLogger().trace. Pls explain...
Votes: +0
report abuse
vote down
vote up
Oracle Apps HRMS Functional
written by Raghava Chaitanya , February 27, 2008
written by Raghava Chaitanya , February 27, 2008
Hi Anil
I am a recruiter
I am very much interested in Oracle Apps HRMS FUnctional Module
I did apps learning course from a private institute for Core HR and iRecruitment and OLM
I could get a relative idea on these modules. But when comming to realtime scenario I am feeling it very different
I want to be frank that I am planning to start entering into a consultant level as a fresher
but I dont have those opportunities
Atleast make me thorrow in Oracle Apps with any of the modules Focusing COre HR and Payroll
with real time examples
I have gone through your site and i appreciate that you share your knowledge with others too
And that made me dare to ask your help as I need it
please keep me updated posted to my email id for the first time atleast with a positive response
I will keep in touch
Thanks
Raghav
Votes: -2
I am a recruiter
I am very much interested in Oracle Apps HRMS FUnctional Module
I did apps learning course from a private institute for Core HR and iRecruitment and OLM
I could get a relative idea on these modules. But when comming to realtime scenario I am feeling it very different
I want to be frank that I am planning to start entering into a consultant level as a fresher
but I dont have those opportunities
Atleast make me thorrow in Oracle Apps with any of the modules Focusing COre HR and Payroll
with real time examples
I have gone through your site and i appreciate that you share your knowledge with others too
And that made me dare to ask your help as I need it
please keep me updated posted to my email id for the first time atleast with a positive response
I will keep in touch
Thanks
Raghav
report abuse
vote down
vote up
...
written by Raghava Chaitanya , February 27, 2008
written by Raghava Chaitanya , February 27, 2008
RE: What is date tracking, how it is used in HRMS ?
--------------------------------------------------------------------------------
Hi,
Well date tracking isa feature in Oracle HRMS esp with all tables whose name send with _F eg:per_all_people_f .Now what happens here is we cannont purge a record what we can do is endate a record and if we need to create an extension eg: of an assignment then we end-date the assignment and on a new record that is appended to the table we create a new record with starting date after the eend date and can restate the assignment, used in cases of Re-hire after end of assignment or in the extension of assignment beyond the end date. It helps Oracle maintain historical data and hence the tables are data trackable
Votes: -2
--------------------------------------------------------------------------------
Hi,
Well date tracking isa feature in Oracle HRMS esp with all tables whose name send with _F eg:per_all_people_f .Now what happens here is we cannont purge a record what we can do is endate a record and if we need to create an extension eg: of an assignment then we end-date the assignment and on a new record that is appended to the table we create a new record with starting date after the eend date and can restate the assignment, used in cases of Re-hire after end of assignment or in the extension of assignment beyond the end date. It helps Oracle maintain historical data and hence the tables are data trackable
report abuse
vote down
vote up
FileLogger
written by mmitraa , February 28, 2008
written by mmitraa , February 28, 2008
Basically i don't have much knowledge what UtilFns does. Can you publish any doc related to this ? if you have any doc pls fwd it to me on my email id This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Where as FileLogger is concerned it will log the error messaged into port.system.log file. you can user methods like .trace/ .error etc
report abuse
vote down
vote up
...
written by mmitraa , February 28, 2008
written by mmitraa , February 28, 2008
is there any other option needs to be setup other than setting log option to trace.....in mwa.cfg file. ???????
because i used UtilFns toooo but never seen it logging anything in INV.log file....
Votes: +0
because i used UtilFns toooo but never seen it logging anything in INV.log file....
report abuse
vote down
vote up
...
written by mmitraa , February 28, 2008
written by mmitraa , February 28, 2008
yes.....is there any other option that i need to set ? i'm in 11.5.10
Votes: +0
report abuse
vote down
vote up
...
written by mmitraa , February 28, 2008
written by mmitraa , February 28, 2008
another thing i wanted to know ....what are the possible values and meaning for MWA: Debug Level ?
Votes: +0
report abuse
vote down
vote up
Oracle Mobile Supply Chain Technical - Is anyone interested........
written by jabastion , March 14, 2008
written by jabastion , March 14, 2008
Title: Oracle Mobile Supply Chain Technical
Location: FL
Duration: 3-6 months
Job description:
Our company is handling the global implementation of Oracle Applications for a multi-billion dollar European conglomerate. Their Application Systems are managed and we are in need for an Oracle Technical expert to assist in the Installation and Configuration of Oracle Mobile Supply Chain Applications.
This resource should be highly technical with extensive knowledge of the various server, labeling, printer, RF equipment, etc. Start date will be Mid-March and will continue for 3-6 months, possibly more. Some brief, occasional international travel, with expenses paid, may be required from time to time throughout the course of the project. Should be able to set up and configure both the software and the devices used.
Thanks and regards,
Jabastion
630 928 1800 X 509
Votes: +0
Location: FL
Duration: 3-6 months
Job description:
Our company is handling the global implementation of Oracle Applications for a multi-billion dollar European conglomerate. Their Application Systems are managed and we are in need for an Oracle Technical expert to assist in the Installation and Configuration of Oracle Mobile Supply Chain Applications.
This resource should be highly technical with extensive knowledge of the various server, labeling, printer, RF equipment, etc. Start date will be Mid-March and will continue for 3-6 months, possibly more. Some brief, occasional international travel, with expenses paid, may be required from time to time throughout the course of the project. Should be able to set up and configure both the software and the devices used.
Thanks and regards,
Jabastion
630 928 1800 X 509
report abuse
vote down
vote up
MWA SSH Server
written by Saunak , May 21, 2008
written by Saunak , May 21, 2008
Hi Anil/Senthil,
My client uses SSH instead of Telnet for security reasons.
We are implementing WMS for them and were asked to deply MWA on SSH.
Do u have any idea whether MWA can be deployed on SSH and Oracle provides support for that?
Thanks & Regards,
Saunak
Votes: +0
My client uses SSH instead of Telnet for security reasons.
We are implementing WMS for them and were asked to deply MWA on SSH.
Do u have any idea whether MWA can be deployed on SSH and Oracle provides support for that?
Thanks & Regards,
Saunak
report abuse
vote down
vote up
...
written by Saunak , May 21, 2008
written by Saunak , May 21, 2008
Hi Sentil,
Thanks for ur quick response.
Currenly client is using SSH for remote access to DB and Applications.
They are in strong opposition of using Telnet for any purpose.
Since MWA Telnet comes with Oracle WMS/MSCA. But I am not very sure if Oracle provides anything MWA SSH with WMS/MSCA.
Would appreciate ur response.
Thanks & Regards,
Saunak
Votes: +0
Thanks for ur quick response.
Currenly client is using SSH for remote access to DB and Applications.
They are in strong opposition of using Telnet for any purpose.
Since MWA Telnet comes with Oracle WMS/MSCA. But I am not very sure if Oracle provides anything MWA SSH with WMS/MSCA.
Would appreciate ur response.
Thanks & Regards,
Saunak
report abuse
vote down
vote up
...
written by Saunak , May 22, 2008
written by Saunak , May 22, 2008
Senthil,
The MWA coming with the purchase of WMS/MSCA package from Oracle works with Telnet only and Oracle does provide support for that. To enable the communication SSH secured further configuration is required on the server side with port forwarding feature of SSH. The mobile device should also support SSH client to communicate with the SSH server. Oracle of course does not provide any support for SSH enabled MWA communication.
For further detail on the configuration you can refer the document 302174.1 in metalink.
Thanks & Regards,
Saunak
Votes: +0
The MWA coming with the purchase of WMS/MSCA package from Oracle works with Telnet only and Oracle does provide support for that. To enable the communication SSH secured further configuration is required on the server side with port forwarding feature of SSH. The mobile device should also support SSH client to communicate with the SSH server. Oracle of course does not provide any support for SSH enabled MWA communication.
For further detail on the configuration you can refer the document 302174.1 in metalink.
Thanks & Regards,
Saunak
report abuse
vote down
vote up
Need help about an error.
written by New_to_apps , May 29, 2008
written by New_to_apps , May 29, 2008
We have come across a procedure which we want to execute, but its giving us an error.
inv_ui_item_lovs.get_item_lov( );
Please help.
report abuse
vote down
vote up
Senior Software Developer
written by A.Malar Selvam , October 28, 2008
written by A.Malar Selvam , October 28, 2008
Hi,
I am new to Oracle Mobile Web Applications. I deployed the Helloworld Application successfully and can access the Page. But the problem is the Text Field is coming as READ ONLY (NOT EDITABLE).
Also, I tried to create LOV Page, there also i am facing the following problem:
1) Instead of LOV, i am getting TextBox only.
2) The TextBox also NotEditable.
3) Also the Text Box is coming with the value - >[7m[0m
Please help me out.
Regards.
A.Malar Selvam.
Votes: +0
I am new to Oracle Mobile Web Applications. I deployed the Helloworld Application successfully and can access the Page. But the problem is the Text Field is coming as READ ONLY (NOT EDITABLE).
Also, I tried to create LOV Page, there also i am facing the following problem:
1) Instead of LOV, i am getting TextBox only.
2) The TextBox also NotEditable.
3) Also the Text Box is coming with the value - >[7m[0m
Please help me out.
Regards.
A.Malar Selvam.
report abuse
vote down
vote up
System Analyst
written by Vijay Kundu , November 06, 2008
written by Vijay Kundu , November 06, 2008
Hi,
We are on Oracle Apps 12.0.4 and need to default some fields values in PickLoad and PickDrop WMS pages. Oracle suggests that MWA Personalization framework option to customize these pages doesnt exists in R12 version 12.0.4.
Please suggest what best way to achieve this fuctionality as we have this in 11i.
Regards,
Vijay.
Votes: +0
We are on Oracle Apps 12.0.4 and need to default some fields values in PickLoad and PickDrop WMS pages. Oracle suggests that MWA Personalization framework option to customize these pages doesnt exists in R12 version 12.0.4.
Please suggest what best way to achieve this fuctionality as we have this in 11i.
Regards,
Vijay.
report abuse
vote down
vote up
Custom telnet forms are not opening
written by kiran kumar G , January 20, 2009
written by kiran kumar G , January 20, 2009
Hi,
I am working on wms telnet customizations,
we are facing an issue , we are not able to open any of the custom java forms from the telnet.. Standard forms are working fine ..
for example stage move form which calls xxxStagemove.class is not getting opened and we are able to see the error message in system log
[Tue Jan 20 10:58:27 EST 2009] (Thread-12) Couldn't load given class : oracle.apps.wms.td.server.GEPSStagingMoveFunction
java.lang.ClassNotFoundException: oracle.apps.wms.td.server.GEPSStagingMoveFunction
But the class file and java file both are in place. This worked fine till now, but suddenly we r facing this issue
Please can input any comments .
Thanks,
Kiran
Votes: +0
I am working on wms telnet customizations,
we are facing an issue , we are not able to open any of the custom java forms from the telnet.. Standard forms are working fine ..
for example stage move form which calls xxxStagemove.class is not getting opened and we are able to see the error message in system log
[Tue Jan 20 10:58:27 EST 2009] (Thread-12) Couldn't load given class : oracle.apps.wms.td.server.GEPSStagingMoveFunction
java.lang.ClassNotFoundException: oracle.apps.wms.td.server.GEPSStagingMoveFunction
But the class file and java file both are in place. This worked fine till now, but suddenly we r facing this issue
Please can input any comments .
Thanks,
Kiran
report abuse
vote down
vote up
Custom telnet forms are not opening
written by kiran kumar G , January 21, 2009
written by kiran kumar G , January 21, 2009
Hi ,
Yes all the class files and java files have the 777 permissions, issue got resolved by DBA team.
Root cause for the issue was the environment config file, it was not pointing to the custom top of wms java files at all.
After correcting the file it started working .
Thanks,
Kiran
Votes: +0
Yes all the class files and java files have the 777 permissions, issue got resolved by DBA team.
Root cause for the issue was the environment config file, it was not pointing to the custom top of wms java files at all.
After correcting the file it started working .
Thanks,
Kiran
report abuse
vote down
vote up
...
written by Senthilkumar Shanmugam , January 21, 2009
written by Senthilkumar Shanmugam , January 21, 2009
Hi Kiran,
Nice to hear that your issue got resolved
Cheers,
Senthil
Votes: +0
Nice to hear that your issue got resolved
Cheers,
Senthil
report abuse
vote down
vote up
...
written by Kaukab , January 26, 2009
written by Kaukab , January 26, 2009
Hi Senthil
Please explain little about "UtilFns.log"
What is LogTrace severity
Where is the log file stored in 11i.
Thanks & Regards
Votes: +0
Please explain little about "UtilFns.log"
What is LogTrace severity
Where is the log file stored in 11i.
Thanks & Regards
report abuse
vote down
vote up
IS it necessary to keep new custom class file in JAVA_TOP
written by Kaukab , January 26, 2009
written by Kaukab , January 26, 2009
IS it necessary to keep new custom class file in JAVA_TOP
or we can also place it somewhere. If we place it say INV TOP then what classpath needs to be set and what needs to be given fnd_function form at WEB_HTML call.
Votes: +0
or we can also place it somewhere. If we place it say INV TOP then what classpath needs to be set and what needs to be given fnd_function form at WEB_HTML call.
report abuse
vote down
vote up
which version of java we can use
written by Kaukab , January 28, 2009
written by Kaukab , January 28, 2009
Which version of java we need to have on our desktop. while doing customization
Votes: -1
report abuse
vote down
vote up
MWA in custom path
written by MithunRoy , March 26, 2009
written by MithunRoy , March 26, 2009
Hi Anil,
I have modified a std MWA class (for cycle counting) and put it under oracle.apps.xxinv.count.server, this directory structure is not under JAVA_TOP/classes folder rather we have custom top called XXAMW_TOP. So the class files are in $XXAMW_TOP/java/classes/oracle/apps/xxinv/count/server.
I have added $XXAMW_TOP/java/classes to adovars.env and bounced MWA service. still getting class not found exception.
N.B. there is 775 permission on class files from applmgr.
Could you please help me on what am I missing.
Mithun
Votes: +0
I have modified a std MWA class (for cycle counting) and put it under oracle.apps.xxinv.count.server, this directory structure is not under JAVA_TOP/classes folder rather we have custom top called XXAMW_TOP. So the class files are in $XXAMW_TOP/java/classes/oracle/apps/xxinv/count/server.
I have added $XXAMW_TOP/java/classes to adovars.env and bounced MWA service. still getting class not found exception.
N.B. there is 775 permission on class files from applmgr.
Could you please help me on what am I missing.
Mithun
report abuse
vote down
vote up
MWA in custom path
written by MithunRoy , March 26, 2009
written by MithunRoy , March 26, 2009
Hi, we have added the path in CONTEXT_FILE and then ran auto config which has added the custom path in CLASSPATH variable.
So now I log into unix as applmgr it shows the path in CLASSPATH variable.
For your information, if I ran
javah -v $XXAMW_TOP/java/classes/oracle/apps/xxinv/count/server
It shows that it can load the classes as well.
Regards
Mithun
Votes: +0
So now I log into unix as applmgr it shows the path in CLASSPATH variable.
For your information, if I ran
javah -v $XXAMW_TOP/java/classes/oracle/apps/xxinv/count/server
It shows that it can load the classes as well.
Regards
Mithun
report abuse
vote down
vote up
MWA in custom path
written by MithunRoy , March 27, 2009
written by MithunRoy , March 27, 2009
Hi,
We did a nice workaround, just wanted to share in this forum, if someone face similar issue in future.
our directory structure are like this.
JAVA_TOP = /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes
XXAMW_TOP = /s01/apps/applmgr/esbdv001/apps/apps_st/appl/xxamw/12.0.0 (custom top)
we wanted to keep our custom java class files to $XXAMW_TOP/java/classes/oracle/apps/xxinv
So what we did is created symlink like below
# /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes/oracle/apps]
# ls -l xxamw
lrwxrwxrwx 1 applmgr ldba 82 Mar 07 20:54 xxamw -> /s01/apps/applmgr/esbdv001/apps/apps_st/appl/xxamw/12.0.0/java/classes/oracle/apps
# /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes/oracle/apps]
and now we are giving the path in AOL function as oracle.apps.xxamw.xxinv.count.server.XxCycleCountFunction, and it work fine.
Mithun
Votes: +0
We did a nice workaround, just wanted to share in this forum, if someone face similar issue in future.
our directory structure are like this.
JAVA_TOP = /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes
XXAMW_TOP = /s01/apps/applmgr/esbdv001/apps/apps_st/appl/xxamw/12.0.0 (custom top)
we wanted to keep our custom java class files to $XXAMW_TOP/java/classes/oracle/apps/xxinv
So what we did is created symlink like below
# /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes/oracle/apps]
# ls -l xxamw
lrwxrwxrwx 1 applmgr ldba 82 Mar 07 20:54 xxamw -> /s01/apps/applmgr/esbdv001/apps/apps_st/appl/xxamw/12.0.0/java/classes/oracle/apps
# /s01/apps/applmgr/esbdv001/apps/apps_st/comn/java/classes/oracle/apps]
and now we are giving the path in AOL function as oracle.apps.xxamw.xxinv.count.server.XxCycleCountFunction, and it work fine.
Mithun
report abuse
vote down
vote up
RF Device Installation problem
written by Kaukabss , May 22, 2009
written by Kaukabss , May 22, 2009
Hi Senthil
My previous issues of page customization got resolved and am now little comfortable in that. Thanks a ton again for that.
Now i have also got some morework for running the GUI on a RF device which has Windows CE as OS. I am facing problem in finding a JVM for my RF device can u provide me some details in this Area. Is any JVM for mobile device availaible for free.
Thanks
Kaukab
Votes: +0
My previous issues of page customization got resolved and am now little comfortable in that. Thanks a ton again for that.
Now i have also got some morework for running the GUI on a RF device which has Windows CE as OS. I am facing problem in finding a JVM for my RF device can u provide me some details in this Area. Is any JVM for mobile device availaible for free.
Thanks
Kaukab
report abuse
vote down
vote up
?
written by Kaukabss , June 03, 2009
written by Kaukabss , June 03, 2009
Hi Senthil
I have installed the Creme but I am not able to launch GUI.
Can somebody help me on this
Votes: +0
I have installed the Creme but I am not able to launch GUI.
Can somebody help me on this
report abuse
vote down
vote up
error messge
written by Kaukabss , June 04, 2009
written by Kaukabss , June 04, 2009
POWER_GetDeviceState is not supported
Votes: +0
report abuse
vote down
vote up
Registery edit in Windows CE
written by Bugs , June 04, 2009
written by Bugs , June 04, 2009
How to do the registry Edit in Widows CE to set the personla profile optin
Votes: +0
report abuse
vote down
vote up
Dev
written by Kiran Akkiraju , June 22, 2009
written by Kiran Akkiraju , June 22, 2009
I am very new to Mobile application and trying out your example. I have tried your example and it works fine. And trying a simple Employee Insert Screen and all the fields coming as non editable fields with the value :[7m[0m. I m not sure what I am doing wrong. Could you please help me.
Votes: +0
report abuse
vote down
vote up
Consultant
written by satish1 , September 10, 2009
written by satish1 , September 10, 2009
Hi Senthil
we are facing one issue with Handheld device where in not able to launch the GUI.throwing exception like exit code 1 and application is terminating.
OS of the Hand Held Device is Windows CE and installed JVM tinny CrEme
When i check the log file in the server ,showing the Information like below
[Thu Sep 10 16:56:19 EDT 2009] (Thread-44) PH: User null got disconnected...
[Thu Sep 10 16:56:19 EDT 2009] (Thread-44) PH: caught IOException
java.io.IOException: -1 is read from input stream
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1387)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.enterHighlight(ProtocolHandler.java:2013)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.run(ProtocolHandler.java:733)
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: accept failed, closing socket
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: socket closed, reopening
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: socket reopened
Tried many ways but no sucess and comming to you if you have any solution for this
Pls help
Thanks
Satish.p
Votes: +0
we are facing one issue with Handheld device where in not able to launch the GUI.throwing exception like exit code 1 and application is terminating.
OS of the Hand Held Device is Windows CE and installed JVM tinny CrEme
When i check the log file in the server ,showing the Information like below
[Thu Sep 10 16:56:19 EDT 2009] (Thread-44) PH: User null got disconnected...
[Thu Sep 10 16:56:19 EDT 2009] (Thread-44) PH: caught IOException
java.io.IOException: -1 is read from input stream
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1387)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.readChar(ProtocolHandler.java:1369)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.enterHighlight(ProtocolHandler.java:2013)
at oracle.apps.mwa.presentation.telnet.ProtocolHandler.run(ProtocolHandler.java:733)
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: accept failed, closing socket
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: socket closed, reopening
[Thu Sep 10 16:56:21 EDT 2009] (Thread-10) ServerManagerListener: socket reopened
Tried many ways but no sucess and comming to you if you have any solution for this
Pls help
Thanks
Satish.p
report abuse
vote down
vote up
MWA 11.5.10.2 + crEme 4.2 + CK31 guns!
written by Toral , September 22, 2009
written by Toral , September 22, 2009
Hi Senthil,
I find your blog very informative. We have been using character based MWA on CK31 guns for years, now I am trying to install GUI MWA on these guns. I have installed crEme on CK31, and have installed GUI MWA on this guns. When we had character based MWA, we could scan the barcodes on CK31. Now that I have installed GUI, we can scan the barcodes, but when we use "TAB" or "ENTER" key, the scanned value disappears from the field.Not sure why this is happening. Is this a setup issue? Is there any guidance you can provide?
Thanks,
Toral
Votes: +0
I find your blog very informative. We have been using character based MWA on CK31 guns for years, now I am trying to install GUI MWA on these guns. I have installed crEme on CK31, and have installed GUI MWA on this guns. When we had character based MWA, we could scan the barcodes on CK31. Now that I have installed GUI, we can scan the barcodes, but when we use "TAB" or "ENTER" key, the scanned value disappears from the field.Not sure why this is happening. Is this a setup issue? Is there any guidance you can provide?
Thanks,
Toral
report abuse
vote down
vote up
MWA error logging
written by Tyagi,Abhishek , June 22, 2010
written by Tyagi,Abhishek , June 22, 2010
Hi Senthil,
If we set the value of variable mwa.LogLevel=debug , then what all debug messages we would be able to see?.
As You have mentioned that for different type of log levels, we need to provide different type of messages in the code like :
UtilFns.trace("#########Trace Level Logs#########");
UtilFns.log("#########Log level logs#########");
UtilFns.error("#####Error Level logs#########");
As we dont have any debug method in UtilFns class, so how this DEBUG log level behaves?
Thanks in Advance,
Thanks and Regards,
Abhishek.
Votes: +0
If we set the value of variable mwa.LogLevel=debug , then what all debug messages we would be able to see?.
As You have mentioned that for different type of log levels, we need to provide different type of messages in the code like :
UtilFns.trace("#########Trace Level Logs#########");
UtilFns.log("#########Log level logs#########");
UtilFns.error("#####Error Level logs#########");
As we dont have any debug method in UtilFns class, so how this DEBUG log level behaves?
Thanks in Advance,
Thanks and Regards,
Abhishek.
report abuse
vote down
vote up
...
written by Senthilkumar Shanmugam1 , June 22, 2010
written by Senthilkumar Shanmugam1 , June 22, 2010
Hi Abhishek,
Am not sure of the behavior. I have to test it myself and get back to you.
Thanks and Regards,
Senthil
Votes: +0
Am not sure of the behavior. I have to test it myself and get back to you.
Thanks and Regards,
Senthil
report abuse
vote down
vote up
Tech Consultant
written by RajeevPillai , June 24, 2010
written by RajeevPillai , June 24, 2010
Hi Senthil..
While starting the MWA server i am getting the following error in 12.1.1
Unable to determine MWA_TOP
Please make sure that MWA_TOP is defined...
How to define the MWA_TOP please guide...
Regards
Rajeev
Votes: +0
While starting the MWA server i am getting the following error in 12.1.1
Unable to determine MWA_TOP
Please make sure that MWA_TOP is defined...
How to define the MWA_TOP please guide...
Regards
Rajeev
report abuse
vote down
vote up
...
written by RajeevPillai , June 24, 2010
written by RajeevPillai , June 24, 2010
Thanks for your immediate response...
I am very new to this... Can u please give me an example to set $MWA_TOP
Thanks.... Rajeev...
Votes: +0
I am very new to this... Can u please give me an example to set $MWA_TOP
Thanks.... Rajeev...
report abuse
vote down
vote up
...
written by RajeevPillai , June 24, 2010
written by RajeevPillai , June 24, 2010
Hi Senthil..
I have done the EBS 12.1.1 successfully and its running and i know there has to be some env to be set in /home/oracle/.bash_profile (Correct me if i am wrong). But i don't know how to do this. And i couldn't find any notes on post installation.
Could you please guide me on this...
I am trying to start MWA server using mwactl.sh start 10206 (10208,10210) and the dispacther (10803) using the startup script (782162.1 note in metalink)
Regards
Rajeev
Votes: +0
I have done the EBS 12.1.1 successfully and its running and i know there has to be some env to be set in /home/oracle/.bash_profile (Correct me if i am wrong). But i don't know how to do this. And i couldn't find any notes on post installation.
Could you please guide me on this...
I am trying to start MWA server using mwactl.sh start 10206 (10208,10210) and the dispacther (10803) using the startup script (782162.1 note in metalink)
Regards
Rajeev
report abuse
vote down
vote up
...
written by RajeevPillai , June 25, 2010
written by RajeevPillai , June 25, 2010
Hi Senthil...
Thanks for the guidance Senthil.... I have set up the env variables in /home//.bash_profile... Just including it here for the benefit of others... Once its done i have sourced the .bash_profile. Then i have sourced the "..env" file from APPL_TOP
And i have started mwactl.sh for all telnet ports but while starting the start_dispatcher its giving me the following error. Requested your advise
MWA Telnet Server Release: 1.0.8.4 [December 12th 2002]
/u02/oracle/orawms/apps/apps_st/appl/mwa/12.0.0/bin/MWADIS: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
ENV Config in .bash_profile
==================
AD_TOP=/u02/oracle//apps/apps_st/appl/ad/12.0.0; export AD_TOP
APPL_TOP=/u02/oracle//apps/apps_st/appl; export APPL_TOP
COMMON_TOP=/u02/oracle//apps/apps_st/comn; export COMMON_TOP
ORACLE_HOME=/u02/oracle//apps/tech_st/10.1.2; export ORACLE_HOME
iAS_ORACLE_HOME=/u02/oracle//apps/tech_st/10.1.3; export iAS_ORACLE_HOME
MWA_TOP=/u02/oracle//apps/apps_st/appl/mwa/12.0.0; export MWA_TOP
INST_TOP=/u02/oracle//inst/apps/orawms_ebizsaasdb; export INST_TOP
OA_HTML=/u02/oracle//apps/apps_st/comn/webapps/oacore/html; export OA_HTML
JAVA_TOP=/u02/oracle//apps/apps_st/comn/java/classes; export JAVA_TOP
JAVA_BASE=/u02/oracle//apps/apps_st/comn/java; export JAVA_BASE
PATH=$PATH:$HOME/bin:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u02/oracle/orawms/apps/tech_st/10.1.2/lib
export PATH
==================
Votes: +0
Thanks for the guidance Senthil.... I have set up the env variables in /home//.bash_profile... Just including it here for the benefit of others... Once its done i have sourced the .bash_profile. Then i have sourced the "..env" file from APPL_TOP
And i have started mwactl.sh for all telnet ports but while starting the start_dispatcher its giving me the following error. Requested your advise
MWA Telnet Server Release: 1.0.8.4 [December 12th 2002]
/u02/oracle/orawms/apps/apps_st/appl/mwa/12.0.0/bin/MWADIS: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
ENV Config in .bash_profile
==================
AD_TOP=/u02/oracle//apps/apps_st/appl/ad/12.0.0; export AD_TOP
APPL_TOP=/u02/oracle//apps/apps_st/appl; export APPL_TOP
COMMON_TOP=/u02/oracle//apps/apps_st/comn; export COMMON_TOP
ORACLE_HOME=/u02/oracle//apps/tech_st/10.1.2; export ORACLE_HOME
iAS_ORACLE_HOME=/u02/oracle//apps/tech_st/10.1.3; export iAS_ORACLE_HOME
MWA_TOP=/u02/oracle//apps/apps_st/appl/mwa/12.0.0; export MWA_TOP
INST_TOP=/u02/oracle//inst/apps/orawms_ebizsaasdb; export INST_TOP
OA_HTML=/u02/oracle//apps/apps_st/comn/webapps/oacore/html; export OA_HTML
JAVA_TOP=/u02/oracle//apps/apps_st/comn/java/classes; export JAVA_TOP
JAVA_BASE=/u02/oracle//apps/apps_st/comn/java; export JAVA_BASE
PATH=$PATH:$HOME/bin:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386/server:/u02/oracle/orawms/apps/tech_st/10.1.2/jdk/jre/lib/i386/native_threads:/u02/oracle/orawms/apps/tech_st/10.1.2/lib
export PATH
==================
report abuse
vote down
vote up
Question on common changes across multiple MWA screens
written by Girish M , July 29, 2010
written by Girish M , July 29, 2010
Hello Senthil -
Firstly, thank you for this immensely helpful writeup on MWA. The follow-up questions and their answers have also been as useful.
I have a requirement where I need to make the same change across several MWA screens. Basically, I need to make one field non-updateable. I was wondering if there is any central place (like say CUSTOM.pll in D2K Forms) where I can make this change instead of changing several java files.
Thanks in advance.
Regards
-Girish
Votes: +0
Firstly, thank you for this immensely helpful writeup on MWA. The follow-up questions and their answers have also been as useful.
I have a requirement where I need to make the same change across several MWA screens. Basically, I need to make one field non-updateable. I was wondering if there is any central place (like say CUSTOM.pll in D2K Forms) where I can make this change instead of changing several java files.
Thanks in advance.
Regards
-Girish
report abuse
vote down
vote up
Connection closed
written by GirishNarne , August 18, 2010
written by GirishNarne , August 18, 2010
Hi Senthil,
Your article is very helpful. I tried to perform the same steps and when I access the Mobile test menu it get a message saying connection closed and the program exits. Is there anything that I am missing here.
Regards,
Girish Narne
Votes: +0
Your article is very helpful. I tried to perform the same steps and when I access the Mobile test menu it get a message saying connection closed and the program exits. Is there anything that I am missing here.
Regards,
Girish Narne
report abuse
vote down
vote up
Connection closed
written by GirishNarne , August 23, 2010
written by GirishNarne , August 23, 2010
Hi Senthil,
I figured out the error and I am able to run the test page successfully. I have developed a custom page with couple of fields and thats working fine. My requirement is that when ever user opens the page if the Organization ID is null then it should prompt for org selection and after selection should continue to the page. Could you please provide some guidance on how to achieve this. Is there any standard page which we can call.
One more issue I have is based on your article I tried to locate the System.info log file to see the trace messages but could not find the file on the server. I am working R12 12.0.4 instance.
Thanks for your help.
Regards,
Girish.
Votes: +0
I figured out the error and I am able to run the test page successfully. I have developed a custom page with couple of fields and thats working fine. My requirement is that when ever user opens the page if the Organization ID is null then it should prompt for org selection and after selection should continue to the page. Could you please provide some guidance on how to achieve this. Is there any standard page which we can call.
One more issue I have is based on your article I tried to locate the System.info log file to see the trace messages but could not find the file on the server. I am working R12 12.0.4 instance.
Thanks for your help.
Regards,
Girish.
report abuse
vote down
vote up
Connection closed
written by GirishNarne , August 24, 2010
written by GirishNarne , August 24, 2010
Senthil,
I am looking for the log files in $INST_TOP/logs and this is directory given in the mwa.cfg file. I have the log level to trace but no files are seen in the directory both on application server and database server. Regarding the change organization, I have built a custom page and whenever the user directly navigates to the custom page system is not prompting to choose inventory organization. I would like to prompt the user to choose the organization if not already done. Is there a way to do this.
Thanks and Regards,
Girish.
Votes: +0
I am looking for the log files in $INST_TOP/logs and this is directory given in the mwa.cfg file. I have the log level to trace but no files are seen in the directory both on application server and database server. Regarding the change organization, I have built a custom page and whenever the user directly navigates to the custom page system is not prompting to choose inventory organization. I would like to prompt the user to choose the organization if not already done. Is there a way to do this.
Thanks and Regards,
Girish.
report abuse
vote down
vote up
...
written by GirishNarne , August 26, 2010
written by GirishNarne , August 26, 2010
Hi Senthil,
Could you please give sample code to prompt for Org if you have any.
Thanks,
Girish.
Votes: +0
Could you please give sample code to prompt for Org if you have any.
Thanks,
Girish.
report abuse
vote down
vote up
...
written by GirishNarne , September 06, 2010
written by GirishNarne , September 06, 2010
Hi Senthil,
Thanks for sharing the sample code.
Regards,
Girish
Votes: +0
Thanks for sharing the sample code.
Regards,
Girish
report abuse
vote down
vote up
LOV problem
written by GirishNarne , September 07, 2010
written by GirishNarne , September 07, 2010
Hi Senthil,
I have built a custom wms page with 4 fields in it. I have also added LOV's to the field using the plsql package ref cursor method. Everything is working fine except that the field navigations are not working properly. When ever a valid value is entered in the field and I tab from that field the LOV still pops up. Is there any handling that needs to be done in the field exited method. Thanks for your continuous support.
Regards,
Girish.
Votes: +0
I have built a custom wms page with 4 fields in it. I have also added LOV's to the field using the plsql package ref cursor method. Everything is working fine except that the field navigations are not working properly. When ever a valid value is entered in the field and I tab from that field the LOV still pops up. Is there any handling that needs to be done in the field exited method. Thanks for your continuous support.
Regards,
Girish.
report abuse
vote down
vote up
...
written by GirishNarne , September 08, 2010
written by GirishNarne , September 08, 2010
Hi Senthil,
Currently the setValidateFromLOV is set to true and the lov pops up even if valid value is entered in the field. If I set the value to false then system will allow user to enter invalid values also which I dont want to happen. Is there any other way to handle this.
Thanks,
Girish.
Votes: +0
Currently the setValidateFromLOV is set to true and the lov pops up even if valid value is entered in the field. If I set the value to false then system will allow user to enter invalid values also which I dont want to happen. Is there any other way to handle this.
Thanks,
Girish.
report abuse
vote down
vote up
Disabling LOV Popup when valid value is entered
written by GirishNarne , September 24, 2010
written by GirishNarne , September 24, 2010
Hi Senthil,
I would like to share some information that I have gained while developing custom wms pages.
If we want to use setValidateFromLOV(true) and still don't want the system to popup the LOV whenever a valid value is entered into the field, it can be done as below. I have taken an example of LPN field.
Step 1: Have the package procedure like below
CREATE OR REPLACE package APPS.XX_LOVS AS
PROCEDURE GET_LPN_LOV (x_lpn_no OUT NOCOPY t_ref_csr,p_lpn_no VARCHAR2);
END XX_LOVS;
CREATE OR REPLACE package body APPS.XX_LOVS AS
PROCEDURE GET_LPN_LOV (x_lpn_no OUT NOCOPY t_ref_csr,p_lpn_no VARCHAR2)
IS
BEGIN
OPEN x_lpn_no FOR
select license_plate_number
from wms_license_plate_numbers
WHERE license_plate_number like p_lpn_no;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('ERROR IN LPN LOV '|| SQLERRM);
END GET_LPN_LOV;
END XX_LOVS;
Step 2: Create the LOV field and set the properties as below.
mLPNNum = new LOVFieldBean();
mLPNNum.setName("XX.LPNNUMBER");
mLPNNum.setlovStatement("XX_LOVS.GET_LPN_LOV");
mLPNNum.setInputParameterTypes(new String[] { "C", "S" });
mLPNNum.setSubfieldDisplays(new boolean[] { true });
mLPNNum.setSubfieldPrompts(new String[] { "LPN Lov" });
mLPNNum.setInputParameters(new String[] {" ", "xxcus.oracle.apps.mwa.server.xxCustomPage.XX.LPNNUMBER" });
mLPNNum.setValidateFromLOV(true);
mLPNNum.setRequired(true);
Hope this helps.
Regards,
Girish.
report abuse
vote down
vote up
Adding Cancel button to page
written by GirishNarne , September 29, 2010
written by GirishNarne , September 29, 2010
Hi Senthil,
I want to add Cancel button to my custom wms page. I have used the below code, but the cursor does not come out of the required fields when I want to click the Cancel Button. I have also noticed that on the Standard pages whenever the cursor is moved to the Cancel Button the cursor icon changes which is not happening in my page. Please let me know if you have any solution for this.
mCancelBtn = new TdButton("XX.CANCEL", "|END_OF_TRANSACTION|");
mCancelBtn.setPrompt("Cancel");
mCancelBtn.setHidden(false);
mCancelBtn.setEnableAcceleratorKey(true);
addFieldBean(mCancelBtn);
Regards,
Girish.
Votes: +0
I want to add Cancel button to my custom wms page. I have used the below code, but the cursor does not come out of the required fields when I want to click the Cancel Button. I have also noticed that on the Standard pages whenever the cursor is moved to the Cancel Button the cursor icon changes which is not happening in my page. Please let me know if you have any solution for this.
mCancelBtn = new TdButton("XX.CANCEL", "|END_OF_TRANSACTION|");
mCancelBtn.setPrompt("Cancel");
mCancelBtn.setHidden(false);
mCancelBtn.setEnableAcceleratorKey(true);
addFieldBean(mCancelBtn);
Regards,
Girish.
report abuse
vote down
vote up
...
written by GirishNarne , October 01, 2010
written by GirishNarne , October 01, 2010
Hi Senthil,
Thanks for the code. I was able to get my button to work with the TdButton. I am working customizing a standard page to hide a field. When I decode and see some of the standard pages WMAUtil.log is being used to log messsages which do not appear on the log file. Do you have any idea to enable this logging and where can I see the messages written using WMAUtil.log. Do you have any mail id where I can reach you.
Thanks,
Girish.
Votes: +0
Thanks for the code. I was able to get my button to work with the TdButton. I am working customizing a standard page to hide a field. When I decode and see some of the standard pages WMAUtil.log is being used to log messsages which do not appear on the log file. Do you have any idea to enable this logging and where can I see the messages written using WMAUtil.log. Do you have any mail id where I can reach you.
Thanks,
Girish.
report abuse
vote down
vote up
jdevloper version for MSCA/MWA framework
written by shailendra singh , October 26, 2010
written by shailendra singh , October 26, 2010
hello Senthil,
can you please tell me which version of jdevloper suppor MSCA/MWA framework
thanks &ragards
shailendra
Votes: +0
can you please tell me which version of jdevloper suppor MSCA/MWA framework
thanks &ragards
shailendra
report abuse
vote down
vote up
...
written by Senthilkumar Shanmugam1 , October 26, 2010
written by Senthilkumar Shanmugam1 , October 26, 2010
Hi Shailendra,
It is not mandatory that you have to use Jdeveloper for MSCA. You can use any IDE as long as your Oracle Instance techstack compiiles your java source.
Hope this helps.
Thanks and Regards,
Senthil
Votes: +1
It is not mandatory that you have to use Jdeveloper for MSCA. You can use any IDE as long as your Oracle Instance techstack compiiles your java source.
Hope this helps.
Thanks and Regards,
Senthil
report abuse
vote down
vote up
Great article
written by Pathfinder , August 30, 2011
written by Pathfinder , August 30, 2011
Another nice article on mwa personalization : http://applikast.blogspot.com/...pages.html
Votes: +0
report abuse
vote down
vote up
Fatal PL/SQL error occurred
written by Latha , September 03, 2011
written by Latha , September 03, 2011
Hi to Everybody
i have started my career in Oracle Apps
i am new to learn developing Reports
i hope that u peaple can help me
REP-1320
rogram unit 'cf_5formula'references column with invalid ID:33
REP-1320rogram unit 'cf_5formula'references column with invalid ID:30
REP-1320rogram unit 'cf_5formula'references column with invalid ID:31
REP-1320rogram unit 'cf_5formula'references column with invalid ID:32
i am getting above err while i am running my report
in cf_5formula column i have pass the values to placeholder columns
Pls advise me what to do?
I am waiting for ur reply
Thanks in Advance
latha
Votes: +0
i have started my career in Oracle Apps
i am new to learn developing Reports
i hope that u peaple can help me
REP-1320
rogram unit 'cf_5formula'references column with invalid ID:33 REP-1320
rogram unit 'cf_5formula'references column with invalid ID:30 REP-1320
rogram unit 'cf_5formula'references column with invalid ID:31 REP-1320
rogram unit 'cf_5formula'references column with invalid ID:32 i am getting above err while i am running my report
in cf_5formula column i have pass the values to placeholder columns
Pls advise me what to do?
I am waiting for ur reply
Thanks in Advance
latha
report abuse
vote down
vote up
...
written by Phu Tri Nguyen , September 21, 2011
written by Phu Tri Nguyen , September 21, 2011
Hi,
How do I force the Org Code page before my custom page start?
Thank
Votes: +0
How do I force the Org Code page before my custom page start?
Thank
report abuse
vote down
vote up
...
written by Phu Tri Nguyen , September 21, 2011
written by Phu Tri Nguyen , September 21, 2011
Hi,
This code does the job. Thank you
PhuTri
// get inventory org
Session oSession = mwaevent.getSession();
UtilFns.mLog = oSession.getLogger();
setMenuConfirmMessage(UtilFns.getMessage(oSession, "INV", "INV_MWA_MENU_CONF"));
if (oSession.getObject("ORGID") == null) {
oSession.putObject("MWA_FIRSTPAGENAME", m_firstPageName);
m_firstPageName = "oracle.apps.inv.utilities.server.InvOrganizationPageBean";
}
Votes: +0
This code does the job. Thank you
PhuTri
// get inventory org
Session oSession = mwaevent.getSession();
UtilFns.mLog = oSession.getLogger();
setMenuConfirmMessage(UtilFns.getMessage(oSession, "INV", "INV_MWA_MENU_CONF"));
if (oSession.getObject("ORGID") == null) {
oSession.putObject("MWA_FIRSTPAGENAME", m_firstPageName);
m_firstPageName = "oracle.apps.inv.utilities.server.InvOrganizationPageBean";
}
report abuse
vote down
vote up
For Error logging UtilFns.isTraceOn results to false
written by Omkar Lathkar , September 23, 2011
written by Omkar Lathkar , September 23, 2011
Hi Senthil,
We want to take trace of a seeded MWA form 'Mobile Pick Load - Mobile WMS Manual Picking'. The seeded java has following code :
if(UtilFns.isTraceOn)
UtilFns.trace("TD: TaskSignonPage - Could not create savepoint");
We changed the degug level in mwa.cfg file to 'trace'. but the condition if(UtilFns.isTraceOn) results in false and hence not able to get the trace file.
Please suggest how can i make this condition to be true.
Please help me on this.
Thananks :
Omkar
Votes: +0
We want to take trace of a seeded MWA form 'Mobile Pick Load - Mobile WMS Manual Picking'. The seeded java has following code :
if(UtilFns.isTraceOn)
UtilFns.trace("TD: TaskSignonPage - Could not create savepoint");
We changed the degug level in mwa.cfg file to 'trace'. but the condition if(UtilFns.isTraceOn) results in false and hence not able to get the trace file.
Please suggest how can i make this condition to be true.
Please help me on this.
Thananks :
Omkar
report abuse
vote down
vote up
For Error logging UtilFns.isTraceOn results to false
written by Omkar Lathkar , September 23, 2011
written by Omkar Lathkar , September 23, 2011
Hi Senthil,
We want to take trace of a seeded MWA form 'Mobile Pick Load - Mobile WMS Manual Picking'. The seeded java has following code :
if(UtilFns.isTraceOn)
UtilFns.trace("TD: TaskSignonPage - Could not create savepoint");
We changed the degug level in mwa.cfg file to 'trace'. but the condition if(UtilFns.isTraceOn) results in false and hence not able to get the trace file.
Please suggest how can i make this condition to be true.
Please help me on this.
Thananks :
Omkar
Votes: +0
We want to take trace of a seeded MWA form 'Mobile Pick Load - Mobile WMS Manual Picking'. The seeded java has following code :
if(UtilFns.isTraceOn)
UtilFns.trace("TD: TaskSignonPage - Could not create savepoint");
We changed the degug level in mwa.cfg file to 'trace'. but the condition if(UtilFns.isTraceOn) results in false and hence not able to get the trace file.
Please suggest how can i make this condition to be true.
Please help me on this.
Thananks :
Omkar
report abuse
vote down
vote up
...
written by Senthilkumar Shanmugam , September 23, 2011
written by Senthilkumar Shanmugam , September 23, 2011
Hi Omkar,
I am just confused!! may be its because it is Friday ... If you make the set the debug level = trace, how come if(UtilFns.isTraceOn) will be false?
Did you bounce the server after changing the trace level?
Kindly Clarify.
Thanks and Regards,
Senthil
Votes: +0
I am just confused!! may be its because it is Friday
... If you make the set the debug level = trace, how come if(UtilFns.isTraceOn) will be false? Did you bounce the server after changing the trace level?
Kindly Clarify.
Thanks and Regards,
Senthil
report abuse
vote down
vote up
For Error logging UtilFns.isTraceOn results to false
written by Omkar Lathkar , September 23, 2011
written by Omkar Lathkar , September 23, 2011
Hi Senthil,
Thanks for your quick reply.
I just verified that the DBAs have not updated the mwa.cfg file yet.
But, according to you, if(UtilFns.isTraceOn) will be true when we set the debug level to 'trace' rgt?
Also please confirm that, updating the cfg file is only option we have for changing the debug level.
Our DBAs are not comfortable changing the mwa.cfg file.
Do you foresee any potential dangers of updating this trace in production as well?
Thanks
Omkar
Votes: +0
Thanks for your quick reply.
I just verified that the DBAs have not updated the mwa.cfg file yet.
But, according to you, if(UtilFns.isTraceOn) will be true when we set the debug level to 'trace' rgt?
Also please confirm that, updating the cfg file is only option we have for changing the debug level.
Our DBAs are not comfortable changing the mwa.cfg file.
Do you foresee any potential dangers of updating this trace in production as well?
Thanks
Omkar
report abuse
vote down
vote up
For Error logging UtilFns.isTraceOn results to false
written by Omkar Lathkar , September 23, 2011
written by Omkar Lathkar , September 23, 2011
Sure Senthil..
That helps a lot..
Thanks.
Omkar Lathkar
Votes: +0
That helps a lot..
Thanks.
Omkar Lathkar
report abuse
vote down
vote up
How to Setup MWA in Windows Mobile 6.5
written by Piraba , October 20, 2011
written by Piraba , October 20, 2011
Dear Sir/Mada;
I have done the MWA setup in the PC.Its workig fine.Same thing I want to setup in the Windows Mobile 6.5 version.How we can do this.Please help me this.I am very eager to do this.I am Mobile Developer.
I have done in computer(PC)using this
http://apps2fusion.com/at/43-ss/225-mwa-setup-testing-error-logging-and-debugging
I am looking forward your reply.
Please Help me
Regrads;
Piraba
Votes: +1
I have done the MWA setup in the PC.Its workig fine.Same thing I want to setup in the Windows Mobile 6.5 version.How we can do this.Please help me this.I am very eager to do this.I am Mobile Developer.
I have done in computer(PC)using this
http://apps2fusion.com/at/43-ss/225-mwa-setup-testing-error-logging-and-debugging
I am looking forward your reply.
Please Help me
Regrads;
Piraba
report abuse
vote down
vote up
Windows Mobile Setup path
written by piraba , October 20, 2011
written by piraba , October 20, 2011
I have done script like this for Windows Mobile 6.5
set MWA_GUI_TOP = JavaFX
set JAVA_TOP = JavaFXJavaFX.exe
&#xJA;VA_TOP%injava -classpath &#xJA;VA_TOP%libclasses.zip;&#xMW;A_GUI_TOP%libj4205328.zip oracle.apps.mwa.awt.client.StartGUI
Which format will support. I tried with .cmd/.bat/.nt , but not working in the window mobile:
Its say "There is no application to run associated with MYWMA. Run first...."
Please tell me what is the format we need to store. & I installed java called JAVAFX fro windows mobile 6.5.Please guide me this...
report abuse
vote down
vote up
Run .CMD on Windows Mobile 6.5
written by Piraba , October 20, 2011
written by Piraba , October 20, 2011
I have installed creme JVM on my windows Mobile. I want to setup the MYWMA.cmd file
That is:
WindowsCrEmeinCrEme.exe -Of -tiny -classpath WindowsCrEmelibAWTclasses.zip;XONTMWAlibj4205328.zip oracle.apps.mwa.awt.client.StartGUI
I saved MYMWA.cmd file after create this file & when I run on command file. i got error.
Please tell me ;;;
Help please
Votes: +1
That is:
WindowsCrEmeinCrEme.exe -Of -tiny -classpath WindowsCrEmelibAWTclasses.zip;XONTMWAlibj4205328.zip oracle.apps.mwa.awt.client.StartGUI
I saved MYMWA.cmd file after create this file & when I run on command file. i got error.
Please tell me ;;;
Help please
report abuse
vote down
vote up
MWA Setup on the Windows Mobile
written by piraba , October 24, 2011
written by piraba , October 24, 2011
Hi;
Its working fine with Windows Mobile :
Command is :
WindowsCrEmeinCrEme.exe -Of -classpath WindowsCrEmelibAWTclasses.zip;XONTMWAlibj4205328.zip oracle.apps.mwa.awt.client.StartGUI
Wrong with -tiny.
Thanks You very much.
Regrads;
Piraba
Votes: +1
Its working fine with Windows Mobile :
Command is :
WindowsCrEmeinCrEme.exe -Of -classpath WindowsCrEmelibAWTclasses.zip;XONTMWAlibj4205328.zip oracle.apps.mwa.awt.client.StartGUI
Wrong with -tiny.
Thanks You very much.
Regrads;
Piraba
report abuse
vote down
vote up
Sr. Developer
written by Vince Solis , December 27, 2011
written by Vince Solis , December 27, 2011
Has anyone had issues with shortcuts with CrE-ME 4.12 and WM 5 or WM 6.5? Anyone using MC9090/MC9190 devices?
How about JavaFX with a working .lnk file for the command file?
Thanks,
-Vince
Votes: +0
How about JavaFX with a working .lnk file for the command file?
Thanks,
-Vince
report abuse
vote down
vote up
New to MWA Setup
written by Developer , January 17, 2012
written by Developer , January 17, 2012
Hi Senthil,
I am new to MSCA and had went through your article and just started Desktop Mobile GUI. Host Name and Port will be my app server details rt?. I was also wandering about MWA server. Can you please provide more info on MWA Server. Is there any additional Hardware /setups/configurations changes required (apart from mwactl.sh) on the apps server ?
Thanks in Advance
Votes: +0
I am new to MSCA and had went through your article and just started Desktop Mobile GUI. Host Name and Port will be my app server details rt?. I was also wandering about MWA server. Can you please provide more info on MWA Server. Is there any additional Hardware /setups/configurations changes required (apart from mwactl.sh) on the apps server ?
Thanks in Advance
report abuse
vote down
vote up
...
written by Bhavin_SRD , January 24, 2012
written by Bhavin_SRD , January 24, 2012
Hi,
I am getting Nullpointer exception when trying to execute a package. Code errors out at cstmt.execute(); step.
Logs are set at Error level. Below is the log from portno.inv.log file.
I have tried MWA listner recycle but tht does not resolve the issue.
Can you please let me know what can be the issue ?
logs
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) ......6
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) CATCH ERR = java.lang.NullPointerException
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) Error in callable statement null
public void print(MWAEvent mwaevent, TextFieldBean mTextBean) throws AbortHandlerException
{
String strRequestId="0";
CallableStatement cstmt = null;
Session csession = mwaevent.getSession();
Connection con = csession.getConnection();
try
{
cstmt = con.prepareCall(" {call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?)} ");
cstmt.setString(1,mTextBean.getValue());
cstmt.registerOutParameter(2,Types.VARCHAR);
UtilFns.error("......6");
cstmt.execute();
UtilFns.error("......7");
strRequestId = cstmt.getString("p_request_id"); // get output parameter
UtilFns.error("......8");
}catch (Exception e)
{
strRequestId="0";
e.printStackTrace();
UtilFns.error("CATCH ERR = " + e.getStackTrace() );
UtilFns.error("Error in callable statement "+e.getMessage());
}
Thanks,
Bhavin
Votes: +0
I am getting Nullpointer exception when trying to execute a package. Code errors out at cstmt.execute(); step.
Logs are set at Error level. Below is the log from portno.inv.log file.
I have tried MWA listner recycle but tht does not resolve the issue.
Can you please let me know what can be the issue ?
logs
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) ......6
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) CATCH ERR = java.lang.NullPointerException
[Tue Jan 24 04:34:40 EST 2012] (Thread-16) Error in callable statement null
public void print(MWAEvent mwaevent, TextFieldBean mTextBean) throws AbortHandlerException
{
String strRequestId="0";
CallableStatement cstmt = null;
Session csession = mwaevent.getSession();
Connection con = csession.getConnection();
try
{
cstmt = con.prepareCall(" {call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?)} ");
cstmt.setString(1,mTextBean.getValue());
cstmt.registerOutParameter(2,Types.VARCHAR);
UtilFns.error("......6");
cstmt.execute();
UtilFns.error("......7");
strRequestId = cstmt.getString("p_request_id"); // get output parameter
UtilFns.error("......8");
}catch (Exception e)
{
strRequestId="0";
e.printStackTrace();
UtilFns.error("CATCH ERR = " + e.getStackTrace() );
UtilFns.error("Error in callable statement "+e.getMessage());
}
Thanks,
Bhavin
report abuse
vote down
vote up
...
written by Bhavin_SRD , January 25, 2012
written by Bhavin_SRD , January 25, 2012
Error was resolved.
DBA provided me activity logs which had detailed error message . I searched the error at metalink and found it occurs is some JDBC version.
Issue resolution - Removed curly braces in package call
Original code
cstmt = con.prepareCall(" { call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?) } ");
New code
cstmt = con.prepareCall(" call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?) ");
Metalink -
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(viewingMode=1143&bmDocTitle=NullPointerException or SQLException: ORA-00900: invalid SQL statement&bmDocType=PROBLEM&bmDocDsrc=KB&bmDocID=293607.1&from=BOOKMARK))
Votes: +0
DBA provided me activity logs which had detailed error message . I searched the error at metalink and found it occurs is some JDBC version.
Issue resolution - Removed curly braces in package call
Original code
cstmt = con.prepareCall(" { call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?) } ");
New code
cstmt = con.prepareCall(" call XXXX_ASN_MOBILE_PKG.XXXX_SUBMIT_ASN_PRC(?,?) ");
Metalink -
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(viewingMode=1143&bmDocTitle=NullPointerException or SQLException: ORA-00900: invalid SQL statement&bmDocType=PROBLEM&bmDocDsrc=KB&bmDocID=293607.1&from=BOOKMARK))
report abuse
vote down
vote up
