Skip to content



Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color
Home arrow Home arrow OA Framework R12 Extension Example
This website has now moved to

OA Framework R12 Extension Example | Print |  E-mail
Written by Anil Passi   
Sunday, 28 October 2007
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 (10)add
written by sshanmug , October 30, 2007
Excellent work Anil.

Thanks and Regards,
posting it here ??? --how?
written by ChitraG , October 30, 2007
Hello Anil-

I dont know how to post 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.

(finally, firefox dint let me...but IE did show a message that the name i used has been already much for firefox, huh?)
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.

Anil Passi
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 invloved, 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-
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 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 on windows XP.

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 on windows XP.
where i get the oracle workflow 2.6.2 . this version is not available on 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.

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
r12 oa project
written by cayman , November 05, 2007
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)

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.

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

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)
at com.evermind.server.http.HttpRequestHandler.serveOneRequest(
at com.evermind.util.ReleasableResourcePooledExecutor$
## 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(

at com.evermind.util.ReleasableResourcePooledExecutor$


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

You must be logged in to a comment. Please register if you do not have an account yet.