{"id":80,"date":"2006-11-04T22:00:00","date_gmt":"2006-11-05T02:00:00","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=80"},"modified":"2007-10-05T17:28:45","modified_gmt":"2007-10-05T21:28:45","slug":"discoverer-in-oracle-applications","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/","title":{"rendered":"Discoverer in Oracle Applications"},"content":{"rendered":"

One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of putting some bits and pieces for you on Discoverer and later on How to Integrate Discoverer 10g with Oracle Apps 11i<\/strong>. So lets start this discussion about overview & things you should know about Discoverer as Apps DBA.<\/p>\n

Whats is Discoverer Server ?<\/strong>
\nDiscoverer is and ad hoc query, reporting, analysis and publishing tool which help business users to get quick access to information from datawarehouse or OLTP systems. In Apps, Discoverer version 4i used to be installed & configured out of the box which is desupported now. You should configure Apps with Discoverer 10g (I am going to cover about how to configure discoverer 10g with E-Business Suite)<\/p>\n

What should I know about Discoverer as an Apps DBA ?<\/strong>
\nThough each component in Apps like forms, reports, web server including Discoverer in itself are quite big and more you know about them better it is for you . Few Important things you should know about Discoverer in Apps is like how to start\/stop & how to access it. In case of any issues you should be able to troubleshoot discoverer.<\/p>\n

What is EUL ?<\/strong>
\nYou will hear lot about EUL from business analyst which means End User Layer<\/strong>, which is the key to provide ease of use to underlying data in Oracle Apps Database.<\/p>\n

Technical things about discoverer in Apps ..<\/strong>
\n–In Apps default discoverer version 4i, is installed under $ORACLE_HOME\/discwb4<\/em>
\n–Script to start discoverer server is addisctl.sh<\/strong> under $OAD_TOP\/admin\/scripts\/$CONTEXT_NAME<\/em>
\n— <\/em>This script in turn start discoverer processes which can be start by startall.sh<\/strong> under $ORACLE_HOME\/discwb4\/util (This script is different from adstrtal.sh<\/strong>)<\/em>
\n—<\/em> startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh<\/em><\/strong> to start gatekeeper, locator, oad & osagent resp.
\n— In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well<\/span>)<\/p>\n

Quiz to reader :<\/strong>
\nA. How will you find discoverer version in Apps ?
\nB. What URL you use to access Disco viewer & Disco plus .<\/p>\n

Post your answers via comments<\/strong><\/p>\n

Stay tuned to check
\nHow to install 10g Discoverer & configure with Oracle Applications 11i<\/span><\/em><\/strong>
\nComing Soon …..<\/span><\/em><\/strong>
\n<\/span><\/em><\/strong>
\n*************Important Note*************<\/span><\/strong>
\nNow you can subscribe Email Notification For New Post on this Site <\/em><\/strong>
\n–Check on right Menu Bar of Page under E-mail Subscription enter your email ID
\n–click on “subscribe”.
\n–It will open new window to verify (If pop up blocker is enabled , allow for this session)
\n–You have to type text message displayed on pop up window
\n–“click on complete subscription”.
\nFinal step is to Verify in your mail box that you only asked for Subscription<\/em>.
\nGo to your inbox , you should see a mail with Subject “Activate your Email Subscription to:.. “Open that mail &
\nclick on link in mail
\nIf you don’t see this mail in your inbox then check your Junk eMail Folder<\/strong>
\nClick on this link
\nRelax & you will get notification in your mail box as soon I post new Topic here .<\/em><\/strong><\/p>\n

http:\/\/teachMeOracle.com\/forum<\/p>\n","protected":false},"excerpt":{"rendered":"

One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[92],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-dicsoverer"],"yoast_head":"\nDiscoverer in Oracle Applications -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Discoverer in Oracle Applications -\" \/>\n<meta property=\"og:description\" content=\"One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/\" \/>\n<meta property=\"article:published_time\" content=\"2006-11-05T02:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2007-10-05T21:28:45+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/\",\"name\":\"Discoverer in Oracle Applications -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2006-11-05T02:00:00+00:00\",\"dateModified\":\"2007-10-05T21:28:45+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Discoverer in Oracle Applications\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Discoverer in Oracle Applications -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/","og_locale":"en_US","og_type":"article","og_title":"Discoverer in Oracle Applications -","og_description":"One of my readers reminded me that I have not covered on discoverer for Apps DBA yet so thought of […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/","article_published_time":"2006-11-05T02:00:00+00:00","article_modified_time":"2007-10-05T21:28:45+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/","url":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/","name":"Discoverer in Oracle Applications -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2006-11-05T02:00:00+00:00","dateModified":"2007-10-05T21:28:45+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2006\/11\/04\/discoverer-in-oracle-applications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Discoverer in Oracle Applications"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=80"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}