How to delete oaf personalization from backend

How to delete oaf personalization from backend

In this post , I will share the method , how to delete oaf personalization from backend. We have flexibility in oracle application , by which we can inactive or delete the oaf personalization's of the page but this is quite time consuming thing. With the help of the API we can easily delete the OAF personalization of the OAF page. To delete oaf personalization first of all we need to have the complete path of the oaf page in which we want to delete the oaf personalization. This is quite important too because some time , if we did some mistake in the OAF personalization then in result that oaf page in which we did this Personalizations starts giving errors and it does not open too and in that scenario we can easily deleted this error personalization from the backend and then after that the OAF page can again start work. Here below I am sharing the details steps of how to delete oaf personalization from backend.

To delete oaf personalization from backend we uses  jdr_utils.deleteDocument API.

How to delete oaf personalization from backend

 

As highlighted below this is the path of the OAF page

 

 

Enter the Compete page path to this below SQL statement.

select ATT_COMP_DOCID from JDR_ATTRIBUTES
where ATT_VALUE like '%oracle/apps/oie/webui%'


The Above query will return value in ATT_COMP_DOCID column and pass this as input to below SQL Statement. For Example we get ATT_COMP_DOCID as '223444'

select jdr_mds_internal.getDocumentName(223444) from dual;


The Above query will return the path of the personalization for this above page we have more then one personalization then it will return more then one line and pass this as input to below SQL Statement one by one.

EXEC jdr_utils.deleteDocument('/oracle/apps/ap/oie/webui/PageNamePG');

 

 

How to delete oaf personalization from backend