Query to find oaf personalizations

Query to find oaf personalizations

In this post , I am sharing the sql query to find oaf personalizations in oracle application.If you want to get all the Personalizations details for the OAF page , you can refer this query for that. To check the personalization for any OAF page first we need to go that page and then need to check one by one to find the OAF personalization and by this way these could be a chance we can missed some of the oaf personalizations but with the help of this sql query , we can easily find the list of all the personalization's easy and quick with no mistakes too. Here below I am sharing this query to find oaf personalizations.

 

 

 

SQL Query to find oaf personalizations

 

SELECT

    jp.path_docid ,

    jdr_mds_internal.getdocumentname(jp.path_docid) Personalization_path,

    jp.path_name,

    Jp.Path_Owner_Docid,

    Jp.Path_Seq,

    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 jp.path_docid IN (

        SELECT DISTINCT comp_docid

        FROM jdr_components

        WHERE

   comp_seq = 0

    AND   comp_element = 'customization'

   AND   comp_id IS NULL

    )

    AND   upper(jdr_mds_internal.getdocumentname(jp.path_docid) ) LIKE upper('%MainExpPG%');