Apps To Fusion

.......Our Journey from Apps To Fusion

 
  • Increase font size
  • Default font size
  • Decrease font size



OA Framework R12 Extension Example

E-mail
User Rating: / 2
PoorBest 
An example of View Object Extension in conjunction with Controller class extension

This is a real life implementation example of OA Framework Extension on Release12.
In this extension, you will see how to

   1. Extend a View Object to add a new Column
   2. How to extend a controller class
   3. How to apply substitution of View Object
   4. How to export personalization and deploy the same

Given that this was a real life solution implemented for a client of mine, I am unable to make the business requirement a public knowledge. For the very same principles, I am not detailing the source code for the controller extension.


But yet this document will give you a good idea of how extension of BC4J, extension of Controller and Personalizations work in tandem. This document also gives you steps involved for development & deployment, with screenshots where applicable.

 

Click here to access the R12 OA Framework Extension Document 


 

 

 

Comments (12)add
...
written by sshanmug , October 30, 2007
Excellent work Anil.

Thanks and Regards,
Senthil
report abuse
vote down
vote up
Votes: +0
posting it here ??? --how?
written by ChitraG , October 30, 2007
Hello Anil-

I dont know how to post here...it keeps asking the new security image letters every time.. smilies/sad.gif

I need more info on
1. Oracle EBS architecture
2. OM - Processing constraints
( how its implemeted using APIs and how they are ported from instance to instance)
3. OM Module as a Functional Consultant (not as a O2C user)

Pls, lemme know if my questions are not clear.

thx,
chitra
(finally, firefox dint let me...but IE did show a message that the name i used has been already registered...so much for firefox, huh?)
report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , October 30, 2007
Hi Chitra

I always use firefox, but never saw this issue.
Perhaps you should register yourself. The captcha image is not presented to registered users.

Please elaborate your OM Requirements. A friend of mine has proposed to write up on Order Management.

Thanks,
Anil Passi
report abuse
vote down
vote up
Votes: +0
OM bible
written by ChitraG , October 30, 2007
oh, oops, i have juz registered ... (it let me post only once with the same user name.

My questions are basically similar to your "What happens when you login to Apps" article, except in OM module. In the view of functional consultant (not as a end-user), if you could throw some insights on the flow of processes invl**ed, it would be great.
I'm not asking for "What-to-do" steps as in how-to-book-order, how-to-pick-release; instead "What happens in apps, what tables get affected, which APIs gets called" ..that sort of things...To help me troubleshoot any problem scenarios.

Since I have limited knowledge on PL/SQL, sometimes it gets hard to understand the technical perspecive of things. But I am determined to give it a try.

Hope I'm not asking too much.

Thx agn-
chitra
report abuse
vote down
vote up
Votes: +0
...
written by ved , November 03, 2007
Hello Anil,
i very much appreciate ur effort for helping.
please tell how can download oracle workflow 2.6.2. this version is not available on otn.oracle.com.there is available oracle workflow 2.6.3. which is for the oracle database 10g, while i m using the oracle database 9i of oracle application 11.5.10.2 on windows XP.
thanks

report abuse
vote down
vote up
Votes: -1
oracle workflow 2.6.3
written by ved , November 03, 2007
Hello anil,
i appreciate ur effort for helping us. i want a favoure from u.i m new in this field.
i m using the oracle 9i database of oracle application 11.5.10.2 on windows XP.
where i get the oracle workflow 2.6.2 . this version is not available on
otn.oracle.com. there is available oracle workflow 2.6.3, which is not installing on oracle 9i database, workflow 2.6.3 need database 10g.
please help me, i am very much tense for this.
thanks

report abuse
vote down
vote up
Votes: +0
...
written by Anil Passi , November 03, 2007
Hi Ved,

Both the 9i Client and 10g Client contain the Workflow builder by default.

I think these can be downloaded from otn.

Good luck,
Anil Passi
report abuse
vote down
vote up
Votes: +0
r12 oa project
written by cayman , November 05, 2007
hi
Hi All,

The client decided to go for R12 in the middle of implementation. We downloaded jDev patch p6197418_R12_Generic. We could make test_fwktutorial.jsp work. Next we copied icx,ap,pa *.xml and *.class from Unix to desktop. Also exported required *PG.xml from mds.

Now we want to create a new project in jDeveloper. We did following

New -> Workspace configured for Oracle Application
Add a new OA Project
Specified the workspace name and project name.

The workspace and project is created but jDev adds all files under JDEV_USER_HOMEjdevmyprojects which includes all xml, jsp under fnd, icx, ap, pa subdirectories. Then offcourse we are not able to run *PG.xml (e.g. ShoppingHomePG.xml) due to some blank *VO.xml.

Is this the right way of creating project in jDev 10g? OR Should we create empty project and then add content to it? jDev 9i (EBS 11i), never added files by itself, we had to add files (server.xml) to project manually..

Any help will be great!


I am doing following

File -> New
Workspace configured for Oracle Application
Enter workspace name
Select default directory i.e. USER_JDEV_HOMEjdevmyprojects
Check "Add new OA project"
Enter project name and directory (same as workspace)
select DB connection and DBC file.

for me all files jsp and xml are getting added under my project. It includes EVERYTHING under fnd, ap, icx, pa (Its a LOT)

report abuse
vote down
vote up
Votes: +0
OA Framework customization Steps
written by SATYABRAT PADHY , November 05, 2007
Hi Anil,

Thanks a lot...
I have a couple of questions regarding OA Framework customization in R12.
1. Please let me know with the steps to be followed to copy files to/from which locations to go ahead with the customization.
2. For R12, which version of Jdev I should be using.

Great!!! If you can share some tutorial documents for the same.
Regards,
Satya

report abuse
vote down
vote up
Votes: +0
Error while running Pg.xml from Jdev
written by SP , January 09, 2008
Hi Anil,

I have downloaded the entire Oracle folder from $JAVA_TOP to myclasses.
Created package inside myproject. C:Jdev10gjdevhomejdevmyprojectsXXTJXoracleappsp erselfservice
Under this, I have common & newhire two folders.
I have put the PG.xml files from $PER_TOP/mds to below location.
C:Jdev10gjdevhomejdevmyprojectsXXTJXoracleappsp erselfservice
ewhirewebui

I created OAWorkspace and a project. Made Oracle Application RUNtime connection and business component connection. Added all Libraries.
Successfully built the Application(with few warnings though).

But while running the "CreatSrchNewHrPG.xml" in Jdev it errors out(edited the error). As pasted below. Please help. Thanks in Advance.
---------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.per.selfservice.common.server.CommonAM'.
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(Unknown Source)
dler.java:453)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:29smilies/cool.gif
at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
JBO-30003: The application pool (socaxs3er03.xglbsnet.comTJXEBDV11522oracle.apps.per.selfservice.common.server.CommonAM) failed to checkout an application module due to the following exception:
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: oracle.jbo.NoDefException, msg=JBO-25002: Definition oracle.apps.per.selfservice.common.server.CommonAM of type ApplicationModule not found
at oracle.jbo.common.ampool.ApplicationPoolImpl.doCheckout(ApplicationPoolImpl.java:2002)

at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:29smilies/cool.gif
at java.lang.Thread.run(Thread.java:595)

Logout

Copyright (c) 2006, Oracle. All rights reserved.


report abuse
vote down
vote up
Votes: +0
HellowWorld Tutorial - java.lang.ExceptionInInitializerError
written by Kalyan , July 28, 2008
Hi Anil,

I am currently working on R12 with OA Framework Version 12.0.3.
I am using Jdeveloper version p6509325_R12_GENERIC as per Metalink Note: 416708.1.

I get following Error message while running HellowWorld Tutorial from jdeveloper. I have checked Project Runtime settings..Everything looks good. Even If run any other tutorial (e.g. toolbox)... I get the same error.

Could you please help me out in resolving this issue ? Thx in Advance.

500 Internal Server Error
java.lang.ExceptionInInitializerErrorat oracle.apps.fnd.common.WebRequestUtil.validateContextPrivate(WebRequestUtil.java:439)at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:322)at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:225)at _OAErrorPage._jspService(_OAErrorPage.java:62)[/OAErrorPage.jsp]at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:51smilies/cool.gifat javax.servlet.http.HttpServlet.service(HttpServlet.java:856)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193)at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:19smilies/cool.gifat com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:847)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:813)at _runregion._jspService(_runregion.java:193)[/runregion.jsp]at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.3.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:51smilies/cool.gifat javax.servlet.http.HttpServlet.service(HttpServlet.java:856)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)at com.evermind[Oracle Containers for J2EE 10g (10.1.3.3.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:29smilies/cool.gifat java.lang.Thread.run(Thread.java:595)Caused by: java.lang.IllegalArgumentException: WebAppsContext.getJDBCConnection() == nullat oracle.apps.fnd.functionSecurity.FunctionSecurity.init(FunctionSecurity.java:1602)at oracle.apps.fnd.functionSecurity.FunctionSecurity.(FunctionSecurity.java:18smilies/cool.gifat oracle.apps.fnd.sso.SSOUtil.getLocalPwdChangeUrl(SSOUtil.java:709)at oracle.apps.fnd.sso.SSOUtil.getLocalPwdChangeUrl(SSOUtil.java:765)at oracle.apps.fnd.sso.SSOManager.(SSOManager.java:2209)... 37 more

report abuse
vote down
vote up
Votes: +0
Changes in VO Extension from 11i to R12
written by Michele , March 27, 2009
Hello Anil

After training on OAF 11i, I finally get to work on R12. I am using the base versionb of R12 on Vision and as a training excercise I am trying to add "approved date" to the iProcurement Self Service Page. Your article is very helpful but I have a question. In the section to extend the view Object you indicate to "create a Business Components package". In 11i , one right-clicks the project and this option appears on the menu. This is not the case in R12. How is this done in R12? In your article - you omit to give the steps on how you did this and I would really like to know how to get past this point.
report abuse
vote down
vote up
Votes: +0
Write comment
quote
bold
italicize
underline
strike
url
image
quote
quote
smile
wink
laugh
grin
angry
sad
shocked
cool
tongue
kiss
cry
smaller | bigger

security image
Write the displayed characters


busy
Last Updated ( Sunday, 28 October 2007 21:35 )  

Related Items

Search apps2fusion