Listing All OAF personalizations in Oracle Apps
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,
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;