oaf personalization tables in oracle apps

oaf personalization tables in oracle apps

In this post , we will discuss about oaf personalization tables in oracle apps. With the help of oaf personalization tables we can easily get the information's of the OAF Page Personalizations. We have only one important table in Oracle application which stores the complete information about this OAF Personalizations. Here below I am sharing the oaf personalization tables in oracle apps and the sql query for this table too.

 

 

 

oaf personalization tables in oracle apps.

1.jdr_paths

2.jdr_components

3.PERZ_DOC_PATH

 

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