Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Related Items

Home
This website has now moved to http://apps2fusion.com





OA Framework | Print |  E-mail
Written by Anil Passi   
Friday, 29 December 2006
The OA Framework Tutorial delivered by Oracle is very good. Hence you may decide to ignore this article. The only reason I am writing this is based upon the requests that I received.

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 (45)add
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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
...
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: Could not connect because of networking problems. Contact your system administrator.
...
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
...
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
...
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
...
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
...
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
...
written by Anil Passi , July 04, 2007
Hi Omkar

Please see the comments section of http://oracle.anilpassi.com/in...ratch.html

I have listed the patches there

Thanks
Anil
...
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

...
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
...
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

...
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

...
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 smilies/smiley.gif


...
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
...
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
...
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?
...
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
Errors
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.

To learn Oracle Apps Framework
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
Errors was issued by running search demo in local!!!!
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:41smilies/cool.gif
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:95smilies/cool.gif
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41smilies/cool.gif
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:95smilies/cool.gif
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:41smilies/cool.gif
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

Connect to Oracle DB in RAC
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
not able to start jdeveloper
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
not able to start jdeveloper - Answer
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.
not able to start jdeveloper - Answer
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.
OAF Transition in 12i
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
For Windows NT
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.
JDEVELOPER 9i?
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
Can I run the J Devloper for APPS 11.5.3 Version ??
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 .
How to find the right version for Jdeveloper for Oracle Apps---
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 (Pramod.Oracle@gmail.com)

link correction
written by Pramod Bellamkonda , March 21, 2008
http:// /OA_HTML/OAInfo.jsp
...
written by Pramod Bellamkonda , March 21, 2008
please type in your HOST name between http and OA_HTML
...
written by Anil Passi , March 21, 2008
Thanks Pramod
You must be logged in to a comment. Please register if you do not have an account yet.

busy