Enable Oracle apps Diagnostics-> Examine

Step 1

Navigate to System Administrator responsibility> Profile> System>

Step 2

Enter profile name: Utilities:Diagnostics

Enter Application User for whom you want to enable Diagnostics-> Examine

Step 3

Give Yes at User level and Save the Changes.

You can set Yes at Site level also if you want to enable this option for all Oracle application users

Step 4

Navigate to System Administrator responsibility > Profile > System >

Enter profile name: Hide Diagnostics menu entry

Enter Application User for whom you do not want to hide Diagnostics menu entry

SELECT FU.USER_NAME,
FR.RESPONSIBILITY_NAME,
FRG.START_DATE,
FURG.END_DATE
FROM APPS.FND_USER_RESP_GROUPS_DIRECT FRG,
APPS.FND_USER FU,
APPS.FND_RESPONSIBILITY_TL FR
WHERE FU.USER_NAME = UPPER(‘&user_name’)
AND FRG.USER_ID = FU.USER_ID
AND FRG.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID
AND FR.LANGUAGE = USERENV(‘LANG’);