How can I confirm Profile Option Settings at all levels for a specified Profile Option?

 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;

Leave a Reply

Your email address will not be published. Required fields are marked *