Discoverer 4i To Be Desupported by October, 2006
By Steven Chan (Oracle Development) on Apr 17, 2006
Discoverer 4i has long been desupported for the general public, but E-Business Suite users have had a special exception for a few years. That exception is ending this year.
For those of you who haven't upgraded to the latest Discoverer 10g release in your E-Business Suite environments, you should start planning to do so immediately. Discoverer 4i has entered the final phase in the obsolescence cycle, and will be desupported by the end of October, 2006.
The good news is that there really isn't any reason why you should hesitate to upgrade. Discoverer 10g is faster, more efficient, and has more analytic features for your end-users.
For example, Discoverer 4i's automatically-generated SQL statements tended to be very long, and would result in extremely heavy database queries, which in turn would return massive datasets, weighing down your application server. You probably already know this from reviewing your server logs, and from the number of helpdesk calls from annoyed users whose workbooks are taking hours to run.
The Discoverer 10g release has an automatic SQL trimming feature that intelligently removes unneeded columns. Depending on the workbook, this can result in significant improvements in the responsiveness of workbook queries, and lighten up your Discoverer and database server load, as well.
For system administrators, there's even more good news: the upgrade process is extremely straightforward. When you install Discoverer 10g, it will make a copy of your existing Discoverer 4i End-User Layer and upgrade the copy to 10g. If you've installed Discoverer 10g on a physically separate server, you can then run both 4i and 10g simultaneously against their respective End-User Layers.
This means that end-users can compare their workbooks for the two releases side-by-side, which should make User Acceptance Tests a snap.
Here's the official Discoverer 4i Obsolescence Notice (Metalink Note 337576.1).
Here's the documentation on upgrading to Discoverer 10g in your E-Business Suite environment (Metalink Note 313418.1).