Script to list All OAF personalizations in the system

Use the below script to list all personalizations in the sytem.
We then can use the functional administrator to disable the personalizations in case it is required.

This would be very useful script at the functional administrator doesnt' provide % search capabilities

I got this from metalink and putting it here for quick reference

SELECT PATH.PATH_DOCID PERZ_DOC_ID,
jdr_mds_internal.getdocumentname(PATH.PATH_DOCID) PERZ_DOC_PATH
FROM JDR_PATHS PATH
WHERE PATH.PATH_DOCID IN
(SELECT DISTINCT COMP_DOCID FROM JDR_COMPONENTS
WHERE COMP_SEQ = 0 AND COMP_ELEMENT = 'customization'
AND COMP_ID IS NULL)
ORDER BY PERZ_DOC_PATH;

How to get VO substituion details??/JDR_UTILS

we can use jdr_utils to get OAF personalization details.
Normally page level personalization's are done at different levels and we need to explicitly migrate the personalization file.

For VO Substitutions we normally do a jpx import.
Even the VO susbtiution are also personalization's at site level.If we migrate the personalization's of VO object, substitution can also be taken care.

Give the the VO path name to know whether it is substituted or not
declare
begin
jdr_utils.listcustomizations('/oracle/apps/pos/isp/server/PosHomeQuickSearchVO');
end;

To check what is the substitution
declare
begin

jdr_utils.printdocument('/oracle/apps/pos/isp/server/customizations/site/0/PosHomeQuickSearchVO');
end;

--To delete a substitution
.
declare
begin

jdr_utils.deleteDocument('/oracle/apps/pos/isp/server/customizations/site/0/PosHomeQuickSearchVO');
end;

We can use the above three commands to know about all the personalization's on a page,details of personalization's and programmatic way of deleting them