Enabling access to Oracle Forms-based Applications Diagnostics Menu

Enabling access to Oracle Forms-based Applications Diagnostics Menu

The difference between the two screenshots below are that in one of them the the diagnostics menu and submenus are available while in the other they are not.

The diagnostics menu allows users to personalize Forms, generate trace file, examine items etc.  Access to the diagnostics menu and submenu are controlled by the profile option ‘Hide Diagnostics Menu Entry’ about which I had written in an earlier post. However, sometimes even after setting the profile option, users may encounter the message “Function not available to this responsibility. Change responsibilities or contact your System Administrator.” This is because, beginning with Release 12.1.3, access to the diagnostics submenu items can be controlled by the profile option ‘Utilities:Diagnostics’ or by security functions using Role-Based Access Control (RBAC). Whether or not a submenu item is available is checked on an as-needed basis by the system when the user selects the submenu item.

The following table lists the seeded securing functions and their corresponding diagnostics menu items. If the user wants to access the diagnostics menu items from a specific responsibility, adding the functions below to the menu attached to their responsibility would allow them to do so.

Securing Function Name	Securing Function User-Friendly Name	Internal Menu Name	Runtime Menu Name
FND_DIAGNOSTICS_EXAMINE	FND Diagnostics Menu Examine	DIAGNOSTICS EXAMINE	Diagnostics Examine
FND_DIAGNOSTICS_EXAMINE_RO	FND Diagnostics Menu Examine Read Only	DIAGNOSTICS EXAMINE	Diagnostics Examine
FND_DIAGNOSTICS_TRACE	FND Diagnostics Trace	TRACE NO_TRACE REGULAR BINDS WAITS BINDS_AND_WAITS PLSQL_PROFILING	Diagnostics No Trace Regular Trace Trace with Binds Trace with Waits Trace with Binds and Waits PL/SQL Profiling
FND_DIAGNOSTICS_VALUES	FND Diagnostics Values	PROPERTIES_MENU ITEM FOLDER	Diagnostics – Properties Item Folder
FND_DIAGNOSTICS_VALUES_RO	FND Diagnostics Values Read Only	PROPERTIES_MENU ITEM FOLDER	Diagnostics – Properties Item Folder
FND_DIAGNOSTICS_CUSTOM	FND Diagnostics Custom	CUSTOM_CODE_MENU NORMAL OFF CORE SHOW_EVENTS	Diagnostics – Custom Code Normal Off Core Code Only Show Custom Events
FND_DIAGNOSTICS_PERSONALIZE	FND Diagnostics Personalize	CUSTOM_CODE_MENU CUSTOMIZE	Diagnostics – Custom Code Personalize
FND_DIAGNOSTICS_PERSONALIZE_RO	FND Diagnostics Personalize Read Only	CUSTOM_CODE_MENU CUSTOMIZE	Diagnostics – Custom Code Personalize

Adding the function ‘FND Diagnostics Personalize Read Only’ to the appropriate menu by navigating to System Administrator>Application>Menu, for example, will allow users to access a read-only version of the Form Personalization screen.

While adding the function ‘FND Diagnostics Personalize’ will allow users to access the normal Form Personalization screen.

In addition to securing functions, access to the diagnostics menu items can also be controlled by assigning permission sets to roles and then assigning the roles to users. The following table lists seeded permission sets.

Permission Set Name	Permission Set Code	Permissions Assigned
FND Diagnostics Examine Menu	FND_DIAGNOSTICS_EXAMINE_PS	FND Diagnostics Menu Examine
FND Diagnostics Examine Read Only	FND_DIAGNOSTICS_EXAMINE_RO_PS	FND Diagnostics Menu Examine Read Only
FND Diagnostics Custom Menu	FND_DIAGNOSTICS_CUSTOM_PS	FND Diagnostics Custom
FND Diagnostics Personalizations Menu	FND_DIAGNOSTICS_FORMS_PERS_PS	FND Diagnostics Personalize
FND Diagnostics Personalizations Menu Read Only	FND_DIAGNOSTICS_FRM_PERS_RO_PS	FND Diagnostics Personalize Read Only
FND Diagnostics Properties Menu	FND_DIAGNOSTICS_PROPERTIES_PS	FND Diagnostics Values
FND Diagnostics Properties Menu Read Only	FND_DIAGNOSTICS_PROP_RO_PS	FND Diagnostics Values Read Only
FND Diagnostics Trace Menu	FND_DIAGNOSTICS_TRACE_PS	FND Diagnostics Trace
FND Diagnostics Menu Developer	FND_DIAGNOSTICS_DEVELOPER_PS	FND Diagnostics Examine FND Diagnostics Personalize FND Diagnostics Trace FND Diagnostics Values FND Diagnostics Custom
FND Diagnostics Menu Support	FND_DIAGNOSTICS_SUPPORT_PS	FND Diagnostics Examine Read Only FND Diagnostics Personalize Read Only FND Diagnostics Trace FND Diagnostics Values Read Only FND Diagnostics Custom

Source/further reading: Controlling Access to the Oracle Forms-based Applications Diagnostics Menu(Oracle E-Business Suite System Administrator’s Guide – Configuration)