How to remove personalization in OAF

How to remove personalization in OAF

Now we are goin to learn how to remove the personalization in OAF.

Step1:- Login to oracle application.

Step2:- Switch to Functional Administrator responsibility.

Step3:- Click on personalization tab.

Step4:- For application, Enter the respective application name.

Step5:- Click on the Personalized Checkbox.

Step6:- Click Go.

Step7:- Remove or De-activate your personalization by selecting the personalization level at

             which you made a particular personalization.

OR

Step1:- Login to oracle application.

Step2:- Switch to Functional Administrator responsibility.

Step3:- Click on personalization tab.

Step4:- Click on import/export sub tab menu.

Step5:- For application, Enter the respective application name.

Step6:- Provide the document path.

             To get the path

            Go to sql developer run the following it will give the path.          

begin   

jdr_utils.listCustomizations('/oracle/apps/icx/por/reqmgmt/server/MyReqsGlanceVO');   

      //Give the page path on which u did personalization or if u did extension provide on    which u extended.

end;

Step7:- Click on Go.

Step8:- select the personalization and delete it.

How to create view object(VO) in OAF

How to create view object in OAF

Now we are going to learn how to create the view object.

We will create the view object in hello ward page.

Steps to create the view object

Step1:- Right click on project select new

           

Step2:- Select ADF Business Component and the view object and click ok.

           

Step3:- Welcome window appears click on next.

             Specify the below details.

            Package:- sangu.oracle.apps.ont.HelloWord.server

            Name :- EmployeeVO

Note:- the view object should be in .server directory and view object name ends with VO for  

best practice.

 Click on next , next.

Step4:- In step 5 of View Object creation write the sql query for view object and click next.

           

Step5:- In step 8 check the Generate Java File check box and click finish.

           

This completes the creation of View Object.

 Now we have to attach this view object to Application Module.

Step6:- Double click on AM and select the vo from left side and move that to right side and

 click on apply and ok.

           

Now the view object is successfully attached to AM. Now we can use this vo anywhere in the project.

           

How to Create ViewObject(VO) Dynamically in OAF

Create ViewObject(VO) Dynamically

Now we are going to learn about how to create the view object (VO) programmatically.

Write the following code in In ProcessRequest

import oracle.apps.fnd.framework.server.OAViewDef
import oracle.apps.fnd.framework.OAViewObject 

    SampleAMImpl am=(SampleAMImpll)pageContext.getApplicationModule(webBean);

    if(am!=null)

    {

        OAViewDef viewdef=(OAViewDef)am.getOADBTransaction().createViewDef();

        viewdef.setSql("select ename from scott.emp");

        OAViewObject vo=(OAViewObject)am.createViewObject("SampleVO1",viewdef);

       

         //SampleVO1 is ViewObject Name

            

    }