How to find oaf personalization from backend

How to find oaf personalization from backend

In this post , I am sharing the method , How to find oaf personalization from backend. I will share the sql query by which you can easily find the oaf personalization's in the OAF page. To run this sql query to find oaf personalization from backend , first you need to know the name of the OAF page in which you want to find the oaf personalization's. Here below is the sql query for How to find oaf personalization from backend

 

 How to find oaf personalization from backend

 

As highlighted below this is the path and name of the OAF page "HomePG".

 

 

 

 

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('%HOMEPG%');