EBS Customizations (MOSC)

MOSC Banner

How to Extract OAF Customizations with User information?

edited Nov 1, 2018 5:00AM in EBS Customizations (MOSC) 5 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center