Whats is Discoverer Server ?
Discoverer 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)
What should I know about Discoverer as an Apps DBA ?
Though 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.
What is EUL ?
You will hear lot about EUL from business analyst which means End User Layer, which is the key to provide ease of use to underlying data in Oracle Apps Database.
Technical things about discoverer in Apps ..
--In Apps default discoverer version 4i, is installed under $ORACLE_HOME/discwb4
--Script to start discoverer server is addisctl.sh under $OAD_TOP/admin/scripts/$CONTEXT_NAME
-- This script in turn start discoverer processes which can be start by startall.sh under $ORACLE_HOME/discwb4/util (This script is different from adstrtal.sh)
-- startall.sh calls scripts like startgatekeeper.sh, startlocator.sh , startoad.sh, startosagent.sh to start gatekeeper, locator, oad & osagent resp.
-- In Apps two major way to access EUL is via Discoverer view & Discoverer Plus edition (You can use Discoverer Administration Edition as well)
Quiz to reader :
A. How will you find discoverer version in Apps ?
B. What URL you use to access Disco viewer & Disco plus .
Post your answers via comments
Stay tuned to check
How to install 10g Discoverer & configure with
Coming Soon .....