In this article, we will again start from scratch on how to get your environment setup for OA Framework development, after you have downloaded jDeveloper patch from Metalink.
If you are on RUP4 of 11.5.10, then download patch 5455514 from Metalink on your PC, and lets say the location is D:\software\fwkrup4
Right click the zip file and select Extract to here
On My Computers, right click, and then click on Properties
Navigate to Advanced tab, and click button Environment Variables
As below, create a new Variable Name named JDEV_USER_HOME and assign it value “D:\software\fwkrup4\jdevhome\jdev” [without double quotes]
On Unix box, navigate to $FND_TOP/secure and FTP the dbc file in ascii mode to your PC location D:\software\fwkrup4\jdevhome\jdev\dbc_files\secure
In fact
Next, in order to start jDeveloper, navigate to D:\software\fwkrup4\jdevbin\jdev\bin on your PC and click on jdev.exe
This will run your jDeveloper executable as shown below.
Next, click on Database/connections, and right click to create a new Database Connection
Create a connection to apps schema
and then test the connection.
In the Tools menu, select preferences, “Embedded OC4J”, try to use "Default Local IP Address" option.
Now, create a new Workspace[by right clicking on Workspace], and then open Tutorial.jpr from directory D:\software\fwkrup4\jdevhome\jdev\myprojects
Doubleclick on Tutorial.jpr and in Runtime Connection, select your dbc and optionally change to your a Username and password. Ensure that the user enter in UserName has access to responsibility specified in Responsibility Key
Rebuild Tutorial.jpr
Now, run the Tutorial which is pre-delivered by Oracle itself. This can be done by right clicking on the HomePG.xml and select Run
You should be able to run the application shipped by Oracle in below manner
If you wish to see the BC4J objects like View Objects etc a page is referencing, then right-click that page in specific MDS Page and select “Show OA References”
When clicked on Show OA References, you will be able to see the BC4J objects that were used to build that page
Apps2Fusion Articles 
Comments
and
OA Framework Version 11.5.10.2CU.
Shall i use the same patch or different,
please advice
On CU2, please follow the instructions in
http://www.google.com/search?q=site:apps2fusion.com+oa-framework
Thanks
Anil Passi
Bas e 11.5.10
Patch 4045639 JDeveloper 9i
11.5.10 ATG CU1
Patch 4141787 JDeveloper 9i
11.5.10 ATG CU2
Patch 4573517 JDeveloper 9i
11.5.10 ATG CU3
Patch 4725670 JDeveloper 9i
11.5.10 ATG CU4
Patch 5455514 JDeveloper 9i
R12
Patch 5856648 jDeveloper 10g
Thanks ,
Anil Passi
O A 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
iam working on OAFramework on HRMS module.
recent ly my organization has given CRM to me.
but CRM pages are not developed ON OAFramework.
i t is developed on JTT/JTF(JSP Customizations) .
Do you know how to customize and personalize
CR M Pages.
Regar ds
Ram
If so, your extensions will happen in AK.
This is my thinking.
If you can tell me the name of a form function, then I can dig into that to find the right way forward.
Tha nks
Anil
Can you help me with this?
java.io.FileN otFoundExceptio n: D:OAFjdevhomejd evsystem9.0.3.5 .1312oadbc_file ssecureosidt2_p rod.dbc
The .DBC file is actually present in the location. Do you have any idea what could be the possible error?
Thank s,
Sush
Its working now. There were some extra characters in the dbc file which went unnoticed before.
I corrected it and its working fine now.
Thanks again for your response.
Thank you,
Sush
Thats great, thanks for sharing the info.
Cheers
Anil
The Issue.
The issue is that through D2K forms we are able to view the archived data by changing the data group to Arch_data group. In release 12 Oracle has come up with JSP forms which have replaced the oracle forms. From JSP pages we are only able to view the apps data and not the archived one even though we are accessing the forms through the Archive responsibility (this responsibility is connected to a different schema).
I wanted to know how the JSP form is connecting to the database in Oracle Apps. Does it use the Datagroup which is linked to the Responsibility to determine which schema needs to be connected? Or is there a different way for JSP pages.
Your application should always connect to apps.
If need be, please create synonyms in APPS schema with relevant grants given to APSP schema
Thank s
Anil
I tried to install JDeveloper and it was installed successfully. When I tried ro rebuild Tutorial.jpr after updating the runtime connection settings, warnings are displayed in the compiler tab and when i run HomePG.xml, I get an error "You have encountered an unexpected error. Please contact the System Administrator for assistance.". Please can you help me with this.
Thanks,
Brunda
There can be various reasons for this kind of Error.
Is there a link that says click here for further info?
Basically I need to see the full error stack.
Given that your project has rebuilt but can't be run, it points to a runtime issue
Please ensure that the username/passwo rd/responsibili ty key/responsibil ity application short name combination is a valid one?
Thanks,
A nil Passi
Thanks,
Brund a
Your article is very useful to Oracle APPS consultants.
G reat Work.
Regards
Rajkumar
I followed the all the instructions given by you. If i try ro run the homepg.xml , it says "Unexpected URL parameters have been detected and will be ignored."
Any reasons?
Regar d
Rajkumar
I am working on 11.5.9 version. I need to work on OA framwork. Please let me know the patch and installlation steps. I have downloaded the patch for 11.5.10.2 but it is not working with 11.5.9.
Please suggest
Manish
I am new to JDev but I am here for 5 years in Oracle Application.
Fi rst Congratulation for your wonderful hard work, right now i have 11.5.10.2 oracle apps and per different notes i need JDev9.0.3 Is this right? and if so from where i can download it as JDev9 looks like not available anywhere.
Plese help
Amit
Except ion Details.
oracle .apps.fnd.frame work.OAExceptio n: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = mds;
at oracle.apps.fnd .framework.webu i.OAPageErrorHa ndler.prepareEx ception(Unknown
Source)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at _OA._jspService (_OA.java:72)
a t com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:59)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 462)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:597)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:521)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atche
r.java:71 3)
at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe quest
Dispatche r.java:370)
at com.evermind.se rver.http.HttpR equestHandler.d oProcessRequest (HttpRequestHan dler.
java:871)
at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.ja
va:453)
a t com.evermind.se rver.http.HttpR equestHandler.s erveOneRequest( HttpRequestHand ler.j
ava:221)
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:122 )
at
com.evermi nd.server.http. HttpRequestHand ler.run(HttpReq uestHandler.jav a:111)
at
oracl e.oc4j.network. ServerSocketRea dHandler$SafeRu nnable.run(Serv erSocketReadHan
dler.java:260)
at com.evermind.ut il.ReleasableRe sourcePooledExe cutor$MyWorker. run(ReleasableR esour
cePooledE xecutor.java:30 3)
at java.lang.Threa d.run(Thread.ja va:595)
## Detail 0 ##
oracle.apps. fnd.framework.O AException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = mds;
at oracle.apps.fnd .framework.webu i.OAWebBeanFact oryImpl.getAppI d(Unknown
Sourc e)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at oracle.apps.fnd .framework.webu i.OAPageBean.pr eparePage(Unkno wn Source)
at _OA._jspService (_OA.java:72)
a t com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:59)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 462)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:597)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:521)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at oracle.apps.fnd .common.WebApps Context.(WebApp sContext.java:1 014)
at oracle.apps.jtf .cache.Architec tureWrapper.cre ateAppsContextW ithDBCFile(Arch itectureWrapper .java:143)
at oracle.apps.jtf .cache.Architec tureWrapper.cre ateDefaultAppsC ontext(Architec tureWrapper.jav a:107)
at oracle.apps.jtf .cache.Architec tureWrapper.cre ateAppsContext( ArchitectureWra pper.java:96)
a t oracle.apps.jtf .cache.appsimpl .AppsCacheLogge r.(AppsCacheLog ger.java:47)
at oracle.apps.jtf .cache.appsimpl .AppsCacheEnvir onment.getCache Logger(AppsCach eEnvironment.ja va:67)
at oracle.apps.jtf .cache.CacheMan ager.initCache( CacheManager.ja va:727)
at oracle.apps.jtf .cache.CacheMan ager.(CacheMana ger.java:390)
a t oracle.apps.fnd .cache.Cache.se tCacheFullName( Cache.java:228)
at oracle.apps.fnd .cache.Cache.in itCache(Cache.j ava:114)
at oracle.apps.fnd .cache.Cache.(C ache.java:89)
a t oracle.apps.fnd .cache.AppsCach e.(AppsCache.ja va:86)
at oracle.apps.fnd .cache.AolCache s.getCache(AolC aches.java:165)
at oracle.apps.fnd .profiles.Profi les.(Profiles.j ava:247)
at oracle.apps.fnd .profiles.Exten dedProfileStore .init(ExtendedP rofileStore.jav a:455)
at oracle.apps.fnd .profiles.Exten dedProfileStore .(ExtendedProfi leStore.java:11 9)
at sun.reflect.Nat iveConstructorA ccessorImpl.new Instance0(Nativ e Method)
at sun.reflect.Nat iveConstructorA ccessorImpl.new Instance(Native ConstructorAcce ssorImpl.java:3 9)
at sun.reflect.Del egatingConstruc torAccessorImpl .newInstance(De legatingConstru ctorAccessorImp l.java:27)
at java.lang.refle ct.Constructor. newInstance(Con structor.java:4 94)
at oracle.apps.fnd .common.AppsCon text.instantiat eProfileStore(A ppsContext.java :4234)
at oracle.apps.fnd .common.AppsCon text.makeProfil eStore(AppsCont ext.java:1114)
at oracle.apps.fnd .common.Context .setProfileStor e(Context.java: 946)
at oracle.apps.fnd .common.Context .setProfileStor e(Context.java: 928)
at oracle.apps.fnd .common.AppsCon text.initialize Context(AppsCon text.java:917)
at oracle.apps.fnd .common.AppsCon text.initialize Context(AppsCon text.java:888)
at oracle.apps.fnd .common.AppsCon text.(AppsConte xt.java:748)
at oracle.apps.fnd .common.WebApps Context.(WebApp sContext.java:1 014)
at oracle.apps.fnd .framework.serv er.OAUtility.ge tWebAppsContext (Unknown Source)
at oracle.apps.fnd .framework.Crea teIcxSession.ge tEncryptedSessI d(Unknown Source)
at oracle.apps.fnd .framework.Crea teIcxSession.cr eateSession(Unk nown Source)
at _test__fwktutor ial._jspService (_test__fwktuto rial.java:74)
a t com.orionserver .http.OrionHttp JspPage.service (OrionHttpJspPa ge.java:59)
at oracle.jsp.runt imev2.JspPageTa ble.service(Jsp PageTable.java: 462)
at oracle.jsp.runt imev2.JspServle t.internalServi ce(JspServlet.j ava:594)
at oracle.jsp.runt imev2.JspServle t.service(JspSe rvlet.java:518)
at javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
at com.evermind.se rver.http.Servl etRequestDispat cher.invoke(Ser vletRequestDisp atcher.java:713 )
at com.evermind.se rver.http.Servl etRequestDispat cher.forwardInt ernal(ServletRe questDispatcher .java:370)
at com.evermind.se rver.http.HttpR equestHandler.d oProcessRequest (HttpRequestHan dler.java:871)
at com.evermind.se rver.http.HttpR equestHandler.p rocessRequest(H ttpRequestHandl er.java:453)
at com.evermind.se rver.http.HttpR equestHandler.s erveOneRequest( HttpRequestHand ler.java:221)
a t com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:122 )
at com.evermind.se rver.http.HttpR equestHandler.r un(HttpRequestH andler.java:111 )
at oracle.oc4j.net work.ServerSock etReadHandler$S afeRunnable.run (ServerSocketRe adHandler.java: 260)
at oracle.oc4j.net work.ServerSock etAcceptHandler .procClientSock et(ServerSocket AcceptHandler.j ava:239)
at oracle.oc4j.net work.ServerSock etAcceptHandler .access$700(Ser verSocketAccept Handler.java:34 )
at oracle.oc4j.net work.ServerSock etAcceptHandler $AcceptHandlerH orse.run(Server SocketAcceptHan dler.java:880)
at com.evermind.ut il.ReleasableRe sourcePooledExe cutor$MyWorker. run(ReleasableR esourcePooledEx ecutor.java:298 )
at java.lang.Threa d.run(Thread.ja va:595)
Caused by: java.lang.NullP ointerException : null Connection
at oracle.apps.fnd .cache.GenericC acheLoader.load (GenericCacheLo ader.java:167)
at oracle.apps.fnd .profiles.Profi les.getProfileO ption(Profiles. java:1475)
... 64 more
Thanks
Kir ubakaran.R
I suspect you have either got a wrong DBC file, or your DB Connection from jDeveloper is incorrect.
I have started to study the OAFramevork from scrach.Right now I am stay at Pune,India.If anybody knows OAFramevork regarding Classes/Courses Or Other sourses at Pune, please give me information about that.
Thanks to all
Dattaprasad
Great thanks Anil.
While runing HomePG.xml file i am getting following error.
{
Validation error in document "HomePG":
Inval id value "/oracle/apps/f nd/wf/worklist/ webui/AdvancWor klistRG" for property "Extends" on component "/oracle/apps/f nd/framework/to olbox/tutorial/ webui/HomePG.No tifications". Component "/oracle/apps/f nd/wf/worklist/ webui/AdvancWor klistRG" cannot be referenced from "/oracle/apps/f nd/framework/to olbox/tutorial/ webui/HomePG.No tifications" because it violates scope restrictions.
}
Could anyone please shed light that Why i am getting this error and how to resolve this
Thanks
Faizan
Great thanks Anil.
While runing HomePG.xml file i am getting following error.
{
Validation error in document "HomePG":
Inval id value "/oracle/apps/f nd/wf/worklist/ webui/AdvancWor klistRG" for property "Extends" on component "/oracle/apps/f nd/framework/to olbox/tutorial/ webui/HomePG.No tifications". Component "/oracle/apps/f nd/wf/worklist/ webui/AdvancWor klistRG" cannot be referenced from "/oracle/apps/f nd/framework/to olbox/tutorial/ webui/HomePG.No tifications" because it violates scope restrictions.
}
Thanks
Faizan
i'm trying to install as per the instruction given by you but getting this error when i try to run home page
OAExcepti on: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = Io exception: The Network Adapter could not establish the connection;
at oracle.apps.fnd .framework.serv er.OAExceptionU tils.processAOL JErrorStack(OAE xceptionUtils.j ava:988)
at oracle.apps.fnd .framework.serv er.OAUtility.ge tWebAppsContext (OAUtility.java :353)
at oracle.apps.fnd .framework.Crea teIcxSession.ge tEncryptedSessI d(CreateIcxSess ion.java:144)
a t oracle.apps.fnd .framework.Crea teIcxSession.cr eateSession(Cre ateIcxSession.j ava:80)
at _runregion._jsp Service(runregi on.jsp:96)
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(
please guide me
I have a problem on how to make attachment using OA framework technology.
Do you have an Operation Instructions on that subject?
Appreciate if you could show me way.
Thanks
I have requirement to put some validations in Trade Planning page.
Navigation:
Or acle Trade Management User Responsibility à Trade Planning à Click on Create Tab
I have downloaded the jsp file 'ozfOfferCreatF rm.jsp' from $OA_HTML_TOP and did some modifications.
Now, do I need to rename this jsp?. If so, what steps do I need to follow to deploy on server.
As original jsp will be referred in different places, how to identify and change the references?
Please help me and send me any related documents if you have.
Regards,
Hem
I am getting this error when tried to run the Homepage html.Please help me to proceed further
Except ion Details.
oracle.apps.fnd .framework.OAEx ception: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = No suitable driver; (Could not lookup message because there is no database connection)
at oracle.apps.fnd .framework.OACo mmonUtils.proce ssAOLJErrorStac k(OACommonUtils .java:884)
at oracle.apps.fnd .framework.serv er.OAUtility.ge tWebAppsContext (OAUtility.java :347)
at oracle.apps.fnd .framework.Crea teIcxSession.ge tEncryptedSessI d(CreateIcxSess ion.java:144)
a t oracle.apps.fnd .framework.Crea teIcxSession.cr eateSession(Cre ateIcxSession.j ava:80)
at _test__fwktutor ial._jspService (test_fwktutori al.jsp:45)
at oracle.jsp.runt ime.HttpJsp.ser vice(HttpJsp.ja va:139)
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.fnd .framework.OAEx ception: Application: FND, Message Name: FND_GENERIC_MES SAGE. Tokens: MESSAGE = java.sql.SQLExc eption: No suitable driver; (Could not lookup message because there is no database connection)
at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:888 )
at oracle.apps.fnd .framework.OAEx ception.wrapper Exception(OAExc eption.java:862 )
at oracle.apps.fnd .framework.OACo mmonUtils.proce ssAOLJErrorStac k(OACommonUtils .java:876)
at oracle.apps.fnd .framework.serv er.OAUtility.ge tWebAppsContext (OAUtility.java :347)
at oracle.apps.fnd .framework.Crea teIcxSession.ge tEncryptedSessI d(CreateIcxSess ion.java:144)
a t oracle.apps.fnd .framework.Crea teIcxSession.cr eateSession(Cre ateIcxSession.j ava:80)
at _test__fwktutor ial._jspService (test_fwktutori al.jsp:45)
at oracle.jsp.runt ime.HttpJsp.ser vice(HttpJsp.ja va:139)
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 ##
java.sql.SQLExc eption: No suitable driver
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:532)
at java.sql.Driver Manager.getConn ection(DriverMa nager.java:140)
at oracle.apps.fnd .security.Conne ctionManager.db Connect(Connect ionManager.java :753)
at oracle.apps.fnd .security.Conne ctionManager.db Connect(Connect ionManager.java :704)
at oracle.apps.fnd .security.AppsC onnectionManage r.makeGwyuidCon n(AppsConnectio nManager.java:6 09)
at oracle.apps.fnd .security.AppsC onnectionManage r.getGwyuidConn (AppsConnection Manager.java:68 1)
at oracle.apps.fnd .security.AppsC onnectionManage r.makeGuestConn ection(AppsConn ectionManager.j ava:552)
at oracle.apps.fnd .security.DBCon nObj.(DBConnObj .java:206)
at sun.reflect.Nat iveConstructorA ccessorImpl.new Instance0(Nativ e Method)
at sun.reflect.Nat iveConstructorA ccessorImpl.new Instance(Native ConstructorAcce ssorImpl.java:3 9)
at sun.reflect.Del egatingConstruc torAccessorImpl .newInstance(De legatingConstru ctorAccessorImp l.java:27)
at java.lang.refle ct.Constructor. newInstance(Con structor.java:2 74)
at oracle.apps.fnd .common.Pool.cr eateObject(Pool .java:1187)
at oracle.apps.fnd .common.Pool.bo rrowObject(Pool
RSS feed for comments to this post