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.          

DECLARE

BEGIN

jdr_utils.listcustomizations

(p_document => '/oracle/apps/per/talentprofile/webui/TMEmployeePG');

END;

 DECLARE

BEGIN

jdr_utils.printdocument

(p_document => '/oracle/apps/per/talentprofile/webui/TMEmployeePG');

END;

DECLARE

BEGIN

jdr_utils.deletedocument(p_document => ‘/oracle/apps/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN’);

END;

Step7:- Click on Go.

Step8:- select the personalization and delete it.

Find the Customization's in Back End.

SELECT path_name,

       path_type,

       last_update_date,

       att_value,

       att_comp_seq,

       att_seq,

       att_name

  FROM jdr_attributes ja, jdr_components jc, jdr_paths jp

 WHERE att_comp_docid = comp_docid AND comp_element = 'customization' --and att_name = 'controllerClass'

       AND path_docid = comp_docid AND att_value LIKE '%xxchr%'