OAF Page Personalization in Oracle apps Find Script

--Check OAF Personalization in oracle apps with SQL Query

SELECT jp.path_docid,

       jp.path_seq,

       jdr_mds_internal.getdocumentname (jp.path_docid) personalization_path,

       jp.path_name,

       jp.path_owner_docid,

       jp.path_type,

       jp.path_xml_encoding,

       jp.path_xml_version,

       jp.created_by,

       jp.creation_date,

       jp.last_updated_by,

       jp.last_update_date

  FROM apps.jdr_paths jp

 WHERE EXISTS

          (SELECT 1

             FROM jdr_components jc

            WHERE     jc.comp_seq = 0

                  AND jc.comp_element = 'customization'

                  AND jc.comp_id IS NULL

                  AND jp.path_docid = jc.comp_docid)