Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

Contact Us

OA Framework - All Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

 

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




Anil Passi

Comments   

0 #1 Mukesh 2007-01-02 00:00
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

Th anks
Mukesh
Quote
0 #2 Anil Passi 2007-01-02 00:00
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.

Th anks
Anil Passi
Quote
0 #3 Mukesh 2007-01-02 00:00
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

Th anks
Mukesh
Quote
0 #4 Anil Passi 2007-01-02 00:00
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.

Th anks
Anil Passi
Quote
0 #5 Srini K 2007-01-03 00:00
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...I s there a step by step doc that explains this...

Than ks
Quote
0 #6 Srini K 2007-01-03 00:00
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...I s there a step by step doc that explains this...

Than ks
Quote
0 #7 Anil Passi 2007-01-05 00:00
.
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracl e/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.

Ha ve you done the hello world of OAF? If so, then you can understand the basics from that exercise.

Th anks
Anil Passi
Quote
0 #8 Anil Passi 2007-01-05 00:00
.
.
.
Hi Kevin
The java files are in $JAVA_TOP/oracl e/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.

Ha ve you done the hello world of OAF? If so, then you can understand the basics from that exercise.

Th anks
Anil Passi
Quote
0 #9 Sai 2007-02-15 00:00
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.

Th anks,
Sai
Quote
0 #10 Anil Passi 2007-02-15 00:00
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
Quote
0 #11 Anil Passi 2007-02-15 00:00
Hi Sai

You need to download the patch from the Metalink.
I assume you have access to Metalink.

Th anks,
Anil
Quote
0 #12 Subbu 2007-03-06 00:00
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,
Ve nkat
Quote
0 #13 Anil Passi 2007-03-06 00:00
Hi Subbu,

Sorry to hear that. please let me have the patch number, I will check this for myself on Metalink.

Th anks,
Anil Passi
Quote
0 #14 Anil Passi 2007-03-13 00:00
I am sorry to say, but you will require connection to database server that is running 11i

Thanks
Anil
Quote
0 #15 jemar 2007-04-07 00:00
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_HTML/test_fwktutorial.jsp


500 Server Error
The following error occurred: [code=CANT_CONN ECT] Could not connect because of networking problems. Contact your system administrator.
Quote
0 #16 sreenivas 2007-04-12 00:00
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-workspa ce-app: No JDBC URL specified for jdbc/Connection 2CoreDS
Quote
0 #17 JM 2007-04-22 00:00
Hi Anil,
http://host:port/OA_HTML/OAInfo.jsp gives info 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
Quote
0 #18 Anil Passi 2007-04-25 00:00
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
Quote
0 #19 Ash 2007-05-04 00:00
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,
As h
Quote
0 #20 Omkark 2007-07-04 07:30
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
Quote
0 #21 Anil Passi 2007-07-04 13:25
Hi Omkar

Please see the comments section of http://www.google.com/search?q=site:apps2fusion.com+install-oa-framework-jdeveloper-rup4-from-scratch

I have listed the patches there

Thanks
A nil
Quote
0 #22 BDcunha 2007-07-10 23:05
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,
BDCu nha
Quote
0 #23 APassi 2007-07-11 03:27
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
Quote
0 #24 umesh 2007-07-12 06:29
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...

Fol lowing 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>preferenc e > 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.j tf.cache.CacheL oaderNotFoundEx ception

As a work around mentioned for this issue i have removed the following from the Virtual machines java option
-DFND_JD BC_STMT_CACHE_S IZE=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:\ OAFramework\RUP 5\jdevbin\jdki n\javaw.exe -hotspot -classpath C:\OAFramework\ RUP5\jdevbin\j2 ee\home\oc4j.ja r;C:\OAFramewor k\RUP5\jdevbin\ jdev\lib\jdev-o c4j.jar -Xbootclasspath /p:C:\OAFramewo rk\RUP5\jdevbin \jdev\appslibrt \ojdbc14.jar;C: \OAFramework\RU P5\jdevbin\jdev \appslibrt
ls_c harset12.zip -DRUN_FROM_JDEV =true -mx512m -Dhttp.proxyHos t=www-proxy.us. oracle.com -Dhttp.proxyPor t=80 -Dhttp.nonProxy Hosts=localhost -Xverify:none -Doracle.j2ee.d ont.use.memory. archive=true -Doracle.j2ee.h ttp.socket.time out=500 com.evermind.se rver.OC4JServer -config C:\OAFramework\ RUP5\jdevbin\jd ev\system9.0.3. 5.1453\oc4j-con fig\server.xml
[waiting for the server to complete its initialization. ..]

Ready message received from Oc4jNotifier.

Embedded OC4J startup time: 2390 ms.

Auto-deplo ying OA Framework web application deployment descriptor (New server version detected)...

O racle9iAS (9.0.3.1.0) Containers for J2EE initialized

TI ME: runregion: initialization [0 ms]

Tutalii: C:\OAFramework\ RUP5\jdevbin\jd ev\appslibrt\ia sjoc.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
Quote
0 #25 APassi 2007-07-12 07:12
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/oracl e/apps/fnd underneath myclasses from the server

Thanks
Anil Passi
Quote
0 #26 Satyabrat 2007-08-16 17:20
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/t utorial which depicts steps for writing simple programs like "Hello World" and so on...
And also the procedure for installation of Jdeveloper.

Ga lore of best wishes...
Thank s
Satya :)
Quote
0 #27 Tony 2007-08-19 19:46
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)

Than ks
Tony
Quote
0 #28 Tony 2007-08-21 19:23
Hi Anil,

What i am trying to ask is that whether a local database is enough to test some basic OAF screens

Thanks
Tony
Quote
0 #29 Shilpi 2007-09-25 12:13
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?
Quote
0 #30 Tony 2007-09-26 13:02
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

B ut 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_KE Y

FWK_TBX_TUTO RIAL

My Application is 11.5.9

pls comment on this
Quote
0 #31 Suresh Mutyala 2007-10-21 07:24
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.
Quote
0 #32 BV 2007-10-24 05:54
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.

Than ks
BV
Quote
0 #33 Kmurali 2008-01-04 05:06
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.xx x' instead of 'oracle.apps.ak .xxx'. Did that influence?

Her e were the erros,
Exceptio n Details.

oracle.apps.fnd .framework.OAEx ception: 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.webu i.OAPageErrorHa ndler.prepareEx ception(OAPageE rrorHandler.jav a:1223)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:1960 )
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:497)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:418)
at _OA._jspService (OA.jsp:40)
at com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:56)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 317)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:465)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:379)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:727 )
at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe questDispatcher .java:306)
at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.java:767)
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:259 )
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:106 )
at EDU.oswego.cs.d l.util.concurre nt.PooledExecut or$Worker.run(P ooledExecutor.j ava:803)
at java.lang.Threa d.run(Thread.ja va:534)
## Detail 0 ##
oracle.apps.fnd .framework.OAEx ception: 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.webu i.OAWebBeanFact oryImpl.getAppI d(OAWebBeanFact oryImpl.java:55 26)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:958)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:497)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:418)
at _OA._jspService (OA.jsp:40)
at com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:56)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 317)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:465)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:379)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:727 )
at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe questDispatcher .java:306)
at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.java:767)
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:259 )
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:106 )
at EDU.oswego.cs.d l.util.concurre nt.PooledExecut or$Worker.run(P ooledExecutor.j ava:803)
at java.lang.Thread.run(Thread.java:534)
oracle.apps.fnd .framework.OAEx ception: 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.webu i.OAWebBeanFact oryImpl.getAppI d(OAWebBeanFact oryImpl.java:55 26)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:958)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:497)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:418)
at _OA._jspService (OA.jsp:40)
at com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:56)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 317)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:465)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:379)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853)
at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:727 )
at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe questDispatcher .java:306)
at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.java:767)
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:259 )
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:106 )
at EDU.oswego.cs.d l.util.concurre nt.PooledExecut or$Worker.run(P ooledExecutor.j ava:803)
at java.lang.Threa d.run(Thread.ja va:534)


Thank s and Regards
Sinolee
Quote
0 #34 kvgshv 2008-01-07 03:04
Anil,

How can I connect to an Oracle database in RAC environment in JDeveloper. Please help.


Thank you,
Harsha Kona
Quote
0 #35 not able to start jdeveloper 2008-01-08 09:51
Hi Anil,

i downloaded the pathc 4573517 extracted the zip files.
It created three folders
jdevbin
jdevdo c
jdevhome

Can you please let me knwo what next is to be done to run the Jdeveloper.

Re gards
Deepak
Quote
0 #36 Sanket 2008-01-09 04:30
Hi Deepak,
You have to navigate to jdevbin\jdevin and in there you need to execute "jdevw.exe"

Ho pe that solves your query.

Regards ,
-Sanket.
Quote
0 #37 Sanket 2008-01-09 04:33
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"

Ho pe that solves your query.

Regards ,
-Sanket.
Quote
0 #38 Aparna 2008-01-14 05:22
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
Quote
0 #39 Priyanka Dhiman 2008-01-17 16:11
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.
Quote
0 #40 Pramod 2008-02-09 21:17
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?

Pleas e let me know

Thank you in advance
Pramod
Quote
0 #41 Prasant 2008-02-13 18:16
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 .
Quote
0 #42 Satish Mavuri 2008-03-21 15:36
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.
MD S 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_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font: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

Th anks
Pramod Bellamkonda ()
Quote
0 #43 Satish Mavuri 2008-03-21 15:38
http:// /OA_HTML/OAInfo .jsp
Quote
0 #44 Satish Mavuri 2008-03-21 15:40
please type in your HOST name between http and OA_HTML
Quote
0 #45 Anil Passi 2008-03-21 15:43
Thanks Pramod
Quote
0 #46 Rama 2008-10-25 10:39
This tutorial is a good start for learning Oracle Apps. Can any one send me details of MVC architecture.
Quote
0 #47 Pc rao 2008-10-26 11:31
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.

Ple ase provide me the information for the above questions....

Best regards,
PC rao
Quote
0 #48 A.Malar Selvam 2008-12-17 03:39
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.

SalesHeadersImp l sheader = getSalesHeaders ();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();

sheader.setProp erty("SaleOrder HeaderId",getOA DBTransaction() .getSequenceVal ue("XXPOS_SALE_ HEADERS_S"));
sheader.setProp erty("SaleOrder Number",getOADB Transaction().g etSequenceValue ("XXPOS_SALE_OR DER_NUMBER_S")) ;
lvo.setProperty ("SaleOrderHead erId",sheader.g etProperty("Sal eOrderHeaderId" ));
pvo.setProperty ("SaleOrderHead erId",sheader.g etProperty("Sal eOrderHeaderId" ));
getDBTransactio n().commit();


Kindly guide me how to do that.

Regards.

Malar.
Quote
0 #49 Anil Passi 2008-12-17 04:01
Hi You need to getCurrentRow
and then call setAttribute

F or example
getCond itionsVO1().get CurrentRow().se tAttribute("ren derParameter", boolean1);

or
defaultapprover svoimpl.getCurr entRow().setAtt ribute("NewOrOl d", "OLD");

Thanks
Anil
Quote
0 #50 A.Malar Selvam 2008-12-17 04:31
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) SalesHeadersImp l sheader = getSalesHeaders ();
LinesVOImpl lvo = getLinesVO();
PaymentVOImpl pvo = getPaymentVO();
sheader.getCurr entRow().setAtt ribute("SaleOrd erHeaderId",get OADBTransaction ().getSequenceV alue("XXPOS_SAL E_HEADERS_S"));
sheader.getCurr entRow().setAtt ribute("SaleOrd erNumber",getOA DBTransaction() .getSequenceVal ue("XXPOS_SALE_ ORDER_NUMBER_S" ));
lvo.getCurrentR ow().setAttribu te("SaleOrderHe aderId1",sheade r.getCurrentRow ().getAttribute ("SaleOrderHead erId"));
pvo.getCurrentR ow().setAttribu te("SaleOrderHe aderId2",sheade r.getCurrentRow ().getAttribute ("SaleOrderHead erId"));
getDBTransactio n().commit();
-------------- --------------- --------


getSalesHeaders ().getCurrentRo w().setAttribut e("SaleOrderHea derId",getOADBT ransaction().ge tSequenceValue( "XXPOS_SALE_HEA DERS_S"));
getSalesHeaders ().getCurrentRo w().setAttribut e("SaleOrderNum ber",getOADBTra nsaction().getS equenceValue("X XPOS_SALE_ORDER _NUMBER_S"));
getLinesVO().ge tCurrentRow().s etAttribute("Sa leOrderHeaderId 1",getSalesHead ers().getCurren tRow().getAttri bute("SaleOrder HeaderId"));
getPaymentVO(). getCurrentRow() .setAttribute(" SaleOrderHeader Id2",getSalesHe aders().getCurr entRow().getAtt ribute("SaleOrd erHeaderId"));
getDBTransactio n().commit();
-------------- --------------- --------------- --------------- -

Please guide me.

Regards.

Malar.
Quote
0 #51 Anil- 2008-12-17 06:23
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.getCurrentRo w() != 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
An il
Quote
0 #52 A.Malar Selvam 2008-12-17 06:59
Dear Anil,

The Error coming in the following Lines.

sheader .getCurrentRow( ).setAttribute( "SaleOrderHeade rId",getOADBTra nsaction().getS equenceValue("X XPOS_SALE_HEADE RS_S"));
sheader.getCur rentRow().setAt tribute("SaleOr derNumber",getO ADBTransaction( ).getSequenceVa lue("XXPOS_SALE _ORDER_NUMBER_S "));
lvo.getCurrent Row().setAttrib ute("SaleOrderH eaderId1",shead er.getCurrentRo w().getAttribut e("SaleOrderHea derId"));
pvo.getCurrent Row().setAttrib ute("SaleOrderH eaderId2",shead er.getCurrentRo w().getAttribut e("SaleOrderHea derId"));

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.prin tln("Row Count : "+sheader.getRo wCount());

It is raising: JBO-25036: An invalid object operation was invoked on type View Object with name SalesHeadersImp l_4

Please guide me.

Regards.

Malar.
Quote
0 #53 PrathapReddy K 2008-12-30 03:08
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.

Regar ds--
PrathapRed dy.
Quote
0 #54 Anil Passi-- 2008-12-30 04:45
You can call fnd_request.sub mit_request from Application Module via JDBC Callable Statement.

To show the report in real-time in browser, see this link apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework
Quote
0 #55 Haritha 2009-04-29 02:36
Hi anil,

How is this "programmatic query" attribute of the messagelovinput item used??
Quote
0 #56 udit.krjain 2009-07-08 01:39
i am getting a Null Pointer Exception in my CreateEmployeeC O. 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 processFormRequ est() of CO=====

public void processFormRequ est(OAPageConte xt pageContext, OAWebBean webBean)
{
supe r.processFormRe quest(pageConte xt, webBean);

OAAp plicationModule am = pageContext.get ApplicationModu le(webBean);

i f (pageContext.ge tParameter("App ly")!=null) {
OAViewObject vo = (OAViewObject)a m.findViewObjec t("EmpTryVO1");
String empName = (String)vo.getC urrentRow().get Attribute("Firs tName");
Number empNumber = (Number)vo.getC urrentRow().get Attribute("Empl oyeeId");
Strin g empNum = String.valueOf( empNumber.intVa lue());
am.invo keMethod("apply ");
MessageToke n[] tokens = { new MessageToken("E MP_NAME", empName),
new MessageToken("E MP_NUMBER", empNum) };
OAException confirmMessage = new OAException("AK ", "FWK_TBX_T_EMP_ CREATE_CONFIRM" , tokens,
OAExcep tion.CONFIRMATI ON, null);
pageCont ext.putDialogMe ssage(confirmMe ssage);
pageCon text.forwardImm ediately("OA.js p?page=/oracle/ apps/ak/Emptry/ webui/EmpTrySea rchPG",
null,
O AWebBeanConstan ts.KEEP_MENU_CO NTEXT,
null,
nu ll,
true, // retain AM
OAWebBeanCon stants.ADD_BREA D_CRUMB_NO);

}
}

Bold and Italic Line above is creating a NullPointerExce ption in error report.

Thanks in Advance,
Udit
Quote
0 #57 Anil- 2009-07-08 01:42
Is EmpTryVO1 attached to Application Module?
Quote
0 #58 Yogasri 2009-09-27 23:55
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 SearchResultExt nVO 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 : AssemblyItemRev ision and the View Instance as : SearchResultExt nVO (this is the new extension i created). The error message says :
oracle.apps.f nd.OAFramework. OAException: oracle.jbo.NoDe fException:JBO- 25002: Definition AssemblyItemRev ision 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....pleas e help me, I appreciate your help , thanks

Yogasri
Quote
0 #59 trks 2009-10-20 03:50
Hi

I encountered the following error when i moved code on to server. it was working fine in jdeveloper.,

t he code containls 1) xml page; packege structure Customfile\orac le\apps nd rame work ile\webui\ File
2) controller ; packege structure Customfile\orac le\apps nd rame work ile\webui\ FileCO
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.print document also

while accessing the page from apps instance(server ) it is giving this error


oracle. apps.fnd.framew ork.OAException : Application: FND, Message Name: FND_GENERIC_MES SAGE. Tokens: MESSAGE = java.lang.NullP ointerException ;
at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:891 )
at oracle.apps.fnd .framework.webu i.OAPageErrorHa ndler.prepareEx ception(OAPageE rrorHandler.jav a:1145)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:1969 )
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:502)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(OAPag eBean.java:423)
at _oa__html._OA._ jspService(_OA. java:86)
at oracle.jsp.runt ime.HttpJsp.ser vice(HttpJsp.ja va)
at oracle.jsp.app. JspApplication. dispatchRequest (JspApplication .java)
at oracle.jsp.JspS ervlet.doDispat ch(JspServlet.j ava)
at oracle.jsp.JspS ervlet.internal Service(JspServ let.java)
at oracle.jsp.JspS ervlet.service( JspServlet.java )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:588)
at oracle.jsp.prov ider.Jsp20Reque stDispatcher.fo rward(Jsp20Requ estDispatcher.j ava)
at oracle.jsp.runt ime.OraclePageC ontext.forward( OraclePageConte xt.java)
at _oa__html._RF._ jspService(_RF. java:100)
at oracle.jsp.runt ime.HttpJsp.ser vice(HttpJsp.ja va)
at oracle.jsp.app. JspApplication. dispatchRequest (JspApplication .java)
at oracle.jsp.JspS ervlet.doDispat ch(JspServlet.j ava)
at oracle.jsp.JspS ervlet.internal Service(JspServ let.java)
at oracle.jsp.JspS ervlet.service( JspServlet.java )
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:588)
at org.apache.jser v.JServConnecti on.processReque st(JServConnect ion.java:456)
a t org.apache.jser v.JServConnecti on.run(JServCon nection.java:29 4)
at java.lang.Threa d.run(Thread.ja va:571)
## Detail 0 ##
java.lang.Nu llPointerExcept ion
at oracle.apps.fnd .framework.webu i.JRAD2AKMapper .getRootMElemen t(JRAD2AKMapper .java:513)
at oracle.apps.fnd .framework.webu i.OAWebBeanFact oryImpl.getWebB eanTypeDataFrom JRAD(OAWebBeanF actoryImpl.java :3719)
at oracle.apps.fnd .framework.webu i.OAWebBeanFact oryImpl.getRoot ApplicationModu leClass(OAWebBe anFactoryImpl.j ava:3452)

Rega rds

TRKS
Quote
0 #60 adi 2009-11-19 03:07
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
Quote
0 #61 prj 2009-11-20 12:57
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. ..
Quote
0 #62 Naresh Kamra 2010-08-10 02:13
Hi Anil Passi,

I am getting the following exception while running pages from my jdeveloper. i am using dbc file for connect to remote database. Earlier i was able to run pages. but now i am not able to run even Helloworld page. Kindly help me. Waiting for ur reply. Thanks in advance.

Excep tion details:

oracl e.apps.fnd.fram ework.OAExcepti on: Application: FND, Message Name: FND_GENERIC_MES SAGE. Tokens: MESSAGE = oracle.apps.jtf .cache.CacheLoa derNotFoundExce ption; at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:891 ) at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:865 ) at _OAErrorPage._j spService(OAErr orPage.jsp:34) at com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:56) at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 317) at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:465) at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:379) at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853) at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:727 ) at com.evermind.se rver.http.Servl etRequestDispat cher.include(Se rvletRequestDis patcher.java:11 9) at com.evermind.se rver.http.Everm indPageContext. handlePageThrow able(EvermindPa geContext.java: 547) at com.evermind.se rver.http.Everm indPageContext. handlePageExcep tion(EvermindPa geContext.java: 518) at _runregion._jsp Service(runregi on.jsp:143) at com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:56) at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 317) at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:465) at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:379) at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:853) at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:727 ) at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe questDispatcher .java:306) at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.java:767) at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:259 ) at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:106 ) at EDU.oswego.cs.d l.util.concurre nt.PooledExecut or$Worker.run(P ooledExecutor.j ava:797) at java.lang.Threa d.run(Thread.ja va:534) ## Detail 0 ## oracle.apps.jtf .cache.CacheLoa derNotFoundExce ption at oracle.apps.jtf .cache.CacheMan ager.getInterna l(CacheManager. java:3236) at oracle.apps.jtf .cache.CacheMan ager.get(CacheM anager.java:320 3) at oracle.apps.fnd .cache.AppsCach e.get(AppsCache .java:248) at oracle.apps.fnd .profiles.Profi les.getProfileO ption(Profiles. java:1293) at oracle.apps.fnd .profiles.Profi les.getProfile& #40;Profiles.ja va:384) at oracle.apps.fnd .profiles.Exten dedProfileStore .getSpecificPro fileFromDB(Exte ndedProfileStor e.java:210) at
Quote
0 #63 Nithya Saravanan 2011-10-11 10:22
Hi A.Malar Selvam,

I'm facing the same issue. Can you please share if you have found the fix?

Thanks,
N ithya
Quote
0 #64 Christian Arizala 2012-07-04 01:05
Hi Anil,

I want to ask if you know the code that if we have many page then we enter a certain instance and then if we click the cancel button we want to stay on the page. Because our problem is the page is going back to page 1 we only want to stay on the page where we enter an instance like if we enter an instance in page 4 and we click cancel the page will only stay on page 4. Please help. Thanks so much.
Quote

Add comment


Security code
Refresh

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Jun 2021  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
   1  2  3  4  5  6
  7  8  910111213
14151617181920
21222324252627
282930    

Enquire For Training

Related Items

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner