Friday 30 March 2018

OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

In this post , we will do View Object VO extension in Oracle Application OAF web pages. first of all , we will discuss the need of the VO extension in OAF. When we have an requirement to display some more attributes or fields in the OAF page then we do VO extension to meet this requirement. We all know that , We see the data in the OAF page through View Objects(VO) and in a single page can have more then 1 View Objects(VO). First of all , we need to find out that , in which Standard View object , we need to add new Fields in OAF Page. Then we do view Extension , to add this new field in the View Object and then display this new Field in the OAF page through Personalizations.
 

VO Extension Steps:-

1.Indentify that Which VO we need to Extend
2. Download the VO from Oracle Java_Top Location to Your Local Desktop under My Projects folder of Your JDev setup.
3.Then We create New view Object(VO) which extends the Standard View Object.
4.Then We substitute the New Custom View Object with the Standard View Object.
5.Then we upload the New Custom View Object to Oracle Java_Top Location.
6.Then we Register the New View Object in the Oracle application Through XML Importer script.
8.After Import/Register , We add the new field in the OAF page through Personalization and then give reference in this Field for the New Custom View Object(VO).
 

OAF VO Extension Example: How to add new Column in the Expense Report Summary Home Page

 
Step1:- First Go to your OAF page in the application , in which you will do View Object Extension.
This is the Page in which we will do View Extension. Here I want to display the DFF attribute5 in this Track Submitted Expense Reports Status Window.
 
OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

 
 
Step2:- To see the Properties of this Page and to know which View Object is working behind this Page. for this we need to go to 'About this Page' in the Bottom of the Page.
 
 
 
Step3:- Click on the Expand All option and in the Controller Section you can see the Controller Name
 
OAF VO Extension : How to add new Column in the Expense Report Summary Home Page
 
 
 
Step4:-Click '+' icon for Business Components References Details.
 
OAF VO Extension
 
 
Step5:- This is the Location of the View Object under Java_Top under which you will do Extension.
 
OAF VO Extension
 
Step6:-
 
 Now you get to know that where is your Standard View Object is Placed in the Oracle application Under Java_Top.

Then you Need to go to Server Under Java_Top then Under Java_Top follow the same path 'oracle/apps/ap/oie/webui/' and copy the 'TrackExpesneReportsVO' from Server to your Local Desktop.

One Important Thing.

You need to create the same path in your JDev folder under' 'jdevhome'
Under JdevHome there is MyProjects' folder under this folder you have to Create same folder structure like oracle/apps/ap/oie/server/' and then this copied file 'TrackExpesneReportsVO' in this Location.

The rule is you have to create same folder structure like the Folder Structure created for The Standard Controller in the Application server Java_Top.
 
OAF VO Extension
 
 
Step6:-This is the steps you have to implement before doing Start Extension in the JDeveloper.
 
Step7:- Now open the JDeveloper.
 
OAF VO Extension
 
 
 
 
Step8:- Now we will create OA Workspace and Project to do Controller Extensions.
 

OAF VO Extension
 
Step9:- Give the Name of OA Workspace. Click Ok.
OAF VO Extension
 
 
Step10:- Now Give the Name of the Project same like OA workspace.
Package Path:- Choose the same like Standard View Object but choose the application Top start with xx like this this change 'xxap'.
OAF VO Extension
 

Step11:- Then Finish this Project.
Controller Extension In OAF :How to add OAF code in Controller Extension on Button Click Event

Step12:- Now you can see your OAF Project has been completed. Now we will do Controller Extension under this Project.
OAF VO Extension



Due to the Length of this Topic , I will split this Topic two Posts. Please find the Second Part of this Post as below

Part2 url:- https://rpforacle.blogspot.in/2018/03/oaf-vo-extension-how-to-add-new-column-in-the-expense-report-summary-home-page.html



OAF VO Extension : How to add new Column in the Expense Report Summary Home Page

5 comments:

Logan L Watson said...
This comment has been removed by the author.
Logan L Watson said...

These things are very important, good think so - I think so too... best home builder in st louis

Anonymous said...

have one seeded page where there is LOV called Category , but when LOV is open there is Category as well as Description , so here my question goes:

1. How to make description as default search , so whenever user on lov tried to search by description the LOV region should search by description.

Ashwini Tenglakar said...

Hi All, I am trying to add two new columns(which are not present in entity Object) to a EO based VO. I was able to add but in extended VO.xml file ,I am unable to see attribute related to EO. Can anyone help on this?

Anonymous said...

your blog is really informative and helpful for me. Thanks for sharing information
Oracle Fusion Financials Online Training
Oracle Fusion Technical Online Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *