Tuesday, July 22, 2014

Still here

Hi everyone
I am still here. Just wanted to let you know that I am still in the business of working with Discoverer even though Oracle recently announced that it would be de-supported. If you need help just get in touch.

Also, you may not be aware but we have updated our Discoverer Handbook with the latest 11g version. You can find it on Amazon

Monday, June 10, 2013

New OTN Interface

If you are a user of OTN (Oracle Technology Network) you should have noticed that there is a new interface. I think its pretty cool. What do you think?

Wednesday, June 27, 2012

My Oracle Support Interface Change

If you are a use of My Oracle Support you should have received notification regarding a change to the user interface. As of July 13, 2012 Oracle will be retiring their Flash-based interface and replacing it with an improved HTML interface that has added functionality.

There is a CALL TO ACTION regarding this change. If you follow the link you will be directed to a page that will describe the changes in detail and advise what you have to do in order to take advantage of the new user interface.

Thursday, June 14, 2012

Warning concerning Java 7 and E-Business Suite


This notification is being posted at the request of Oracle Corporation

All E-Business Suite desktop administrators must disable the JRE Auto-Update for their end users immediately to stop it updating to Java 1.7.

URGENT BULLETIN:  Disable JRE Auto-Update for All E-Business Suite End-Users.
The following link from my fellow blogger Steve Chan explains more:

So why is this required?
If you have Auto-Update enabled, your JRE 1.6 version will be updated to JRE 7.  This may happen as early as July 3, 2012.  This will definitely happen after Sept. 7, 2012, after the release of 1.6.0_35 (6u35).

Oracle Forms is not compatible with JRE 7 yet.  JRE 7 has not been certified with Oracle E-Business Suite yet.  Oracle E-Business Suite functionality based on Forms -- e.g. Financials -- will stop working if you upgrade to JRE 7.

There is also a known issue with WebLogic 10.3.6 and JDK 1.7 and you must use JDK 1.6 for that. I will be posting shortly on this issue.

Seems to me therefore that until further notice, even for Discoverer, but definitely for E-Business Suite that you must stay on Java 1.6 

Been a while

Hello everyone, I know it has been a little while since my last posting but I am here, alive and kicking and gearing up to get back into blogging.
In case you are not aware, I am in the process of updating my Discoverer Handbook to the latest 11g version of the product. Watch for more postings very soon.

Monday, May 16, 2011

CP10 for Discoverer 10.1.2.3

Just wanted to let you know that on April 18, 2011, Oracle has released CP10 for 10.1.2.3. You will find it on MetaLink as patch number 11674847. When compared to CP9, 10 bugs have been fixed.


Note: when you download the readme from MyOracle, from CP9 Oracle has placed the new bug fixes at the top of the list.

So far this cumulative patch has been released for the following platforms:
  • IBM AIX on POWER systems (64-bit)
  • Linux x86
  • Microsoft Windows 32-bit
  • Oracle Solaris on SPARC (64-bit)
If you are upgrading to CP10 from any patch level prior to CP4 then JDBC patch patch p4398431_10105_GENERIC.zip for bug 4398431(release 10.1.0.5) needs to be installed before you apply CP5.

Note: please take a look at the comments posted below and if anyone has any experience of CP10, good or bad, please let me know.

Thursday, May 12, 2011

CP9 for Discoverer 10.1.2.3

Just wanted to let you know that on January 11, 2011, Oracle has released CP8 for 10.1.2.3. You will find it on MetaLink as patch number 10233659. When compared to CP8, 6 bugs have been fixed.


Note: when you download the readme from MyOracle, from this release Oracle has started to place the new bug fixes at the top of the list.

So far this cumulative patch has been released for the following platforms:
  • HP-UX Itanium
  • HP-UX PA-RISC (64-bit)
  • IBM AIX on Power Systems (64-bit)
  • Linux x86
  • Microsoft Windows 32-bit
  • Oracle Solaris on SPARC (64-bit)
If you are upgrading to CP9 from any patch level prior to CP4 then JDBC patch patch p4398431_10105_GENERIC.zip for bug 4398431(release 10.1.0.5) needs to be installed before you apply CP5.
This patch needs to be applied to all Oracle Homes, i.e. Infrastructure home as well as all related midtier homes.
Bug 4398431 - HANG WHEN RETRIEVING A CONNECTION FROM THE IMPLICIT CONNECTION CACHE

CP2 for Discoverer 11g released

Just wanted to let you know that on January 11, 2011, Oracle released CP2 for Discoverer 11.1.1.2.0. This is applicable for both Discoverer Plus and Viewer. You will find it on My Oracle Support (formerly MetaLink) as patch number 10409451. There are 5 bugs fixed in this cumulative patch.

So far this cumulative patch has been released for the following 5 platforms:
  • Linus x86
  • Linux x86-64 bit
  • Microsoft Windows (32-bit)
  • Microsoft Windows x64 (64-bit)
  • Oracle Solaris on SPARC (64-bit)

Configuring Discoverer Plus to pre-populate login credentials

Have you ever noticed how Discoverer does not remember your user name, database and EUL whenever you log out and wished there was a way to make it do so?

Well, there is a way but you need to add some parameters to your URL to make it do so.

Let's assume the following:
  • User Name is michael
  • Database is prod
  • EUL is eul5_us
All you need to do is to add switches to your URL and then save it in your favorites. The switches you need are:
  • For User Name  use us=
  • For Database use database=
  • For EUL use eul=
Putting this altogether I can use: http://myserver.com:7779/discoverer/plus?us=michael&database=prod&eul=eul5_us

If you are using E-Business Suite you can also pre-populate this setting too by adding: lm=applications, like this:

http://myserver.com:7779/discoverer/plus?lm=applications&us=michael&database=prod&eul=eul5_us

Running Plus in IE8

If you are experiencing issues running Discoverer Plus inside Microsoft IE8 the following comments may help.

So far, I have noticed that under no circumstances with Discoverer run in IE8 when it is configured to use JInitiator. If your company has enabled Discoverer to run primarily using JInitiator try adding the following parameter to your URL:  _jvm_name =sun

Your URL should look something like this: http://myserver.com:7778/discoverer/plus?_jvm_name=sun

Now all this assumes that your Discoverer administrator has enabled a more recent Sun Java than Discoverer comes installed with, namely 1.4.0_06

Should you find that you have this version installed please upgrade the server Java and try again.

Tuesday, October 26, 2010

CP8 for 10.1.2.3 released

Just wanted to let you know that on October 5, 2010, Oracle has released CP8 for 10.1.2.3. You will find it on MetaLink as patch number 9694503. When compared to CP7, 10 bugs have been fixed.

So far this cumulative patch has been released for the following platforms:
  • IBM AIX on Power Systems (64-bit)
  • Microsoft Windows 32-bit
  • Linux x86 (works for both 32 bit and 64 bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86 (32-bit)
If you are upgrading to CP8 from any patch level prior to CP4 then JDBC patch patch p4398431_10105_GENERIC.zip for bug 4398431(release 10.1.0.5) needs to be installed before you apply CP5.

This patch needs to be applied to all Oracle Homes, i.e. Infrastructure home as well as all related midtier homes.

Bug 4398431 - HANG WHEN RETRIEVING A CONNECTION FROM THE IMPLICIT CONNECTION CACHE

The following posting has been updated:

Followers