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

In this article you will learn from a working example, how to extend view object in OA Framework to add a new field to standard page.
This article will also teach you how this extension can be tested from both jDeveloper and also how this can be deployed to eBusiness Suite.
In the iProcurement shopping home page, we need to add Supplier Number field in the “My Requisitions” region.
My requisition region primarily displays the data from PO_REQUISITION_HEADERS_ALL Table.
However it is the table po_requisition_lines_all that contains the vendor id.

In order to add a Supplier Name field here :-

  1. Create a PL/SQL function that returns comma separated list of Supplier Names against a requisition.
  2. Extend the View object being used which is MyReqsGlanceVO.  
    Hence new view object xxgnmMyReqsGlanceVO will be created. xxgnmMyReqsGlanceVO will extend from standard view object MyReqsGlanceVO.
  3. Create substitution in jDeveloper, so that new/extended view replaces standard view object MyReqsGlanceVO
  4. Run the page from jDeveloper or from eBusiness Suite, so as to personalization the existing region.
    By personalization, a new field will be added.
    This new field will have a prompt Supplier number. And also, this new field will be mapped to the new view object attribute.
  5. Deploy the changes to application tier

Before making the changes, screen will look as below


After making the extension change, screen will look as shown below

Use this link to view the complete article in pdf



Anil Passi


0 #1 krishna 2008-10-30 16:27
Really nice article , step by step.
I cant execute it though because we dont have iprocurement installed in our company. I tried using any other application but , its hard to find a VO, with server.xml in the root folder.Oracle doesnt supply server.xml for all the projects
I wasnt able to create server.xml successfully. gave me errors.
May be you could write an article about how to create a server.xml, if its not provided .
0 #2 sohbet 2008-11-01 06:43
thank you

0 #3 df 2009-02-15 05:07
????? - ??? -??? -??????? ??? - ????? \ ????? / ?????? \ ????? ???????? \ ????? ?????? \ ????? ????? \ ????? ??????? \ ????? ?????
0 #4 Shiva Sharma 2009-05-20 05:48
We ar implementing one R12 project. Here we need to show net entielemnet balance on manager notification page.
manager want to see balance for every employee so that he can take a decsion for approval or not approval.
We add a new text field by personlaization on notifiction page. now i want to modify view pbject behind this so that i can
add new query for returning balance.
Please advise how to modify this page.

S hiva
0 #5 sakthivel 2009-10-14 12:40
Hi Anipassi,
I need to add 2 new fields in my custom OAF page.
My custom page is very simple like one data entry filed then Go button.
Once i enter any data (like %) enter click on the 'Go' its display records.
Now i need to add 2 more filed to display in the same page.
How i can add , what are the files i need to modify( since its already in custom page no need to extend any standard page)
0 #6 Roy F. 2009-11-17 09:25
Hi Anil,

I need to add two fields to the SSHR page “Personal Information”.

I have been looking at UNIX to se what files I could find.

I navigated to /oracle/apps/pe r/selfservice/p ersonalinformat ion.

What kind of files do I need to get from here?

Is there any other files I would have to get as well?

Thanks and regards,
0 #7 Anil Passi- 2009-11-17 17:37
Hi Roy

Did you add those fields using personalziation ? If so, then information goes into JDR% tables.

Cheers ,
0 #8 Keith 2010-02-23 20:34
Hi Anil,
I am able to follow all that you've outlined above. However, I'm struggling with trying to save input data in the field into the database.
The original AM has a method to update the VO. It currently calls a PL/SQL API that updates the field into a table. It is however saving null to the field that I have just made available in my extended VO.
To change that, I extended the AM. Unfortunately, I am lost when I tried to call the getter in my extended VO to put into the setter of the method that calls the API.
Any hints is greatly appreciated.

K eith
0 #9 antonio fernandez 2011-01-31 06:26
Hi Anil,
I am a completely fan of you.

I have a question. In Forms personalization s, we can launch validations before record,... for implementing our validations about some fields in the form.
That is possible in OAF Framework?

Sor ry about my english.

Regar ds,

0 #10 Sasi 2012-04-14 10:13
Hi Anil,

I have extended the VO in Receiving Correction page of iproc, but after extending the VO and substituting the original VO with the new VO created.
Though the substitutions are getting reflected on the page ( checked using about page) but the value of this new field is not getting displayed after adding this new field on to the page using personalization .

pls help.


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

Related Items

Fusion Training Packages

Get Email Updates

Powered by Google FeedBurner