1 / 12

Setting Up Oracle Discoverer Viewer and Plus Access for End Users

This guide provides step-by-step instructions on configuring Oracle Discoverer Viewer and Plus access for end users. By logging in as a System Administrator, you can modify system profiles for specific users. Set the "ICX: Discoverer Use Viewer" profile at the site level to "No" and at the user level to "Yes" for users who need Viewer access. Additionally, users with Plus access inherit the profile from the site level. A SQL query is included to assist in managing profile options efficiently. Ideal for beginners in Oracle Discoverer.

tate-kaufman
Télécharger la présentation

Setting Up Oracle Discoverer Viewer and Plus Access for End Users

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Discoverer Viewer and Plus Access to End Users By Kranthi.K

  2. When logged in as System Administrator responsibility, go to the System Profiles and query up the "ICX: Discoverer use Viewer“ profile for user A which is a user that you want to use Viewer. Then you should be able to set the profile at 2 levels. At the site level set the profile to No and at the user level set the profile to Yes. For users that are going to use plus you do not need to set the profile because they will get the profile from the site level. Following is the query :- SELECT a.APPLICATION_ID , a.PROFILE_OPTION_ID , b.PROFILE_OPTION_NAME , a.LEVEL_ID , a.LEVEL_VALUE , a.PROFILE_OPTION_VALUE , a.LEVEL_VALUE_APPLICATION_ID FROM APPLSYS.FND_PROFILE_OPTIONS B, APPLSYS.FND_PROFILE_OPTION_VALUES A where b.application_id = a.application_id and b.profile_option_id = a.profile_option_id and b.PROFILE_OPTION_NAME like 'ICX_DISCOVERER_USE_VIEWER'

  3. By Kranthi.K

  4. By Kranthi.K

  5. By Kranthi.K

  6. By Kranthi.K

  7. By Kranthi.K

  8. By Kranthi.K

  9. By Kranthi.K

  10. By Kranthi.K

  11. Hope this will be helpful to discoverer beginners. Presented By KRANTHI.K

More Related