Apps To Fusion

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

http://www.apps2fusion.com/training_demo/anilpassi/oa-framework/extension/Extend-OA-Framework-Add-New-Field.pdf