OA Framework will continue to remain a formidable tool in Release12. Although Fusion is destined to use ADF, its methodology will be similar to OA Framework. Although you will need to re-write your OAF extensions in Oracle Fusion, but the OAF concepts can be carried forward to Oracle Fusion Applications. Hence I insist you all invest time to learnOA Framework.
What are the pre-requisites for learning OA Framework?
1. You need to have an Oracle Apps 11i or higher environment to play around with.
2. Basic knowledge of java is needed. Rather I would say basic knowledge of OOP [Object Oriented Programming] is needed. I mean just the concepts.
3. Basics of XML, which can be learnt within an hour from w3schools link
4. Understand MVC as a concept[not in depths as you are just getting started].
Step 1. Which version of jDeveloper to use?
DO NOT use jDeveloper 10g version in Oracle Apps[holds true until 11.5.10]. Oracle Applications tech stack may not always keep up in pace with Standalone Oracle.
Run the below SQL in apps schema
select 'Download patch 4573517' from ad_bugs where bug_number = '4125550' ;
If this returns a record, then download patch 4573517
Otherwise run,
select 'Download patch 4141787' from ad_bugs where bug_number = ‘4017300' ;
If both the above SQL’s do not return a record, then download patch 4045639[assuming you are on 11i]
Step 2. Unzip the downloaded patch file on your local drive. This will contain jDeveloper and FND libraries.
Step 3. Create a database connection and ensure it works by clicking on Test button.
Step 4. Follow the instructions for in file jdevdoc/WebHelp/fwkdevguide.htm
This will be available underneath the jdevdoc directory. You can also use the Help Menu in jDeveloper to access this page.
Step 5. In Tools menu, select preferences, “Embedded OC4J”, try to use "Default Local IP Address" option.
Step 6. You will see toolbox.jws. Expand that, and Right click on Tutorial.jpr. This step is not necessary, however I suggest you do this to sanity check your environment.
Ensure that you get no errors [Warnings are OK though]
Step 7. I suggest you run the HelloWorld to ensure that your runtime environment has been configured. This is underneath oracle.apps.fnd.framework.toolbox.tutorial.server
If your HelloWorld program is running well, then it means you are ready to roll with the Tutorials.
Comments
(61)
Subscribe to this comment's feed
...
written by Anil Passi , January 02, 2007
written by Anil Passi , January 02, 2007
Hi Mukesh,
Once inide jDeveloper[9.0.3 for 11.5.10], use the Help Menu. In Help index you will find link to the tutorial.
Thanks
Anil Passi
Votes: +1
Once inide jDeveloper[9.0.3 for 11.5.10], use the Help Menu. In Help index you will find link to the tutorial.
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Mukesh , January 02, 2007
written by Mukesh , January 02, 2007
Hi Anil,
Its good article for starting to work in OA framwork
can you please inform the document id or URL for accessing Tutorial delivered by Oracle for OA framework
Thanks
Mukesh
Votes: +1
Its good article for starting to work in OA framwork
can you please inform the document id or URL for accessing Tutorial delivered by Oracle for OA framework
Thanks
Mukesh
report abuse
vote down
vote up
...
written by Anil Passi , January 02, 2007
written by Anil Passi , January 02, 2007
Hi Mukesh,
Once inide jDeveloper[9.0.3 for 11.5.10], use the Help Menu. In Help index you will find link to the tutorial.
Thanks
Anil Passi
Votes: +1
Once inide jDeveloper[9.0.3 for 11.5.10], use the Help Menu. In Help index you will find link to the tutorial.
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Srini K , January 03, 2007
written by Srini K , January 03, 2007
Hi I have built a custom page using Jdeveloper 9.0.3. As a stand alone this page runs just fine. I want to plug this into our 11.5.10.2 environment...Is there a step by step doc that explains this...
Thanks
Votes: +0
Thanks
report abuse
vote down
vote up
...
written by Srini K , January 03, 2007
written by Srini K , January 03, 2007
Hi I have built a custom page using Jdeveloper 9.0.3. As a stand alone this page runs just fine. I want to plug this into our 11.5.10.2 environment...Is there a step by step doc that explains this...
Thanks
Votes: +1
Thanks
report abuse
vote down
vote up
...
written by Anil Passi , January 05, 2007
written by Anil Passi , January 05, 2007
.
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracle/apps/per
for human resources. just to ls -lR to see all the files
In fact, i will try to write something up to explain this in a srtuctured manner.
The MDS file, is in $PER_TOP/mds/...
This MDS gets loaded into the database.
Have you done the hello world of OAF? If so, then you can understand the basics from that exercise.
Thanks
Anil Passi
Votes: +0
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracle/apps/per
for human resources. just to ls -lR to see all the files
In fact, i will try to write something up to explain this in a srtuctured manner.
The MDS file, is in $PER_TOP/mds/...
This MDS gets loaded into the database.
Have you done the hello world of OAF? If so, then you can understand the basics from that exercise.
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Anil Passi , January 05, 2007
written by Anil Passi , January 05, 2007
.
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracle/apps/per
for human resources. just to ls -lR to see all the files
In fact, i will try to write something up to explain this in a srtuctured manner.
The MDS file, is in $PER_TOP/mds/...
This MDS gets loaded into the database.
Have you done the hello world of OAF? If so, then you can understand the basics from that exercise.
Thanks
Anil Passi
Votes: +0
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracle/apps/per
for human resources. just to ls -lR to see all the files
In fact, i will try to write something up to explain this in a srtuctured manner.
The MDS file, is in $PER_TOP/mds/...
This MDS gets loaded into the database.
Have you done the hello world of OAF? If so, then you can understand the basics from that exercise.
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Sai , February 15, 2007
written by Sai , February 15, 2007
Hi Anil,
I have one question regarding the download the patch from the database you menioned in step1.
I have queried the same statement I got the record, can you tell me the steps how to download the patch from the database.
Thanks,
Sai
Votes: +0
I have one question regarding the download the patch from the database you menioned in step1.
I have queried the same statement I got the record, can you tell me the steps how to download the patch from the database.
Thanks,
Sai
report abuse
vote down
vote up
...
written by Anil Passi , February 15, 2007
written by Anil Passi , February 15, 2007
Hi Sai
That SQL means that you are on or above 11.5.10CU2, hence you need to use specific version of jDeveloper that which comes in the suggested patch
Thanks,
Anil Passi
Votes: +0
That SQL means that you are on or above 11.5.10CU2, hence you need to use specific version of jDeveloper that which comes in the suggested patch
Thanks,
Anil Passi
report abuse
vote down
vote up
...
written by Anil Passi , February 15, 2007
written by Anil Passi , February 15, 2007
Hi Sai
You need to download the patch from the Metalink.
I assume you have access to Metalink.
Thanks,
Anil
Votes: +0
You need to download the patch from the Metalink.
I assume you have access to Metalink.
Thanks,
Anil
report abuse
vote down
vote up
...
written by Subbu , March 06, 2007
written by Subbu , March 06, 2007
Hi Anil ,
Thanks for the article , I am using 11.5.9 version and i tried to download the patches u mentioned , i was not able to download any , whats the reason? , we can do that only on 11.5.10?
Thanks,
Venkat
Votes: +0
Thanks for the article , I am using 11.5.9 version and i tried to download the patches u mentioned , i was not able to download any , whats the reason? , we can do that only on 11.5.10?
Thanks,
Venkat
report abuse
vote down
vote up
...
written by Anil Passi , March 06, 2007
written by Anil Passi , March 06, 2007
Hi Subbu,
Sorry to hear that. please let me have the patch number, I will check this for myself on Metalink.
Thanks,
Anil Passi
Votes: +0
Sorry to hear that. please let me have the patch number, I will check this for myself on Metalink.
Thanks,
Anil Passi
report abuse
vote down
vote up
...
written by Anil Passi , March 13, 2007
written by Anil Passi , March 13, 2007
I am sorry to say, but you will require connection to database server that is running 11i
Thanks
Anil
Votes: +1
Thanks
Anil
report abuse
vote down
vote up
...
written by jemar , April 07, 2007
written by jemar , April 07, 2007
getting the following error trying to run Tutorial.jpr.... i do not have this url on my system
http://192.168.0.64:8988/OA_HT...orial.jsp
500 Server Error
The following error occurred:
Votes: +0
http://192.168.0.64:8988/OA_HT...orial.jsp
500 Server Error
The following error occurred:
Could not connect because of networking problems. Contact your system administrator. report abuse
vote down
vote up
...
written by sreenivas , April 12, 2007
written by sreenivas , April 12, 2007
Hi Anil,
Whe I am trying to run a simple hello world program it is giving error as
Error initializing server: Error activating application current-workspace-app: No JDBC URL specified for jdbc/Connection2CoreDS
Votes: +0
Whe I am trying to run a simple hello world program it is giving error as
Error initializing server: Error activating application current-workspace-app: No JDBC URL specified for jdbc/Connection2CoreDS
report abuse
vote down
vote up
...
written by JM , April 22, 2007
written by JM , April 22, 2007
Hi Anil,
http://host:port/OA_HTML/OAInf...fo below.
I found patch 5455514 for jDeveloper that matches the version below. Is this the correct approach to find the patch for jDeveloper?
OA Framework Version InformationOA Framework Version 11.5.10.4RUP.
MDS Version 9.0.5.4.89 (build 555)
UIX Version 2.2.24
BC4J Version 9.0.3.13.93
Thanks,
JM
Votes: +0
http://host:port/OA_HTML/OAInf...fo below.
I found patch 5455514 for jDeveloper that matches the version below. Is this the correct approach to find the patch for jDeveloper?
OA Framework Version InformationOA Framework Version 11.5.10.4RUP.
MDS Version 9.0.5.4.89 (build 555)
UIX Version 2.2.24
BC4J Version 9.0.3.13.93
Thanks,
JM
report abuse
vote down
vote up
...
written by Anil Passi , April 25, 2007
written by Anil Passi , April 25, 2007
Hiya
You do not need to dig deep into Java, but basic knowledge of java is necessary to get started.
You can download a free java book from
http://www.mindview.net/Books/TIJ/
Thanks
Anil Passi
Votes: +0
You do not need to dig deep into Java, but basic knowledge of java is necessary to get started.
You can download a free java book from
http://www.mindview.net/Books/TIJ/
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Ash , May 04, 2007
written by Ash , May 04, 2007
Hi Anil,
Is there anyway to learn OAF on 11.5.4?
If yes, can you let me know how?
If no, what is the minimum OA version needed for OAF.
Thanks,
Ash
Votes: +0
Is there anyway to learn OAF on 11.5.4?
If yes, can you let me know how?
If no, what is the minimum OA version needed for OAF.
Thanks,
Ash
report abuse
vote down
vote up
...
written by Omkark , July 04, 2007
written by Omkark , July 04, 2007
Hi Anil,
We are on apps version 11.5.10.2 and oracle db 9.2.0.5.0.
Can you please tell appropriate patch# I need to download from metalink.
Also, if you know the metalink url which will have matrix of this (what version to use).
Thanks !
Omkar
Votes: -1
We are on apps version 11.5.10.2 and oracle db 9.2.0.5.0.
Can you please tell appropriate patch# I need to download from metalink.
Also, if you know the metalink url which will have matrix of this (what version to use).
Thanks !
Omkar
report abuse
vote down
vote up
...
written by BDcunha , July 10, 2007
written by BDcunha , July 10, 2007
Hi,
I am a beginner and want to start learning Oracle Apps. Can U tell me the books needed, online tutorials and all that will be needed to start learning.
I know a little about OOPs programming but not much.
Will Oracle site itself provide me everything ?
Thanks,
BDCunha
Votes: +0
I am a beginner and want to start learning Oracle Apps. Can U tell me the books needed, online tutorials and all that will be needed to start learning.
I know a little about OOPs programming but not much.
Will Oracle site itself provide me everything ?
Thanks,
BDCunha
report abuse
vote down
vote up
...
written by APassi , July 11, 2007
written by APassi , July 11, 2007
Hi BD
If you want to get started with OAFramework, then download the relevant patch of jDeveloper from Metalink. Following that you can try to tutorials provided within the patch itself. Basic understanding of OOPS is all that is required. Unlike programmign in c , indepth oops knowledge is not required for OAF, as OAF design pattern takes care of a lot of oops features by itself.
Thanks
Anil
Votes: +0
If you want to get started with OAFramework, then download the relevant patch of jDeveloper from Metalink. Following that you can try to tutorials provided within the patch itself. Basic understanding of OOPS is all that is required. Unlike programmign in c , indepth oops knowledge is not required for OAF, as OAF design pattern takes care of a lot of oops features by itself.
Thanks
Anil
report abuse
vote down
vote up
...
written by umesh , July 12, 2007
written by umesh , July 12, 2007
Hi ,
I tried Doing as mentioned but i am not able to connect to the apps instance when i need to connect it through VPN.
Hi,
I am trying to run a local installation of the Jdeveloper with RUP5 against a Oracle apps 11.5.10 instance on Rup 5 level ,The OAframework page never Renders and the browser status is always Waiting...
Following are the steps i have Done.
1) Used the Right version of the dbc File.
2) created dummy oa framework projects .
3) As mentioned in the help for the Embedded oc4j setup for running a JDEV in DHCP or VPN mode navigated to Tools>preference > Embedded OC4j and setted up the hostname as "LOCALhost." for Hostname or ip address used to refer to Embedded oc4j
4) Setup the Proxy in the jdeveloper server.
Ran the page it was taking a long time and then a Message
oracle.apps.jtf.cache.CacheLoaderNotFoundException
As a work around mentioned for this issue i have removed the following from the Virtual machines java option
-DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true
After doing this i ran the page and the nothing is rendered and the browser is indefinitely waiting .
This is the Log from the embedded OC4J server
-------------------------------------------------------------------------
[Starting OC4J using the following ports: HTTP=8988, RMI=23891, JMS=9227.]
C:OAFrameworkRUP5jdevbinjdkinjavaw.exe -hotspot -classpath C:OAFrameworkRUP5jdevbinj2eehomeoc4j.jar;C:OAFrameworkRUP5jdevbinjdevlibjdev-oc4j.jar -Xbootclasspath/p:C:OAFrameworkRUP5jdevbinjdevappslibrtojdbc14.jar;C:OAFrameworkRUP5jdevbinjdevappslibrt
ls_charset12.zip -DRUN_FROM_JDEV=true -mx512m -Dhttp.proxyHost=www-proxy.us.oracle.com -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=localhost -Xverify:none -Doracle.j2ee.dont.use.memory.archive=true -Doracle.j2ee.http.socket.timeout=500 com.evermind.server.OC4JServer -config C:OAFrameworkRUP5jdevbinjdevsystem9.0.3.5.1453oc4j-configserver.xml
[waiting for the server to complete its initialization...]
Ready message received from Oc4jNotifier.
Embedded OC4J startup time: 2390 ms.
Auto-deploying OA Framework web application deployment descriptor (New server version detected)...
Oracle9iAS (9.0.3.1.0) Containers for J2EE initialized
TIME: runregion: initialization [0 ms]
Tutalii: C:OAFrameworkRUP5jdevbinjdevappslibrtiasjoc.zip archive
Any Pointer to resolve this Issue or Documentation for running a Jdeveloper with OAframework Extension against an Oracle apps instance would be of great help.
Thanks and Regards
Umesh
Votes: +0
I tried Doing as mentioned but i am not able to connect to the apps instance when i need to connect it through VPN.
Hi,
I am trying to run a local installation of the Jdeveloper with RUP5 against a Oracle apps 11.5.10 instance on Rup 5 level ,The OAframework page never Renders and the browser status is always Waiting...
Following are the steps i have Done.
1) Used the Right version of the dbc File.
2) created dummy oa framework projects .
3) As mentioned in the help for the Embedded oc4j setup for running a JDEV in DHCP or VPN mode navigated to Tools>preference > Embedded OC4j and setted up the hostname as "LOCALhost." for Hostname or ip address used to refer to Embedded oc4j
4) Setup the Proxy in the jdeveloper server.
Ran the page it was taking a long time and then a Message
oracle.apps.jtf.cache.CacheLoaderNotFoundException
As a work around mentioned for this issue i have removed the following from the Virtual machines java option
-DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true
After doing this i ran the page and the nothing is rendered and the browser is indefinitely waiting .
This is the Log from the embedded OC4J server
-------------------------------------------------------------------------
[Starting OC4J using the following ports: HTTP=8988, RMI=23891, JMS=9227.]
C:OAFrameworkRUP5jdevbinjdkinjavaw.exe -hotspot -classpath C:OAFrameworkRUP5jdevbinj2eehomeoc4j.jar;C:OAFrameworkRUP5jdevbinjdevlibjdev-oc4j.jar -Xbootclasspath/p:C:OAFrameworkRUP5jdevbinjdevappslibrtojdbc14.jar;C:OAFrameworkRUP5jdevbinjdevappslibrt
ls_charset12.zip -DRUN_FROM_JDEV=true -mx512m -Dhttp.proxyHost=www-proxy.us.oracle.com -Dhttp.proxyPort=80 -Dhttp.nonProxyHosts=localhost -Xverify:none -Doracle.j2ee.dont.use.memory.archive=true -Doracle.j2ee.http.socket.timeout=500 com.evermind.server.OC4JServer -config C:OAFrameworkRUP5jdevbinjdevsystem9.0.3.5.1453oc4j-configserver.xml
[waiting for the server to complete its initialization...]
Ready message received from Oc4jNotifier.
Embedded OC4J startup time: 2390 ms.
Auto-deploying OA Framework web application deployment descriptor (New server version detected)...
Oracle9iAS (9.0.3.1.0) Containers for J2EE initialized
TIME: runregion: initialization [0 ms]
Tutalii: C:OAFrameworkRUP5jdevbinjdevappslibrtiasjoc.zip archive
Any Pointer to resolve this Issue or Documentation for running a Jdeveloper with OAframework Extension against an Oracle apps instance would be of great help.
Thanks and Regards
Umesh
report abuse
vote down
vote up
...
written by APassi , July 12, 2007
written by APassi , July 12, 2007
Hi Umesh,
1. Does this mean you are able to get this working when without VPN?
2. Were you able to test the DB Connection via jDev
3. Do you have any other version of jDev installed on your PC?
If so, is the jdev home environment variable pointing to the correct jdev?
4. Instead of -DFND_JDBC_STMT_CACHE_SIZE=200 -DCACHENODBINIT=true
try just -DFND_JDBC_STMT_CACHE_SIZE=200
5. Are you running RUP5 instance on the database being connected to?
You can also try to remove the jDev FND libraries from the jDev classpath, and FTP the $JAVA_TOP/oracle/apps/fnd underneath myclasses from the server
Thanks
Anil Passi
report abuse
vote down
vote up
...
written by Satyabrat , August 16, 2007
written by Satyabrat , August 16, 2007
Hi Anil,
Hope you are doing Good!
I'm working in Oracle Apps 12i env.
Which version of Jdeveloper I should use?
Can you please guide me a good link for documentation/tutorial which depicts steps for writing simple programs like "Hello World" and so on...
And also the procedure for installation of Jdeveloper.
Galore of best wishes...
Thanks
Satya
Votes: +0
Hope you are doing Good!
I'm working in Oracle Apps 12i env.
Which version of Jdeveloper I should use?
Can you please guide me a good link for documentation/tutorial which depicts steps for writing simple programs like "Hello World" and so on...
And also the procedure for installation of Jdeveloper.
Galore of best wishes...
Thanks
Satya
report abuse
vote down
vote up
...
written by Tony , August 19, 2007
written by Tony , August 19, 2007
Hi Anil,
Do i need Oracle Applications to Test the Hello World program mentioned above.
Is there a method i can test some basic OAF without Apps(I have oracle 10g database)
Thanks
Tony
Votes: +0
Do i need Oracle Applications to Test the Hello World program mentioned above.
Is there a method i can test some basic OAF without Apps(I have oracle 10g database)
Thanks
Tony
report abuse
vote down
vote up
...
written by Tony , August 21, 2007
written by Tony , August 21, 2007
Hi Anil,
What i am trying to ask is that whether a local database is enough to test some basic OAF screens
Thanks
Tony
Votes: +0
What i am trying to ask is that whether a local database is enough to test some basic OAF screens
Thanks
Tony
report abuse
vote down
vote up
...
written by Shilpi , September 25, 2007
written by Shilpi , September 25, 2007
I want to acheive the following in Manager Self Service Assignment page - Depending on the job name and location selected, i want to derive and populate the grade field automatically. Could you please let me know how to go about this? Also, please let me know how to import the seeded sources into jDeveloper and view their current structure and properties?
Votes: +0
report abuse
vote down
vote up
...
written by Tony , September 26, 2007
written by Tony , September 26, 2007
Hi Anil,
I tried the Hello World program but i am getting one error
could not find specified responsibility. (could not lookup message because there is no database)
I have the latest dbc file transferred to secure directory in bin mode
and i have connected with the database
i have given my application user name and responsibity
But for the application short name and responsibity key i tried differant it is not working
my doubt is in the apllications i am not able to find the RESPONSIBITY_KEY
FWK_TBX_TUTORIAL
My Application is 11.5.9
pls comment on this
Votes: +0
I tried the Hello World program but i am getting one error
could not find specified responsibility. (could not lookup message because there is no database)
I have the latest dbc file transferred to secure directory in bin mode
and i have connected with the database
i have given my application user name and responsibity
But for the application short name and responsibity key i tried differant it is not working
my doubt is in the apllications i am not able to find the RESPONSIBITY_KEY
FWK_TBX_TUTORIAL
My Application is 11.5.9
pls comment on this
report abuse
vote down
vote up
Errors
written by Suresh Mutyala , October 21, 2007
written by Suresh Mutyala , October 21, 2007
Hi Anil,
I really appriciate ur help on the OAF.
I tried to create a Helloworld page but it shows me errors while running the Helloworld.xml page
I checked the Database connection Still it is not required for Helloworld
Iam working on 11.5.9 so i downloded the JDeveloper 9i
Pls replay back me what will be the things to overcme these erors.
Thanks,
Suresh M.
Votes: +0
I really appriciate ur help on the OAF.
I tried to create a Helloworld page but it shows me errors while running the Helloworld.xml page
I checked the Database connection Still it is not required for Helloworld
Iam working on 11.5.9 so i downloded the JDeveloper 9i
Pls replay back me what will be the things to overcme these erors.
Thanks,
Suresh M.
report abuse
vote down
vote up
To learn Oracle Apps Framework
written by BV , October 24, 2007
written by BV , October 24, 2007
Hi,
I am a beginner and want to start learning Oracle Apps. Can U tell me the books needed, online tutorials and all that will be needed to start learning. Please let me know the patch id which i need to download.
Thanks
BV
Votes: +0
I am a beginner and want to start learning Oracle Apps. Can U tell me the books needed, online tutorials and all that will be needed to start learning. Please let me know the patch id which i need to download.
Thanks
BV
report abuse
vote down
vote up
Errors was issued by running search demo in local!!!!
written by Lee , January 04, 2008
written by Lee , January 04, 2008
Hi Anil,
I got some issues when I run searching demo in local.But hello world is demostrated good in my local. Anywhere can got me the issues?
For searching demo, I created self-package to development. I got 'oracle.apps.xxx' instead of 'oracle.apps.ak.xxx'. Did that influence?
Here were the erros,
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:5526)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:95
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:5526)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:95
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
Thanks and Regards
Sinolee
Votes: +0
I got some issues when I run searching demo in local.But hello world is demostrated good in my local. Anywhere can got me the issues?
For searching demo, I created self-package to development. I got 'oracle.apps.xxx' instead of 'oracle.apps.ak.xxx'. Did that influence?
Here were the erros,
Exception Details.
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:5526)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:95
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getAppId(OAWebBeanFactoryImpl.java:5526)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:95
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41
at _OA._jspService(OA.jsp:40)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)
Thanks and Regards
Sinolee
report abuse
vote down
vote up
Connect to Oracle DB in RAC
written by kvgshv , January 07, 2008
written by kvgshv , January 07, 2008
Anil,
How can I connect to an Oracle database in RAC environment in JDeveloper. Please help.
Thank you,
Harsha Kona
Votes: +0
How can I connect to an Oracle database in RAC environment in JDeveloper. Please help.
Thank you,
Harsha Kona
report abuse
vote down
vote up
not able to start jdeveloper
written by not able to start jdeveloper , January 08, 2008
written by not able to start jdeveloper , January 08, 2008
Hi Anil,
i downloaded the pathc 4573517 extracted the zip files.
It created three folders
jdevbin
jdevdoc
jdevhome
Can you please let me knwo what next is to be done to run the Jdeveloper.
Regards
Deepak
Votes: +0
i downloaded the pathc 4573517 extracted the zip files.
It created three folders
jdevbin
jdevdoc
jdevhome
Can you please let me knwo what next is to be done to run the Jdeveloper.
Regards
Deepak
report abuse
vote down
vote up
not able to start jdeveloper - Answer
written by Sanket , January 09, 2008
written by Sanket , January 09, 2008
Hi Deepak,
You have to navigate to jdevbinjdevin and in there you need to execute "jdevw.exe"
Hope that solves your query.
Regards,
-Sanket.
Votes: +0
You have to navigate to jdevbinjdevin and in there you need to execute "jdevw.exe"
Hope that solves your query.
Regards,
-Sanket.
report abuse
vote down
vote up
not able to start jdeveloper - Answer
written by Sanket , January 09, 2008
written by Sanket , January 09, 2008
The previous reply got "escaped"... Here is a repost...
Hi Deepak,
You have to navigate to jdevbin -> jdev -> bin and in there you need to execute "jdevw.exe"
Hope that solves your query.
Regards,
-Sanket.
Votes: +0
Hi Deepak,
You have to navigate to jdevbin -> jdev -> bin and in there you need to execute "jdevw.exe"
Hope that solves your query.
Regards,
-Sanket.
report abuse
vote down
vote up
OAF Transition in 12i
written by Aparna , January 14, 2008
written by Aparna , January 14, 2008
Hi Anil ,
We are currently in the process of upgrading from 11.5.8 to 12i. Any thoughts on how to deal with OAF customizations when upgrading?
Thanks
Aparna
Votes: +0
We are currently in the process of upgrading from 11.5.8 to 12i. Any thoughts on how to deal with OAF customizations when upgrading?
Thanks
Aparna
report abuse
vote down
vote up
For Windows NT
written by Jay , January 17, 2008
written by Jay , January 17, 2008
Hi Anil,
Which patch should i install to run JDeveloper with WindowsNT OS?
I have downloaded Patch# 4573517. But it only applies to Windows2000 and WindowsXP.
Votes: +0
Which patch should i install to run JDeveloper with WindowsNT OS?
I have downloaded Patch# 4573517. But it only applies to Windows2000 and WindowsXP.
report abuse
vote down
vote up
JDEVELOPER 9i?
written by Pramod , February 09, 2008
written by Pramod , February 09, 2008
Hello
I am on 11.5.10 on oracle apps. But i do not find JDEVELOPER 9i in OTN. All I see is 10g or 11g. Can you pls poin tme out to 9iJDEVELOPER?
OR can i use JDEVELOPER 10g for 11.5.10?
Please let me know
Thank you in advance
Pramod
Votes: +0
I am on 11.5.10 on oracle apps. But i do not find JDEVELOPER 9i in OTN. All I see is 10g or 11g. Can you pls poin tme out to 9iJDEVELOPER?
OR can i use JDEVELOPER 10g for 11.5.10?
Please let me know
Thank you in advance
Pramod
report abuse
vote down
vote up
Can I run the J Devloper for APPS 11.5.3 Version ??
written by Prasant , February 13, 2008
written by Prasant , February 13, 2008
Hi Anil,
I like your help and effort for the group .I need one information from you .
I am using PPS 11.5.3 Version .Can I run the J Devloper for APPS 11.5.3 Version ??
Basically I want to know which version of APPS is getting support the J Devloper .
Votes: +0
I like your help and effort for the group .I need one information from you .
I am using PPS 11.5.3 Version .Can I run the J Devloper for APPS 11.5.3 Version ??
Basically I want to know which version of APPS is getting support the J Devloper .
report abuse
vote down
vote up
How to find the right version for Jdeveloper for Oracle Apps---
written by Pramod Bellamkonda , March 21, 2008
written by Pramod Bellamkonda , March 21, 2008
first
1) when you log in oracle applications type in
http:///OA_HTML/OAInfo.jsp
2) Then you get the Oracle Apps version you working on like below
OA Framework Version Information
OA Framework Version 11.5.10.2CU.
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51
3) so my version of apps (OAF) is 11.5.10.2CU
4) go to METALINK and search for Doc ID: Note:416708.1
there you find the below in form of a TABLE.
https://metalink.oracle.com/metalink/plsql/f? p=130:14:7711961564797583862::::p14_database_id,p14_doc id,p14_show_header,p14_show_help,p14_black_frame,p14_fo nt:NOT,416708.1,1,1,1,helvetica
click the above link
there you can select the PATCH as per your version of OAF in u r Oracle Apps.
MINE is PATCH 4573517 for 11.5.10.2CU
Thanks
Pramod Bellamkonda ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it )
Votes: +0
1) when you log in oracle applications type in
http:///OA_HTML/OAInfo.jsp
2) Then you get the Oracle Apps version you working on like below
OA Framework Version Information
OA Framework Version 11.5.10.2CU.
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51
3) so my version of apps (OAF) is 11.5.10.2CU
4) go to METALINK and search for Doc ID: Note:416708.1
there you find the below in form of a TABLE.
https://metalink.oracle.com/metalink/plsql/f? p=130:14:7711961564797583862::::p14_database_id,p14_doc id,p14_show_header,p14_show_help,p14_black_frame,p14_fo nt:NOT,416708.1,1,1,1,helvetica
click the above link
there you can select the PATCH as per your version of OAF in u r Oracle Apps.
MINE is PATCH 4573517 for 11.5.10.2CU
Thanks
Pramod Bellamkonda ( This e-mail address is being protected from spambots. You need JavaScript enabled to view it )
report abuse
vote down
vote up
...
written by Pramod Bellamkonda , March 21, 2008
written by Pramod Bellamkonda , March 21, 2008
please type in your HOST name between http and OA_HTML
Votes: +0
report abuse
vote down
vote up
...
written by Rama , October 25, 2008
written by Rama , October 25, 2008
This tutorial is a good start for learning Oracle Apps. Can any one send me details of MVC architecture.
Votes: +0
report abuse
vote down
vote up
OA Framework
written by Pc rao , October 26, 2008
written by Pc rao , October 26, 2008
Hi Anil,
I am actually a Oracle developer i know only SQL, PL/SQL, Forms and reports and i have a very fair knowledge of Java Core, but not the J2EE..
I don't know Oracle apps to be frank what is oracle apps also i don't know.
I am now planning to learn OA framework, I have oracle 9i Database installed on my system i want an information, which Jdeveloper will i need to download and how to set the configuration to access the Tutorials.
Please provide me the information for the above questions....
Best regards,
PC rao
Votes: +0
I am actually a Oracle developer i know only SQL, PL/SQL, Forms and reports and i have a very fair knowledge of Java Core, but not the J2EE..
I don't know Oracle apps to be frank what is oracle apps also i don't know.
I am now planning to learn OA framework, I have oracle 9i Database installed on my system i want an information, which Jdeveloper will i need to download and how to set the configuration to access the Tutorials.
Please provide me the information for the above questions....
Best regards,
PC rao
report abuse
vote down
vote up
Setting View Object Attribute Values through Application Module
written by A.Malar Selvam , December 17, 2008
written by A.Malar Selvam , December 17, 2008
Dear Anil,
I am new to OA Framework.
I am developing one small module using OA Framework. I have three views in that module. I would like to set some of the view attributes through Application Module before committing the values into the database. I am trying inthe following manner but the values are not updated in the table.
SalesHeadersImpl sheader = getSalesHeaders();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();
sheader.setProperty("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.setProperty("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.setProperty("SaleOrderHeaderId",sheader.getProperty("SaleOrderHeaderId"));
pvo.setProperty("SaleOrderHeaderId",sheader.getProperty("SaleOrderHeaderId"));
getDBTransaction().commit();
Kindly guide me how to do that.
Regards.
Malar.
Votes: +0
I am new to OA Framework.
I am developing one small module using OA Framework. I have three views in that module. I would like to set some of the view attributes through Application Module before committing the values into the database. I am trying inthe following manner but the values are not updated in the table.
SalesHeadersImpl sheader = getSalesHeaders();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();
sheader.setProperty("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.setProperty("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.setProperty("SaleOrderHeaderId",sheader.getProperty("SaleOrderHeaderId"));
pvo.setProperty("SaleOrderHeaderId",sheader.getProperty("SaleOrderHeaderId"));
getDBTransaction().commit();
Kindly guide me how to do that.
Regards.
Malar.
report abuse
vote down
vote up
Null Pointer Exception
written by A.Malar Selvam , December 17, 2008
written by A.Malar Selvam , December 17, 2008
Dear Anil,
I have tried in the way of getting Current and setting the value, but it is returning Null Pointer Exception.
I have tried in two ways.
1) SalesHeadersImpl sheader = getSalesHeaders();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();
sheader.getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.getCurrentRow().setAttribute("SaleOrderHeaderId1",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
pvo.getCurrentRow().setAttribute("SaleOrderHeaderId2",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
getDBTransaction().commit();
-------------------------------------
getSalesHeaders().getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
getSalesHeaders().getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
getLinesVO().getCurrentRow().setAttribute("SaleOrderHeaderId1",getSalesHeaders().getCurrentRow().getAttribute("SaleOrderHeaderId"));
getPaymentVO().getCurrentRow().setAttribute("SaleOrderHeaderId2",getSalesHeaders().getCurrentRow().getAttribute("SaleOrderHeaderId"));
getDBTransaction().commit();
------------------------------------------------------------
Please guide me.
Regards.
Malar.
Votes: +0
I have tried in the way of getting Current and setting the value, but it is returning Null Pointer Exception.
I have tried in two ways.
1) SalesHeadersImpl sheader = getSalesHeaders();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();
sheader.getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.getCurrentRow().setAttribute("SaleOrderHeaderId1",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
pvo.getCurrentRow().setAttribute("SaleOrderHeaderId2",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
getDBTransaction().commit();
-------------------------------------
getSalesHeaders().getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
getSalesHeaders().getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
getLinesVO().getCurrentRow().setAttribute("SaleOrderHeaderId1",getSalesHeaders().getCurrentRow().getAttribute("SaleOrderHeaderId"));
getPaymentVO().getCurrentRow().setAttribute("SaleOrderHeaderId2",getSalesHeaders().getCurrentRow().getAttribute("SaleOrderHeaderId"));
getDBTransaction().commit();
------------------------------------------------------------
Please guide me.
Regards.
Malar.
report abuse
vote down
vote up
...
written by Anil- , December 17, 2008
written by Anil- , December 17, 2008
Hi Malar
Look at the error stack carefully, you will find the line number where this null pointer exception was raised.
Then sorround your code with an if condition
if ( vo !=null )
{
}
However more importantly, why is your vo getting null handle must be investigated?
OR
It is the currentRow which is null
if so, do this around your code
if ( vo.getCurrentRow() != null )
bottomline is to first identify the statement raising error and then its cause
Also-sheader is this pointing to VO? the naming convention does not suggest that
Thanks
Anil
Votes: +0
Look at the error stack carefully, you will find the line number where this null pointer exception was raised.
Then sorround your code with an if condition
if ( vo !=null )
{
}
However more importantly, why is your vo getting null handle must be investigated?
OR
It is the currentRow which is null
if so, do this around your code
if ( vo.getCurrentRow() != null )
bottomline is to first identify the statement raising error and then its cause
Also-sheader is this pointing to VO? the naming convention does not suggest that
Thanks
Anil
report abuse
vote down
vote up
...
written by A.Malar Selvam , December 17, 2008
written by A.Malar Selvam , December 17, 2008
Dear Anil,
The Error coming in the following Lines.
sheader.getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.getCurrentRow().setAttribute("SaleOrderHeaderId1",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
pvo.getCurrentRow().setAttribute("SaleOrderHeaderId2",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
As you said the current row is coming as null.
Also SalesHeaders is a VO only.
What may be the cause, the Row is coming as Null?
How to get the View Row Attribute Values?
Also I tried to print the Row Values as below, that also raising error:
System.out.println("Row Count : "+sheader.getRowCount());
It is raising: JBO-25036: An invalid object operation was invoked on type View Object with name SalesHeadersImpl_4
Please guide me.
Regards.
Malar.
Votes: +0
The Error coming in the following Lines.
sheader.getCurrentRow().setAttribute("SaleOrderHeaderId",getOADBTransaction().getSequenceValue("XXPOS_SALE_HEADERS_S"));
sheader.getCurrentRow().setAttribute("SaleOrderNumber",getOADBTransaction().getSequenceValue("XXPOS_SALE_ORDER_NUMBER_S"));
lvo.getCurrentRow().setAttribute("SaleOrderHeaderId1",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
pvo.getCurrentRow().setAttribute("SaleOrderHeaderId2",sheader.getCurrentRow().getAttribute("SaleOrderHeaderId"));
As you said the current row is coming as null.
Also SalesHeaders is a VO only.
What may be the cause, the Row is coming as Null?
How to get the View Row Attribute Values?
Also I tried to print the Row Values as below, that also raising error:
System.out.println("Row Count : "+sheader.getRowCount());
It is raising: JBO-25036: An invalid object operation was invoked on type View Object with name SalesHeadersImpl_4
Please guide me.
Regards.
Malar.
report abuse
vote down
vote up
How to call Standard Oracle report in OAF page
written by PrathapReddy K , December 30, 2008
written by PrathapReddy K , December 30, 2008
Hi Anil,
I am new to OAF and trying some sample OAF application.
my doubt is can we able to run a Standard Oracle report in the OAF page?
the requirement is we need to generate the report after the processing is done in the OAF page.
Can you please let me know weather it is possible or not.
If it is possible please let me know how that details.
Regards--
PrathapReddy.
Votes: +0
I am new to OAF and trying some sample OAF application.
my doubt is can we able to run a Standard Oracle report in the OAF page?
the requirement is we need to generate the report after the processing is done in the OAF page.
Can you please let me know weather it is possible or not.
If it is possible please let me know how that details.
Regards--
PrathapReddy.
report abuse
vote down
vote up
...
written by Anil Passi-- , December 30, 2008
written by Anil Passi-- , December 30, 2008
You can call fnd_request.submit_request from Application Module via JDBC Callable Statement.
To show the report in real-time in browser, see this link http://apps2fusion.com/at/ps/2...-framework
Votes: +1
To show the report in real-time in browser, see this link http://apps2fusion.com/at/ps/2...-framework
report abuse
vote down
vote up
...
written by Haritha , April 29, 2009
written by Haritha , April 29, 2009
Hi anil,
How is this "programmatic query" attribute of the messagelovinput item used??
Votes: +0
How is this "programmatic query" attribute of the messagelovinput item used??
report abuse
vote down
vote up
Null Pointer Exception Error
written by udit.krjain , July 08, 2009
written by udit.krjain , July 08, 2009
i am getting a Null Pointer Exception in my CreateEmployeeCO. Can someonr pls help me how to remove it...i try all the ways...match all the steps...buts it remain same.
This is my processFormRequest() of CO=====
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);
OAApplicationModule am = pageContext.getApplicationModule(webBean);
if (pageContext.getParameter("Apply")!=null) {
OAViewObject vo = (OAViewObject)am.findViewObject("EmpTryVO1");
String empName = (String)vo.getCurrentRow().getAttribute("FirstName");
Number empNumber = (Number)vo.getCurrentRow().getAttribute("EmployeeId");
String empNum = String.valueOf(empNumber.intValue());
am.invokeMethod("apply");
MessageToken[] tokens = { new MessageToken("EMP_NAME", empName),
new MessageToken("EMP_NUMBER", empNum) };
OAException confirmMessage = new OAException("AK", "FWK_TBX_T_EMP_CREATE_CONFIRM", tokens,
OAException.CONFIRMATION, null);
pageContext.putDialogMessage(confirmMessage);
pageContext.forwardImmediately("OA.jsp?page=/oracle/apps/ak/Emptry/webui/EmpTrySearchPG",
null,
OAWebBeanConstants.KEEP_MENU_CONTEXT,
null,
null,
true, // retain AM
OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
}
}
Bold and Italic Line above is creating a NullPointerException in error report.
Thanks in Advance,
Udit
Votes: +0
This is my processFormRequest() of CO=====
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);
OAApplicationModule am = pageContext.getApplicationModule(webBean);
if (pageContext.getParameter("Apply")!=null) {
OAViewObject vo = (OAViewObject)am.findViewObject("EmpTryVO1");
String empName = (String)vo.getCurrentRow().getAttribute("FirstName");
Number empNumber = (Number)vo.getCurrentRow().getAttribute("EmployeeId");
String empNum = String.valueOf(empNumber.intValue());
am.invokeMethod("apply");
MessageToken[] tokens = { new MessageToken("EMP_NAME", empName),
new MessageToken("EMP_NUMBER", empNum) };
OAException confirmMessage = new OAException("AK", "FWK_TBX_T_EMP_CREATE_CONFIRM", tokens,
OAException.CONFIRMATION, null);
pageContext.putDialogMessage(confirmMessage);
pageContext.forwardImmediately("OA.jsp?page=/oracle/apps/ak/Emptry/webui/EmpTrySearchPG",
null,
OAWebBeanConstants.KEEP_MENU_CONTEXT,
null,
null,
true, // retain AM
OAWebBeanConstants.ADD_BREAD_CRUMB_NO);
}
}
Bold and Italic Line above is creating a NullPointerException in error report.
Thanks in Advance,
Udit
report abuse
vote down
vote up
...
written by Anil- , July 08, 2009
written by Anil- , July 08, 2009
Is EmpTryVO1 attached to Application Module?
Votes: +0
report abuse
vote down
vote up
Test OAF Personalization in JDeveloper
written by Yogasri , September 27, 2009
written by Yogasri , September 27, 2009
Hi Anil, let me first say thanks to your great work. Very helpfull to many of us. I am new to OAF stuff and your articles are great motivation.
Recently I am given a new requirement on OAF side. Basically I need to add a column in the iSupplier -> Order -> Work Orders and the page is OSPSearchPG. I need to add Item revision column in that.
I checked the view def in the backend and realised that it has that column already. Only thing is i ned to add it to the select statement of the page and create a field on the page and map the same. To accomplish this, i was told that i just need to create the VO extension and do the personalization.
As we have limited access to the server, i decided to do everything using JDeveloper. SO i created the VO extension SearchResultExtnVO for SearchResultVO. Then i opened that page in Jdeveloper, ran it and added the personalization. While defining the item, i specified the View Attribute as : AssemblyItemRevision and the View Instance as : SearchResultExtnVO (this is the new extension i created). The error message says :
oracle.apps.fnd.OAFramework.OAException: oracle.jbo.NoDefException:JBO-25002: Definition AssemblyItemRevision of type Attribute not found.
So I tried to change the View Instance as : SearchResultVO (Seeded one), then i am not getting above error but when I try to query the data with some search criteria, at that time it is giving the same above error.
If at all I want to run the page and see how my personalization columns are getting data from jdeveloper, am i missing any steps? What i am not able to understand is i have the db credentials and apps credentials setup correctly in jdeveloper and i was able to run the page without my personalization and query dtaa. This issue is coming only after i add the column....please help me, I appreciate your help , thanks
Yogasri
Votes: +0
Recently I am given a new requirement on OAF side. Basically I need to add a column in the iSupplier -> Order -> Work Orders and the page is OSPSearchPG. I need to add Item revision column in that.
I checked the view def in the backend and realised that it has that column already. Only thing is i ned to add it to the select statement of the page and create a field on the page and map the same. To accomplish this, i was told that i just need to create the VO extension and do the personalization.
As we have limited access to the server, i decided to do everything using JDeveloper. SO i created the VO extension SearchResultExtnVO for SearchResultVO. Then i opened that page in Jdeveloper, ran it and added the personalization. While defining the item, i specified the View Attribute as : AssemblyItemRevision and the View Instance as : SearchResultExtnVO (this is the new extension i created). The error message says :
oracle.apps.fnd.OAFramework.OAException: oracle.jbo.NoDefException:JBO-25002: Definition AssemblyItemRevision of type Attribute not found.
So I tried to change the View Instance as : SearchResultVO (Seeded one), then i am not getting above error but when I try to query the data with some search criteria, at that time it is giving the same above error.
If at all I want to run the page and see how my personalization columns are getting data from jdeveloper, am i missing any steps? What i am not able to understand is i have the db credentials and apps credentials setup correctly in jdeveloper and i was able to run the page without my personalization and query dtaa. This issue is coming only after i add the column....please help me, I appreciate your help , thanks
Yogasri
report abuse
vote down
vote up
page working on jdev not working on server
written by trks , October 20, 2009
written by trks , October 20, 2009
Hi
I encountered the following error when i moved code on to server. it was working fine in jdeveloper.,
the code containls 1) xml page; packege structure Customfileoracleapps nd ramework ilewebuiFile
2) controller ; packege structure Customfileoracleapps nd ramework ilewebuiFileCO
process request: no code
process formrequwst: some operation is getting performed
3) Application module ; just a dummy AM for name sake i have created to attach to page
The page is performing well in jdeveloper giving desired output
I performed these operations on the page to move to server
moved packeage folder consisting all the class files and xml files on to java_top
xml inported the xml page file
bounced apache
ensured everything is moved fine by checking jdr_utils.printdocument also
while accessing the page from apps instance(server) it is giving this error
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1969)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
at _oa__html._OA._jspService(_OA.java:86)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at oracle.jsp.JspServlet.internalService(JspServlet.java)
at oracle.jsp.JspServlet.service(JspServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:58
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java)
at _oa__html._RF._jspService(_RF.java:100)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at oracle.jsp.JspServlet.internalService(JspServlet.java)
at oracle.jsp.JspServlet.service(JspServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:58
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:571)
## Detail 0 ##
java.lang.NullPointerException
at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:513)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3719)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3452)
Regards
TRKS
Votes: +1
I encountered the following error when i moved code on to server. it was working fine in jdeveloper.,
the code containls 1) xml page; packege structure Customfileoracleapps nd ramework ilewebuiFile
2) controller ; packege structure Customfileoracleapps nd ramework ilewebuiFileCO
process request: no code
process formrequwst: some operation is getting performed
3) Application module ; just a dummy AM for name sake i have created to attach to page
The page is performing well in jdeveloper giving desired output
I performed these operations on the page to move to server
moved packeage folder consisting all the class files and xml files on to java_top
xml inported the xml page file
bounced apache
ensured everything is moved fine by checking jdr_utils.printdocument also
while accessing the page from apps instance(server) it is giving this error
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.NullPointerException;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1969)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
at _oa__html._OA._jspService(_OA.java:86)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at oracle.jsp.JspServlet.internalService(JspServlet.java)
at oracle.jsp.JspServlet.service(JspServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:58
at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java)
at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java)
at _oa__html._RF._jspService(_RF.java:100)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java)
at oracle.jsp.JspServlet.internalService(JspServlet.java)
at oracle.jsp.JspServlet.service(JspServlet.java)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:58
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:571)
## Detail 0 ##
java.lang.NullPointerException
at oracle.apps.fnd.framework.webui.JRAD2AKMapper.getRootMElement(JRAD2AKMapper.java:513)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getWebBeanTypeDataFromJRAD(OAWebBeanFactoryImpl.java:3719)
at oracle.apps.fnd.framework.webui.OAWebBeanFactoryImpl.getRootApplicationModuleClass(OAWebBeanFactoryImpl.java:3452)
Regards
TRKS
report abuse
vote down
vote up
...
written by adi , November 19, 2009
written by adi , November 19, 2009
Hi Anil,
I have a varchar2 column in a VO. This field will store the credit limit of a customer. I want to display this column in a formatted manner.
like if the column value is 10000 , i want to dispaly it as 10,0000 . I have seen few threads it seems it is not possible to formatte a varchar2 column.
Can u suggest me to overcome this issue
Votes: +0
I have a varchar2 column in a VO. This field will store the credit limit of a customer. I want to display this column in a formatted manner.
like if the column value is 10000 , i want to dispaly it as 10,0000 . I have seen few threads it seems it is not possible to formatte a varchar2 column.
Can u suggest me to overcome this issue
report abuse
vote down
vote up
project
written by prj , November 20, 2009
written by prj , November 20, 2009
Hi Anil Passi,
I like this site which is very helpful for beginners
I'm interested to get the free r12 erp host to practice on, though I have 8 years experience in erp I still look for the tips and guides in the google. I need to upgrade myself to the new versions of erp. I have one year old baby to take care, so looking for project to work remote. Could u help me in this.
Regards...
Votes: +0
I like this site which is very helpful for beginners
I'm interested to get the free r12 erp host to practice on, though I have 8 years experience in erp I still look for the tips and guides in the google. I need to upgrade myself to the new versions of erp. I have one year old baby to take care, so looking for project to work remote. Could u help me in this.
Regards...
report abuse
vote down
vote up
| < Prev | Next > |
|---|
Its good article for starting to work in OA framwork
can you please inform the document id or URL for accessing Tutorial delivered by Oracle for OA framework
Thanks
Mukesh