Query to get OAF Personalization details in EBS R12
Hi,
I am looking for a query which can give me below details about all OAF Personalization done in an instance:
OAF Page, document path, extensions(CO,VO etc), Responsibility and function/form/menu entry to which the personalization is done.
I am able to get the first two i.e OAF page and its document path from the below query:
SELECT JP.path_docid DOC_ID
, JP.path_name NAME
, jdr_mds_internal.getdocumentname(JP.path_docid) DOC_PATH
FROM jdr_paths JP
WHERE JP.path_docid IN ( SELECT DISTINCT comp_docid
FROM jdr_components
WHERE comp_seq = 0
AND comp_element = 'customization'