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.
Comments
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
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
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
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
Than ks
Than ks
.
.
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
.
.
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
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
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
You need to download the patch from the Metalink.
I assume you have access to Metalink.
Th anks,
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
Sorry to hear that. please let me have the patch number, I will check this for myself on Metalink.
Th anks,
Anil Passi
Thanks
Anil
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.
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
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
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
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
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
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
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
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
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
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
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 :)
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
What i am trying to ask is that whether a local database is enough to test some basic OAF screens
Thanks
Tony
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
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.
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
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
How can I connect to an Oracle database in RAC environment in JDeveloper. Please help.
Thank you,
Harsha Kona
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
You have to navigate to jdevbin\jdevin and in there you need to execute "jdevw.exe"
Ho pe that solves your query.
Regards ,
-Sanket.
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.
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
Which patch should i install to run JDeveloper with WindowsNT OS?
I have downloaded Patch# 4573517. But it only applies to Windows2000 and WindowsXP.
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
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 .
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 (Pramod.Oraclegmail.com)
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
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.
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
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.
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
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.
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.
To show the report in real-time in browser, see this link apps2fusion.com/at/ps/260-integrating-xml-publisher-and-oa-framework
How is this "programmatic query" attribute of the messagelovinput item used??
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
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
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\appsndrame workile\webui\ File
2) controller ; packege structure Customfile\orac le\appsndrame workile\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
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
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. ..
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
I'm facing the same issue. Can you please share if you have found the fix?
Thanks,
N ithya
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.
RSS feed for comments to this post