Oracle Apps Notes

A collection of my random notes, primarily on Oracle Apps

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)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: