Main Menu
| Home |
| Technical Articles |
| Training Articles |
| Receive Email for New Articles |
| Contributors |
| Apps Book |
Related Items
Home 
Contributors Discoverer 4i to Discoverer 10g Migration Steps
Contributors Discoverer 4i to Discoverer 10g Migration Steps 
Also see here fully verifiable feedbacks/testimonials
| Discoverer 4i to Discoverer 10g Migration Steps | | Print | |
| Written by Chandra Matta | |
| Monday, 26 November 2007 | |
|
Oracle Corp. recently(one year back) decommissioned it's discoverer 4i and it's previous versions. This triggered many companies to upgrade from Old versions of Discoverer to Discoverer 10g. Some time back, I got an opportunity to lead such kind of project with one of my clients. The objective of this paper is to upgrade the discoverer to the latest supported version. This paper covers the following topics
Important Notes: 1. Discoverer 10 can be implemented in two models. a. Standalone Installation b. Oracle 10g AS with Infrastructure My client selected "Standalone" method. So my and papers talks about - Standalone, but not Oracle 10g AS with Infrastructure 2. Some companies use Noetix views and many companies may not have implemented Noetix. a. If your client is not using Noetix views, you can ignore the step - "Noetix Upgrade" in this paper. b. In my project, it involved Noetix upgradation also. Steps In Brief Noetix Upgrade [Optional] Application Patches Oracle Bi 10g Installation And Configuration Configuration With E-Business 11i Port Information Patch Application On Oracle Bi 10g Eul Migration Pre-Installation Tasks Db Schema Creation And Import EUL Upgradation Post-Installation Tasks Audit Trail Reports Rollback Plan Steps in detail Click here for the document that explains the steps to migrate to Discoverer 10g Note: The above pdf might take a minute or so to download Supporting Documents Please click on below links to access these documents Discoverer_Migration_Plan.ppt Noetix Upgrade Document 358707_1.txt Create_DB_schema_to_host_10g_EUL.txt Modify_Summary_Ownership_Discoverer_EUL.txt Install_EUL_Audit_trail_reports.zip Comments
(31)
Hi Chandra/Anil,
First thanks for the nice document, it really helped me a lot to understand the exact path, there is one question left out in my mind, in my case- my client is having 3i with noetix and now they are moving to Discovere 10g, now the main problem is they dont want to use noetix anymore in 10g instead if it wants the same functionality with 10g BI, can u please help me how to create BA's and there related folders to come out fron this issue.
Saurabh srivastava,
I am thinking to provide another paper, which will give basic and advanced steps to create discoverer reports using Discoverer 10g tools. Will work on it and provide you asap. Thanks, Chandra
Hi Chandra Matta ,
Thanks for a very good document , but i have a question. Can you please suggest me how can i submit discoverer as a request on Oracle application.(like submit oracle report) Can it work together like this or discoverer can just use oracle application database. Thans alots. Nath
Hi Dexter,
> for the first question. - Migration from Discoverer 3i to 10g is a two step process. You first need to miigrate from Discoverer 3i to 4i and then Discoverer 4i to 10g. > 2nd question abt. Noetix - There is no shortcut) to get Noetix views into Discoverer 10g. If your client no longer want to buy Noetix views. Bad news.  - I think you have to analyze existing noetix system and re-design /create complete Business Areas and Folders in it. Not sure any alternate solution is available or not. Raise TAR and see, what Oracle says abt it. Regards, Chandra
Hi Nath,
There is one article in this site, which will articulate how to create discoverer report and the how to register it in Oracle as a form function.. http://oracle.anilpassi.com/invoke-discoverer-report-from-oracle-applications.html By doing the way, it described in above paper,you can access the Discoverer report from the application as on demand report. See if it serves your requirement. Regards, Chandra
Hi anil,
Let me know the possible Technical issues on discoverer and Fsg Reports,while upgrading from 11.5.10 to Release 12 and what is Noetix reports
Hi Chanda
Thanks very much for ur document link. I have more questions , I did create discoverer report and followed your document step. when i signon application and run discoverer report from the menu , i faced this error Authentication Failed. (Default or specified schema containing EUL tables is inaccessible ) what should i do , please sugget, Pls where should i save my work book , on database or on my computur. Thanks alots Nath.
Hello Chandra
Thankx a lot for your reply.I will definitly wait for your upcoming documents.And here one more thing i like to ask you from that can all kind or types of report cand be build from discoverer or for some reports we need to develop thru report builder.
Hi Prasad,
I din't work much in FSG reports. Not sure it's impact in 12i. Coming Discoverer - I don't think there will be many surprises, when you migrate to 12i. It is very much streamlined, Look and feel and BI directgion is clear now. May be apllication of couple of patches will take you there. Regards, Chandra
Hi Nath,
Check system profiles(discoverer related) in your EBS. I think few profiles are missing or wrongly set. I have listed required profile settings in my paper. Verify and use them in your application. You should save your workbooks in database. You can't access workbooks which are saved on your desktop, using EBS. And..., now many the companies stgrongly discuraging having workbooks on individual desktops. reasons could be.. 1. Users required Discoverer-Desktop versions to access workbooks on local machines. 2. Discoverer-Desktop versions .. involves licensing issues.. your company should spend some money to buy licenses. 3. Users create their own,multiple versions for a single report. In a long term, Discoverer reporting system end up in big mess. - Strong and Valid reason. In my previous project, I had to clean up(removal of duplicates) lot of reports. They had around 800 reports, In which only 300 are original ones. 4. Maintanance is easy for Tech/DBA teams. There could be more issues.. Regards, Chandra
saurabh,
There is no thumbrule to say which tool(Report Builder/Discoverer) is used to develop specific kind of reports. Both has got their own advantages and disadvantages. Discoverer Tool and Reports - is a analytical tool. Users, once they run workbook and get the data, they can play around with data and can do lot of analysis. For this, they rfeally don't require techinical skills. Regards, Chandra
Thankx a lot for the reply ....Chandra rite now i am working ona project in whcih we have to use discoverer reports as well as report builder also .So if i need any help from you so can i ask you any time .....regarding quesry problem or report problem ..
Regards saurabh
Hi, chandra ,
In discoverer can we use view .rite now i m writing a query in which i m using table and view both .but in discoverer i am unable to do that. plz solve this problem saurabh
Hello Chandra,
First of all I will like to thank you for providing such great document. You are the best!! Do you have screen shots of how the EBusiness suite will look after 10g is installed in Standalone setup? Can you please send me those? I will be much obliged. Regards, Jagdeep
Hi Sonu,
Yes, we can develop discoverer reports based on tables and views. Normal practice is like this.. 1. create a custom table or view in custom schema(ex: cusar,cusap etc) 2. create a public synonym in apps scema for the above created custom object(tables and/or views) 3.Make sure that your eul schema( the schema which is hosting your discoverer tables ) should able to execute the synonym you created in apps( in step#2) If you follow above sequence of steps during your development, your tables and views should be visble and available for discoverer report creation. Ideally eul schema should have read-only access to all apps tables/views/any other objects. Let me know if you still face any problem in this regard. Regards, Chandra
Hi Jagdeep,
I couldn't understand your question. Do you mean, how to integrate discoverer with EBusiness Suite or how to access discoverer reports from EBusiness suite. Could you please give me more details around your question. So that I will try to address it. Regards, Chandra
Hello Chandra,
Thankx a lot for the solution,i want to share something , i have created custom folder only and while interfacing b/w tables and view first i did like this suppose a = b and b = c then automatically a = c rite ..when i did this it was saying "query caused no data to be retrived" then i did this a = b and b = c and c = a after doing this it works properly and i m getting my output correctly .. heer i want to ask weather this is complusary in views or i have done something wrong. Regards sonu
Hi Chandra,
i too facing the same problem as you did with your last client, my questions is how we can save all the workbooks which are saved in local desktop to database, for example i have 10 workbook which are saved in pc, now i want to save that workbooks into db, as when looking into discover plus, i couldnt see these 10 workbooks which are created in local pc.
Hi Reddy,
To save workbooks into database, which are on desktop currently, you need to use Discoverer Desktop tool. With this version of discoverer tool, you can access reports which are saved on desktops and reports which are available in Database as well. Let me remind you once again..about each version of discoverer tools.. 1. Discoverere Admin - is a windows/desktop installation, to do admin related activities .. i) create/edit/delete business areas and it's objects ii) security related grants/permissions to users and/or responsibilities... iii) , 2. Discoverere Desktop - is a windows/desktop installation, to create/edit/delete workbooks. And save workbooks on local machine or database. 3. Discoverere Plus - with all features of Discoverere Desktop minus save workbooks on local machine. This is not a windows installation. It's a webbased application works with browser. 4. Discoverere viewer - Only to view workbooks. No create/edit/delete features. You can edit very few features of workbook with this tool. Hope this helps.. Chandra
Thank you very much for this awesome document .It was very helpful to me .One quick question. I have implemented 11.5.10.2 on 9i db which come discoverer 4i .
1)can you please let me know if i can follow this document to upgarde it to 10g discoverer.? 2)i dont have stand alone server and i am planing to use a different mount point other than oracle server .may i know if i have install bi dsicovere 10g on existing 9i applnode or admin tier. i am just little worried if it messes up with any existing apache on appl node. Please advice at the earliest and thanks you very much for all the efforts you are putting to share with us your knowledge. Thanks Kalyan
Hi Kalyan, Thank you for the feedback.
Let me understand you correctly.. You are on Oracle 11i(11.5.10.2) and database as 9i. But when it comes to Discoverer part, you are still on Version 4i. If this is the situation, Yes.!! you can use this document as a reference. May be very patches may or may not required to apply. For this, you can just raise SR with Oracle and request them suitable prerequisite patch set for you. Once you reach the base patch level, then you are Good to Go.!! Let me know if you have any questgions.!! Regards, Chandra
Hi Anil,
I am working on upgradation from 11 to R12 on GL module.Could you help me in finding TOIs(Technical Functional).I am not able find TOIs information on metalink.Please see the document note for your reference- Upgrading to Release 12: 414710.1 Oracle General Ledger Documentation Resources, Release 12 Doc ID: Note:396911.1 Type: REFERENCE Last Revision Date: 16-FEB-2007 Status: PUBLISHED Transfer of Information (TOI) Online Training *First-time TOI users: follow these setup instructions Functional TOIs Provides information for users on how to set up and use the new features included in base Release 12. Includes: Benefits of new features from a business perspective Details on product dependencies and interactions Links to additional resources Technical TOIs Contains information about changes made to existing Release 11i features in base Release 12. Describes the changes made to database objects, profile options, forms, reports, programs, workflows, lookups, and seed data. Please upload some R12 docs on your portal in this regard.I will be very thankful to you. Regards, Greesh
Just saw your blog today. I have a few questions about discoverer upgrade also.
We are on client version discoverer 3.1* and e-Business Suite 10.5.10.2 on database 9i. We created our own view to feed discoverer. We are planning to upgrade our database to 10g and then upgrade discoverer to it latest version. I read several notes about upgrade discoverer. Most of them said to upgrade from 3i to 4i then discoverer 10s. But none of them mentioned if database can be 10g before upgrade discoverer. We have an unique situration which we must upgrade the database from 9i to 10g first, then upgrade discoverer next. Can you give me some advise and share your thought? Teresa
HI Chandra,
I m using discoverer 10g and i have register one report to oracle application .but it is showing error tht authentication failed(Default or specified schema containing EUL tables is inaccessible )" .. ..i have tried all the possible ways but still it is not coming can you plz tell me the soultion .....
HI Chandra,
I m using discoverer 10g and i have register one report to oracle application .but it is showing error tht authentication failed(Default or specified schema containing EUL tables is inaccessible )" .. ..i have tried all the possible ways but still it is not coming can you plz tell me the soultion .....
Hi Saurabh,
Do you able to access and run this report from discoverer? If yes, then there should be some problem with profile settings in your Oracle EBusiness suite(Apps). I replied earlier to this kind of question. Kindly refer to above posts. Thanks, Chandra
Hi Teresa Koo,
As you mentioned, upgrade path in your case is - 3i to 4i then discoverer 10s. I don't think you will have any problem with your database versions. You can proceed as per your plan.. first update database to 10g and then discoverer to it's latest version. In discoverer upgradation process, it overrides the EUL tables and/or create new ones. That's all. It doesn't matter in which DB version you are using etc. Regards, Chandra
This is further to Saurabh's reply..
Make sure that the DB user, which is holding EUL must have the following database privileges: • CREATE SESSION • CREATE TABLE • CREATE VIEW • CREATE SEQUENCE • CREATE PROCEDURE The database user must also have a default tablespace. (This must not be a temporary tablespace) Regards, Chandra
HI chandra ,
i m able to register my report to oracle application but when i run that roport then viewer4i is opening and there i m getting this msg = authentication failed(Default or specified schema containing EUL tables is inaccessible )" ...i have tried all the best ways ..can you plz guide em thgat wht is the problem and for tht wht is the solution.or if u can give me ur gmail id so i can talk to you and aclearify my doubts . reagrds saurabh
Hi
This article is awesome for discoverer reports. I develop reports in oracle reports and I am new in Discoverer report. Can you please send me fundamental & basic document on developing discoverer report. Pls mail me the document on dattap@msn.com Your Help will be appreciated. Thanks, Datta You must be logged in to a comment. Please register if you do not have an account yet.
|
Subscribe to this comment's feed
You have given a wonderfull and ultimate document for this ...this is really very helpfull.
I am also working on discoverer 10g but I am new to this only 4 months old .I want one help from your side .I am looking more n more different kind of report to work on ,so if you can provide me some example reports thru that i can practice in this with all he step details.so tht will be good for me ...and can i have your mail id ,coz i m having any problem then i can ask from you
with regards
saurabh srivastava