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

Star ActiveStar ActiveStar ActiveStar ActiveStar Active

Now that we are able to Insert record into tables and search for records from a OAF screen, it makes sense that the OAF screen should allow us to update the records in the table as well. So, here it goes, below are the steps that shows updation of records in a table from a OAF screen.

Requirement: To update records in a table from OAF screen

Step 1: Complete creating a workspace and project as in Search Record article

Step 2: Create an Update action item

Right click on table region SearchRecordVO1 -> New -> Item

Set the properties of the item created as shown below:





Click on browse button for parameters under Client action pane and enter the parameter name and values

Name – updateColumn1

Value -- ${oa.SearchRecordVO1.Column1}

Name – updateColumn2

Value -- ${oa.SearchRecordVO1.Column2}


Step 3: Create a OA Components page

Right click on SearchRecord project -> click New -> select OA components under Web Tier -> select Page

Package: oaf.oracle.apps.fnd.searchrecord.webui

Page Name: UpdateRecordPG

Step 4: Set Page properties

Select on the UpdateRecordPG page and go to structure pane where a region of type 'pageLayout' and ID 'region1' is automatically created.

Click on region1 in structure page and set the project properties as in the below screenshot - set all the properties except the controller class, for now.


Step 5: Set new Controller

Select PageLayoutRN in the structure pane -> Right click on it -> Set new controller

Package: oaf.oracle.apps.fnd.searchrecord.webui

Controller name: UpdateRecordCO

This automatically sets the controller class property in UpdateRecordPG page properties.

Step 6: Create region in UpdateRecordPG

Right click on PageLayoutRN -> New -> Region

Now, this creates a new region of style header under PageLayoutRN

Select region1 - set the ID as MainRN and set the region style to messageComponentLayout

​Step 7: Create item in MainRN

Right click on MainRN > New > messageTextInput

Set the properties of the item as in screenshot below:


Create one another item similar to the above one and set it properties as below:


Step 8: Add Apply and Cancel buttons

Right click on PageLayoutRN > New > Region

ID -> Buttons

Region Style -> pageButtonBar

Right click on Buttons -> New -> Item

Attribute Set -> /oracle/apps/fnd/attributesets/Buttons/Apply

Enter the properties for the item as in the below Screenshot


Similarly create one more item for Cancel button

Attribute Set -> /oracle/apps/fnd/attributesets/Buttons/Cancel

Enter the properties for the item as in the below Screenshot



Step 9: Add a return navigation link to UpdateRecordPG

PageLayoutRN -> New -> returnNavigation

ID –> return

Set Destination URI as -> OA.jsp?page=/oaf/oracle/apps/fnd/searchrecord/webui/SearchRecordPG&retainAM=Y

Text –> Return to SearchRecordPG

Final page layout looks as below:


Step 10: Add the below code in SearchRecordCO:



     if ("update".equals(pageContext.getParameter(EVENT_PARAM)))


       pageContext.setForwardURL("OA.jsp?page=/oaf/oracle/apps/fnd/searchrecord/webui/UpdateRecordPG", null, OAWebBeanConstants.KEEP_MENU_CONTEXT,                        null, null, true,                           OAWebBeanConstants.ADD_BREAD_CRUMB_NO, OAWebBeanConstants.IGNORE_MESSAGES);


Step 10: Add the below code in SearchRecordAMImpl



   public void updateRow(String Column1, String Column2)


    SearchRecordVOImpl vo = (SearchRecordVOImpl)getSearchRecordVO1();

    vo.initQuery(Column1, Column2);



   public void apply()





   public void rollback()




Step 11: Add the below code in SearchRecordVOImpl


   public void initQuery(String Column1, String Column2)


    if ((Column1 != null) && (!("".equals(Column1.trim()))))


     setWhereClause("column1 = :1 AND column2 = :2");

     setWhereClauseParams(null); // Reset always

     setWhereClauseParam(0, Column1);

     setWhereClauseParam(1, Column2);




Step 12: Add the below code in UpdateRecordCO



     OAApplicationModule am = pageContext.getApplicationModule(webBean);


     String Column1 = pageContext.getParameter("PColumn1");

     String Column2 = pageContext.getParameter("PColumn2");

     Serializable[] params = { Column1, Column2 };

     am.invokeMethod("updateRow", params);



     OAApplicationModule am = pageContext.getApplicationModule(webBean);


     if (pageContext.getParameter("Apply") != null)



       OAException message = new OAException("Record has been Updated successfully!", OAException.INFORMATION);



     else if (pageContext.getParameter("Cancel") != null)



      pageContext.forwardImmediately("OA.jsp?page=/oaf/oracle/apps/fnd/searchrecord/webui/SearchRecordPG", null,                                      OAWebBeanConstants.KEEP_MENU_CONTEXT, null, null, false, // retain AM OAWebBeanConstants.ADD_BREAD_CRUMB_NO);



Search for data and click on update pencil icon in column 3:



result updatepg_on_page_load_updaterecord_article7.png


Update record for column2 from efgh to pqrs:



Hit Apply:



Return back to search page to see the updated result:


Roopa jetR


0 #1 sandeep1 2015-05-15 10:38
Getting lot of errors
Error(15,10): duplicate definition of method initQuery(java. lang.String, java.lang.Strin g, java.lang.Strin g) in class xxapps.oracle.a pps.fnd.M_Searc hRecord_1.serve r.M_SearchRecor d_1VOImpl
OAException message = new OAException("Re cord has been Updated successfully!", OAException.INF ORMATION);

private class OAException {

Add comment

Security code

About the Author

Roopa jetR

Roopa jetR is an budding OAF developer.

LinkedIn contact: https://www.linkedin.com/in/roopajetR

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

Related Items

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner