Run this script to identify Site, and all Responsibility and User values associated with the selected profile option
SELECT A.LAST_UPDATE_DATE,
T.USER_PROFILE_OPTION_NAME “PROFILE OPTION”,
DECODE(A.LEVEL_ID, 10001, ‘SITE’,
10002, ‘APPLICATION’,
10003, ‘RESPONSIBILITY’,
10004, ‘USER’) “LEVEL”,
DECODE(A.LEVEL_ID, 10001, ‘SITE’,
10002, B.APPLICATION_SHORT_NAME,
10003, C.RESPONSIBILITY_KEY,
10004, D.USER_NAME) “LEVEL VALUE”,
A.PROFILE_OPTION_VALUE “PROFILE VALUE”
FROM FND_PROFILE_OPTION_VALUES A,
FND_APPLICATION B,
FND_RESPONSIBILITY C,
FND_USER D,
FND_PROFILE_OPTIONS E,
FND_PROFILE_OPTIONS_TL T
WHERE A.PROFILE_OPTION_ID = E.PROFILE_OPTION_ID
AND E.PROFILE_OPTION_NAME =’&PROFILE_OPTION_NAME’ —Enter profile option name here
AND A.LEVEL_VALUE = B.APPLICATION_ID(+)
AND A.LEVEL_VALUE = C.RESPONSIBILITY_ID(+)
AND A.LEVEL_VALUE = D.USER_ID(+)
AND T.PROFILE_OPTION_NAME = E.PROFILE_OPTION_NAME
ORDER BY E.PROFILE_OPTION_NAME, A.LEVEL_ID DESC;
T.USER_PROFILE_OPTION_NAME “PROFILE OPTION”,
DECODE(A.LEVEL_ID, 10001, ‘SITE’,
10002, ‘APPLICATION’,
10003, ‘RESPONSIBILITY’,
10004, ‘USER’) “LEVEL”,
DECODE(A.LEVEL_ID, 10001, ‘SITE’,
10002, B.APPLICATION_SHORT_NAME,
10003, C.RESPONSIBILITY_KEY,
10004, D.USER_NAME) “LEVEL VALUE”,
A.PROFILE_OPTION_VALUE “PROFILE VALUE”
FROM FND_PROFILE_OPTION_VALUES A,
FND_APPLICATION B,
FND_RESPONSIBILITY C,
FND_USER D,
FND_PROFILE_OPTIONS E,
FND_PROFILE_OPTIONS_TL T
WHERE A.PROFILE_OPTION_ID = E.PROFILE_OPTION_ID
AND E.PROFILE_OPTION_NAME =’&PROFILE_OPTION_NAME’ —Enter profile option name here
AND A.LEVEL_VALUE = B.APPLICATION_ID(+)
AND A.LEVEL_VALUE = C.RESPONSIBILITY_ID(+)
AND A.LEVEL_VALUE = D.USER_ID(+)
AND T.PROFILE_OPTION_NAME = E.PROFILE_OPTION_NAME
ORDER BY E.PROFILE_OPTION_NAME, A.LEVEL_ID DESC;
very informative articles or reviews at this time.
This is really interesting, You’re a very skilled blogger. I’ve joined your feed and look forward to seeking more of your magnificent post. Also, I’ve shared your site in my social networks!
Awesome! Its genuinely remarkable post, I have got much clear idea regarding from this post