How to identify the personlizations on an OAF page?

Here are several ways to identify if there are Personalization’s made to a page and what those Personalizations are:

1. The first and easiest way is to go to the page you want to check for Personalization’s, then click on the 'About this page' link at the bottom left of the page.
Click on the Personalization tab.
Then you should see a list of 'Effective Personalization’s', what elements have been customized and when they were customized/personalized.


2. Another way is to use the Functional Administrator.
The first thing to do to use the Functional Administrator is to identify the Document Path.
For example, go to the Notifications link from the Workflow User Web Applications responsibility, and then click on the Personalize Page link. Notice that the Document path for the Notifications page is:
/oracle/apps/fnd/wf/worklist/webui/NotificationsPG.

From the Functional Administrator responsibility Home page, click on the Personalization tab in the upper left hand corner. Insert the document path for the document you want to check - for example: Document Path  =  /oracle/apps/fnd/wf/worklist/webui/NotificationsPG and then click on the 'Go' button to get a list of Personalization’s for this page.

3. A third way to check to see if there are personalizations on a page is to use sqlplus and run the JDR_UTILS program.
You will need the Document path to the page in question - again using the Document path for the Notifications page:
/oracle/apps/fnd/wf/worklist/webui/NotificationsPG

Run the listDocuments function to drill down and find all documents that have been personalizations under a certain Meta Data region:
Run from sqlplus:
set serveroutput on
exec JDR_UTILS.listDocuments('/oracle/apps/fnd/wf/worklist/webui/');
/oracle/apps/fnd/wf/worklist/webui/customizations/

Note, you do not include the Page ID (NotificationsPG) with this query. In my test case, notice that there are 'customizations' in this MDS region webui.  The 'customizations' indicates that personalizations have been made to the 'webui' region.

Run the query again with the new path and notice that there are 'site' level customizations, although there could be other levels such as user, responsibility, ...:
exec JDR_UTILS.listDocuments('/oracle/apps/fnd/wf/worklist/webui/customizations/');
/oracle/apps/fnd/wf/worklist/webui/customizations/site/

Run the query again with the new path and notice that the customizations are at site level '0':
exec JDR_UTILS.listDocuments('/oracle/apps/fnd/wf/worklist/webui/customizations/site/');
/oracle/apps/fnd/wf/worklist/webui/customizations/site/0/

Run the query one more time with the new path and notice that the customizations are made to the 'NotificationsPG':
exec JDR_UTILS.listDocuments('/oracle/apps/fnd/wf/worklist/webui/customizations/site/0/');
/oracle/apps/fnd/wf/worklist/webui/customizations/site/0/NotificationsPG

Once we have identified a particular page or pages that have customizations/personalization’s, then we can use the printDocument to see what personalizations have been made to the page:

exec
JDR_UTILS.printDocument('/oracle/apps/fnd/wf/worklist/webui/customizations/site/0/NotificationsPG');
-------------
<?xml version='1.0' encoding='UTF-8'?>
<customization xmlns="http://xmlns.oracle.com/jrad" version="9.0.5.4.89_554"
xml:lang="en-US"
customizes="/oracle/apps/fnd/wf/worklist/webui/NotificationsPG">
<modifications>
<modify element="MainRegion.NtfView" rendered="false"/>
</modifications>
</customization>
-------------

As you can see, rendered has been set to "false" for "MainRegion.NtfView".

You can then use the deletedocument function to remove this personalization exec
jdr_utils.deletedocument('/oracle/apps/fnd/wf/worklist/webui/customizations/site/0/NotificationsPG');