The topic of VO Extensions will be discussed in this article. With one Working Example, I’ll walk you through the entire Extension steps for VO. When we wish to add a new column to an existing OAF page Vo to show some extra information on the Standard OAF page, we’ll need to use the VO extension. We extend the Standard OAF page VO in VO Extensions. The complete detail descriptions for Extension stages may be found below.
In this section, we’ll look at how to expand the view object in OAF.
Step 1: Visit to the page where VO extension is required
- Go to the page where you want the view object to be extended.
- Examine the page and make a note of whatever areas you’d like to expand.
- Note the VO linked with that region by clicking on about this page.
Also, make a note of the VO’s path.
Step 2: Let’s assume we’re extending the standard iProcurement page here.
- In the existing table in the My Requisition region, we are now adding one more new column called Created By
Take down the following information
- MyReqsGlanceVO is the name of the VO.
- “oracle.apps.icx.por.reqmgmt.server.MyReqsGlanceVO” is the path (U will get the path of the VO in Business components section ).
Step 3: Copy the relevant files from the server $JAVA TOP to the local system.
Step 4: Create a java file from the class file.
Step 5: Open the jDeveloper Application.
- Make a new workstation for yourself.
- Make a single project
- Name your package (VOExtension.oracle.apps.icx.por.reqmgmt.server)
Step 6: Create View Object
- Select new ADF Business Components by right-clicking on the project.
- Name of the package:-Insert the name of the package (VOExtension.oracle.apps.icx.por.reqmgmt.server)
- View Object Name: (xxMyReqsGlanceVO)
- Extends Browses the default VO (oracle.apps.icx.por.reqmgmt.server.MyReqsGlanceVO)
- Click on Next
It will open a SQL query window where you may make the necessary adjustments to meet the requirements.
Remember to create the java file. Compile the java files after you’ve created the extended view object.
Step 7: Right-click the project and select project properties.
- Business Components
- Select standard VO on the left hand side and custom VO on the right hand side in the substitute pane, then hit the ADD button.
Step 8: Transfer to the server with the newly generated folder
From “C:devoafr1211jdevhomejdevmyclasses” (the newly formed VOExtension folder).
To “/oracle/apps/r12/visr12/apps/apps st/comn/java/classes”
Step 9: JAVA Import Utility
JAVA Import Utility is a program that allows you to import Java files onto your computer.
Change the directory to when you open the command prompt. “C:\oaf\p9879989_R12_GENERIC\jdevbin\oaext\bin”
Make the following path in a single line in notepad, then uncheck the word format box.
jpximport C:\oaf\p9879989_R12_GENERIC\jdevhome\jdev\myprojects\VOExtension.jpx -username apps -password apps –dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= focusthreadr12.com)(PORT=1521))(CONNECT_DATA=(SID= visr12)))”
C:\dev\oaf\r1211\jdevhome\jdev\myprojects\VOExtension.jpx -> This is the location of your jpx file on your computer.
Step 10: Go to the sql developer and run the following command to see if the extension has completed or not.
It will show you the path.
Step 11: The Apache Web Server should be bounced.
Step 12: Proceed to the front end.
- To extend a page, navigate to the page you want to expand.
- Select “About This Page” from the drop-down menu.
- All business components should be expanded.
- Check to see if the extended VO is reflecting.
Step 13: Personalize the page
- Create a new column type item for the newly added field.
- Create a new item to show the information.
- Give the necessary information
- The new field View Instance has a View property (Give the standard View Instance name)
- Make a single column header item.
The view object extension is now complete.
Return to the page and see if the newly added field is visible.