How to Extract OAF Customizations with User information?
Is there a better way to find out who actually made the OA personalizations and from which responsibility. I tweaked one of the sql but can't get the detailed user/resp level info.
SELECT
CASE WHEN OAF.WHAT_LEVEL_WAS_MODIFIED = 'responsibility'
THEN ( SELECT RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL WHERE RESPONSIBILITY_ID = OAF.WHAT_IS_THE_LEVEL_VALUE)
ELSE 'NotApplicable'
END AS RESPONSIBLITY_NAME, OAF.*
FROM
(SELECT DISTINCT PAT.PATH_DOCID
, JDR_MDS_INTERNAL.GETDOCUMENTNAME( PAT.PATH_DOCID ) WHAT_IS_THE_PATH
, REGEXP_REPLACE( JDR_MDS_INTERNAL.GETDOCUMENTNAME( PAT.PATH_DOCID ), '.*/customizations/([[:alpha:]]*)/.*', '\1' ) WHAT_LEVEL_WAS_MODIFIED