Fusion Blog

EBS Blog


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: 4 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Inactive

In this tutorial, we will see how a record in a table can be modified using OA Framework screen.
The video tutorial will be followed by the instructions to deploy these set of Tutorials on Oracle EBS.

Following change will be done to the screen in previous tutorial


1. Add a Link for update to the search result.


This link will fire  an action named updatePerson.


Also, this link will pass a parameter named paramPersonId to the pageContext of Controller Class.


2. When this link is clicked, then processFormRequest(PFR) of the controller will be called in the main page.


3. From the PFR of CO, call another screen named managePersonPG, by retaining the AM.


Note:- this is the same screen that we called for insert/creation functionality in previous tutorial.


4. The navigation now moves to managePersonPG screen, and the Controller method processRequest of managePerson screen will now be called. Note:- Remember that processRequest is called as just prior to the page renders/displays in browser.


5. In processRequest of managePersonPG screen, we will initiate an executeQuery on the viewObject, after setting its where clause.


The result of this action is to make the record being updated to be queried automatically.


6. On managePerson screen, a button named apply changes will be available.


7. After modifying data, user will click apply now, hence invoking processFormRequest.


From processFormRequest, we will call a method in AM, that will commit the transaction.


8. We navigate back to the mainPage i.e. xxPersonMainPG


When a commit takes place, how does OA Framework know whether an insert or update must be done?


When the record being queried is changed by user, that will change the status of the record to dirty.


Hence when commit takes place, Framework will know an update  is required rather than an insert.


What are the steps in tutorial?


1. Create a link for update. In the mainPage's CO, inside PFR, handle the click of update Person.


Call managePerson page, passing it parameter named xxParamPersonId[of record being updated] and xxParamActionOnPerson[=updatePerson, from fireAction property]


2. Set a new controller for this new page


In PR(processRequest) of the managePersonCO, call an AM method to query the PersonId being updated.


Note:-in previous tutorial, we added a button, and program for PFR in new controller, so that commit can be initiated via AM. This commit button is retained as is for this tutorial


3. Redirect back to the original main page, once the commit has taken place


6. Test this




Click here to download the source code for Tutorial 1,2,3,4


The project can be deployed to Oracle EBS, by implementing instructions below.


Anil Passi


0 #1 Prashanth 2007-08-22 17:16
Hi Anil,

I am new to OA Framework.
Once you download the Source code of tutorial 1,2,3,4. how do i open it in Jdeveloper?
Lik e in Forms D2K, you can ftp any .fmb file and then open in Form Builder.
In the same way do we also have .jws file?

0 #2 Anil Passi 2007-08-22 17:53
Hi Prashanth

Simp ly place the files in your myprojects directory.
You can them import the server.xml to open BC4J.
Pages and conrollers can be opened by using File/Open

Than ks,
Anil Passi
0 #3 Richa Srivastav 2007-09-19 09:53
i am new to this area.

i have completed all these 4 step tutorial and completed this project. The project is running nicely in Jdeveloper. But when i transfer it to the Oracle apps it started problem. The first page(person details page) is running nicely and the delete function is working but when i go to the update or creation page after update or create and when i press commit it shows oracle.apps.fnd .framework.OAEx ception: No data found for region (gpt/oracle/app s/ak/gpperson/w ebui/gp2personM ainPG)

oracle.adf.mds .MetadataDefExc eption: Unable to find component with absolute reference = gpt/oracle/apps /ak/gpperson/we bui/gp2personMa inPG, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.

A lthough the updated data is entered in table but transition to the first page is not happening. I have imported the two xml file to MDS according to your deployment tutorial. I have also tried the import command with includeSubpacka ges option. please help me in this regard.
0 #4 Anil Passi 2007-09-19 11:20
Hi Sohail

Please use the jdr utils to check if your document is there in MDS repository

Use this link for jdr_utils www.google.com/search?q=site:apps2fusion.com+jdr-utils-2

Anil Passi
0 #5 Richa Srivastav 2007-09-20 05:44
i have already run the

jdr_utils.lis tdocuments('/gp t/oracle/apps/a k/gpperson', TRUE);
and found my two xml files there.

/gpt/or acle/apps/ak/gp person/webui/ma nagePersonPG
/g pt/oracle/apps/ ak/gpperson/web ui/gp2personMai nPG

But the saome problem exist. please help me any other solutions
0 #6 BHANUPRASAD 2007-09-25 06:48
hi anil,
I am new to discoverer plesae help me providing some material and working procedures regarding it.
0 #7 BHANUPRASAD 2007-09-25 07:03
hi anil,
where can i find the material regarding om module,APIS related to om.
please help me in this

0 #8 Swapnil Srivastava 2007-09-25 11:43
hi anil,

I am working on oracle apps 11i( .The project has lots of extensibility issues, for that we would be using Jdeveloper, for the same i have couple of queries:

1.The version of the jdeveloper which would best suit oracle apps 11i(
2.How to decide on the model issue? ( i.e jsp strut bc4j or jsp no strut bc4j etc.)
0 #9 Anil Passi 2007-09-25 11:47
Hi Swapnil

Ans 2. No jsp, no struts. Simply use OA Framework

Ans 1.
Pasting the excerpt from my other article, as below......
In your case, it is Patch 4573517
You must not install standalone jDeveloper from http://technet.oracle.com
Download jDeveloper patch from Metalink that comes bundled with OA Framework libraries and wizards

Download one of the below patches. Note that the patch itself will contain either jDev 9i or jDev 10g

Base 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

11.5.10 ATG CU5
Patch 6012619 JDeveloper 9i

R12 Base Version
Patch 5856648 jDeveloper 10g

R12 RUP2
Patch 6197418 jDeveloper 10g

Anil Passi

0 #10 shobhit 2007-10-10 06:14
I hav completed the first 4 tutorials.those are running fine in jdeveloper.but when i deploy it on oracle apps..the search page is running fine but if i call the create or update then insert n update page is not called...also there is no error shown(at the click of create or update person the search page is reloaded).....p ls help to solve this problem.......
0 #11 dks 2008-02-14 04:52
Hi Anil,

Can u plese let me knwo how we can call a workflow from the click of a button on a custom Framework page.


0 #12 Anil Passi 2008-02-14 08:29
Hi Deepak

When Submit Button is clicked, then you can trap that click within ProcessFormRequ est of the controller.
Fro m the controller, you can then call a method in AM using invokeMethod

F rom the AM, you can use JDBC Connection.

Fo r sample code, see below

public void completeWfActiv ity(Number number)
OADBTransaction Impl oadbtransaction impl = (OADBTransaction Impl)getOADBTransaction();
int i = oadbtransaction impl.getOrgId();
Number number1 = getOrgId();
int j = oadbtransaction impl.getUserId();
int k = oadbtransaction impl.getResponsibilityId();
int l = oadbtransaction impl.getResponsibilityApplicationId();
if(number1 != null)
oadbtransaction impl.setOrgId(number1.intValue());
OIEUtil.setAffValidationContext(oadbtransaction impl, number1);
String s = "";
s = "BEGIN fnd_wf_engine.C ompleteActivity ('APEXP',:1,'AP _VERIFY_BLOCK', ''); END;";
OracleCallableS tatement oraclecallables tatement = (OracleCallableS tatement)oadbtransaction impl.createCallableStatement(s, 1);
oraclecallables tatement.setObject(1, number);
oraclecallables tatement.execute();
catch(Exception _ex) { }
changeResponsib ility(j, k, l);
oadbtransaction impl.setOrgId(i);
OIEUtil.setAffValidationContext(oadbtransaction impl, new Number(i));
oraclecallables tatement.close();
catch(Exception exception2)
throw OAException.wra pperException(e xception2);
catch(Exception exception)
throw OAException.wra pperException(e xception);

Note:- This sample code was nicked from oracle.apps.ap. oie.audit.serve r.AuditAMImpl.j ava
0 #13 Roy 2008-09-09 02:15
Your discussions are of great help.
I am currently using Oracle9i JDeveloper Version (Build 1407) with Oracle Applications : I could not find the file fwkdevguide.htm on the desktop. Also I could not find the Tutorial file Tutorial.jpr on my desktop.
How can I use OA Framework? Is the patch 4573517 relevant? I like to install/reinsta ll JDeveloper on desktop (Windows XP) and do not want to install anything on Oracle Applications server at this stage, which is on Unix. Can you please advise how can I go ahead and use the tutorial you have suggested? What extra steps I need to use so that the software is installed on desktop only.
If I need to configure any settings on Oracle Apps, what would be the steps? Your help is most appreciated.

0 #14 Anil Passi-- 2008-09-09 05:06
Hi Roy

Please post this on

Anil Passi
0 #15 Rogerio 2008-11-12 14:41
Hi Passi, I''ve created till first CO and it works local, but when running in Applications I'vegot 'Error: You have encountered an unexpected error. Please contact the System Administrator for assistance. ' It shows error when I put AM and CO attached to the page. Have you passed through this ?
0 #16 Dina 2009-08-04 04:46
Thanks sooooooooooo Much it was really really much benefit :) :) :)
0 #17 venkat Reddy Pulichintha 2009-09-01 02:59
Hi Anil,

We have requirment after query the records we want to Bulk Update with different rows and columns.

Searc h based on From and to dates after we got the 20 records in 20 Records we will modify the data multple rows with MessageTextInpu t after modifed data we want to update at time all the rows which we modified.

Can you give me suggestion how to do

Venk at Reddy Pulichintha
0 #18 satyashah 2010-04-29 08:41
Hi Anil,

When i am trying to update, i am getting below error

-------- --
## Detail 0 ##
java.sql.SQL Exception: Initialization failed
at oracle.sql.NUMB ER.(NUMBER.java :280)
at oracle.jbo.doma in.Number.(Numb er.java:289)
at oracle.apps.po. server.xxPerson AMImpl.updatepe rson(xxPersonAM Impl.java:44)
- --------------- -------
could you please tell me how to rectify this?


Add comment

Security code

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

Enquire For Training

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner