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. So lets start this discussion about overview & things you should know about Discoverer as Apps DBA.
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 Oracle Applications 11i
Coming Soon …..
Now you can subscribe Email Notification For New Post on this Site
–Check on right Menu Bar of Page under E-mail Subscription enter your email ID
–click on “subscribe”.
–It will open new window to verify (If pop up blocker is enabled , allow for this session)
–You have to type text message displayed on pop up window
–“click on complete subscription”.
Final step is to Verify in your mail box that you only asked for Subscription.
Go to your inbox , you should see a mail with Subject “Activate your Email Subscription to:.. “Open that mail &
click on link in mail
If you don’t see this mail in your inbox then check your Junk eMail Folder
Click on this link
Relax & you will get notification in your mail box as soon I post new Topic here .
Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.