Script to list All OAF personalizations in the system:Oracle Apps Technical
By Jag - April 18, 2014
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;
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;
0 comments