How to check oaf personalization in oracle apps

 How to check oaf personalization in oracle apps

In this post , I am sharing the method how we can check OAF personalization in oracle apps. if you want to know or check oaf personalization in oracle apps , then you can use this way , which helps to provide the list of all the oaf personalization's which is working for any oaf page in the Oracle application. we can check oaf personalization's in oracle apps with two ways either we can check this with the help of sql query or we can check with the standard application feature. Here below I am will explain both these two ways How to check oaf personalization in oracle apps

 

2 ways How to check oaf personalization in oracle apps

 

Check oaf personalization in oracle apps with SQL Query

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

Check oaf personalization in oracle apps with Oracle application

Step1:- Go to Functional Administrator.

 

Step3- Go to Personalization Tab

Then Go to Personalization Repository.

 

 

 

 

Step 4:- Then enter the Document path/ page path for which you want to see all your OAF Personalizations as below.

 Select pages and click on Export to File System button.

This will save the Personalization registration in a file and will put this file under  path '/usr/tmp'

'FND: Personalization Document Root Path'

As an example I set path /usr/tmp


You can also copy these file in your desktop too.