Anil's Blog is Best Viewed on GOOGLE CHROME

Sunday, April 5, 2009

Diagnosing Personalization Problems

About this Page link shows document path and all personalization documents

• MDS pages saved under /mds/comp/sub/file.xml
• XML files imported into MDS repository at customer site

Use the Functional Administrator Responsibility / Application Catalog Tool to disable individual personalization documents

• Turn off personalizations for the entire instance by setting the following profile to ‘Yes’
• Disable Self-service Personal / FND_DISABLE_OA_CUSTOMIZATIONS

Use SQL*Plus to see personalization registration
• Turn on diagnostic messaging in SQL*Plus
• SQL> set serveroutput on

//Review what personalization documents exist for a given page

• execute jdr_utils.listcustomizations('/oracle/apps/fnd/wf/worklist/webui/FullWorklistPG');

//Review a personalization document

• execute jdr_utils.printdocument('/oracle/apps/fnd/customizations/user/2662/wf/worklist/webui/

// Delete a personalization document

• execute jdr_utils.deletedocument('/oracle/apps/fnd/customizations/user/2662/wf/worklist/webui/

1 comment:

  1. Great thoughts you got there, believe I may possibly try just some of it throughout my daily life.



Note: Only a member of this blog may post a comment.