Following query can be used to list all the personalizations of OAF using MDS Repository.
**But the problem with the below one, we cant be sure personalizations which are done by the business and as well as personalizations (vanilla) which are provided by oracle
*CREATED_BY column does not have any info any significance to validate if it is provided by oracle or done by business.
*business means : customization's done by developer for custom requirements.
select
jp.created_by,
jp.path_name, jp.path_docid
, jdr_mds_internal.getdocumentname(jp.path_docid) page_path
from jdr_paths jp where 1=1
AND jp.path_type='DOCUMENT'
AND jdr_mds_internal.getdocumentname(jp.path_docid) like '/oracle/apps/%custo%'
No comments:
Post a Comment