Monday 13 August 2018

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
 
 

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

 

 

 

1 comments:

Anonymous said...

Good content in this post and site. We need more fresh and good content like this. Thanks for posting great stuff, it’s very useful to me Oracle Fusion Cloud Financials Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *