Tuesday Apr 15, 2014

Quarterly E-Business Suite Upgrade Recommendations: April 2014 Edition

We've previously provided advice on the general priorities for applying EBS updates.  This article will help you understand your top priorities for major upgrades to EBS and its technology stack components.

The following is a summary of our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified releases. 

Upgrade Recommendations for April 2014

  1. EBS 11i users should upgrade to 12.1.3 or 12.2.  Before upgrading, 11i users should be on the minimum 11i patching baseline.

  2. EBS 12.0 users should upgrade to 12.1.3 or 12.2.  Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline,

  3. EBS 12.1 users should upgrade to 12.1.3 or 12.2.

  4. Oracle Database 10gR2 and 11gR1 users should upgrade to 11.2.0.4 or 12.1.0.1

  5. EBS 12 users of Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0.

  6. EBS 11i users of  Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0.

  7. Oracle Internet Directory 10g users should upgrade to Oracle Internet Directory 11g 11.1.1.7.

  8. Oracle Discoverer users should migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA), or Discoverer 11g 11.1.1.7.

  9. Oracle Portal 10g users should migrate to Oracle WebCenter 11g 11.1.1.7 or upgrade to Portal 11g 11.1.1.6.

  10. All Windows desktop users should migrate from JInitiator and older Java releases to JRE 1.6.0_75 or later 1.6 updates or JRE 1.7.0_55 or later 1.7 updates.

  11. All EBS 11i, 12.0, 12.1, and 12.2 users must sign their environment's JAR files now.

  12. All Firefox users should upgrade to Firefox Extended Support Release 24.

  13. All EBS 11i, 12.0, 12.1, 12.2 users should apply the latest Critical Patch Update.

Related Articles

Tuesday Nov 19, 2013

Quarterly E-Business Suite Upgrade Recommendations: November 2013 Edition

We've previously provided advice on the general priorities for applying EBS updates.  This article will help you understand your top priorities for major upgrades to EBS and its technology stack components.

The following is a summary of our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified releases. 

Upgrade Recommendations for November 2013

  1. EBS 11i users should upgrade to 12.1.3 or 12.2.  Before upgrading, 11i users should be on the minimum 11i patching baseline.

  2. EBS 12.0 users should upgrade to 12.1.3 or 12.2.  Before upgrading, 12.0 users should be on the minimum 12.0 patching baseline,

  3. EBS 12.1 users should upgrade to 12.1.3 or 12.2.

  4. Oracle Database 10gR2 and 11gR1 users should upgrade to 11.2.0.4 or 12.1.0.1

  5. EBS 12 users of Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0.

  6. EBS 11i users of  Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0.

  7. Oracle Internet Directory 10g users should upgrade to Oracle Internet Directory 11g 11.1.1.7.

  8. Oracle Discoverer users should migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA), or Discoverer 11g 11.1.1.7.

  9. Oracle Portal 10g users should migrate to Oracle WebCenter 11g 11.1.1.7 or upgrade to Portal 11g 11.1.1.6.

  10. All Windows desktop users should migrate from JInitiator and older Java releases to JRE 1.6.0_65 or later 1.6 updates or JRE 1.7.0_45 or later 1.7 updates.

  11. All EBS 11i, 12.0, 12.1, and 12.2 users must sign their environment's JAR files now.

  12. All Firefox users should upgrade to Firefox Extended Support Release 24.

  13. All EBS 11i, 12.0, 12.1, 12.2 users should apply the latest Critical Patch Update.

    Related Articles

    Monday Jul 22, 2013

    Quarterly E-Business Suite Upgrade Recommendations: July 2013 Edition

    We've previously provided advice on the general priorities for applying EBS updates.  This article will help you understand your top priorities for major upgrades to EBS and its technology stack components.

    The following is a summary of our latest upgrade recommendations for E-Business Suite updates and technology stack components.  These quarterly recommendations are based upon the latest updates to Oracle's product strategies, latest support timelines, and newly-certified releases. 

    Upgrade Recommendations for July 2013

    1. EBS 11i users should upgrade to 12.1.3, or -- if staying on 11i -- should be on the minimum 11i patching baseline,

    2. EBS 12.0 users should upgrade to 12.1.3, or -- if staying on 12.0 -- should be on the minimum 12.0 patching baseline,

    3. EBS 12.1 users should upgrade to 12.1.3.

    4. Oracle Database 10gR2 and 11gR1 users should upgrade to 11gR2 11.2.0.3.

    5. EBS 12 users of Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0 or OAM 11gR1 Patchset 2 11.1.1.7.

    6. EBS 11i users of  Oracle Single Sign-On 10g users should migrate to OAM 11gR2 Patchset 1 11.1.2.1.0 or Oracle Access Manager 10g 10.1.4.3.

    7. Oracle Internet Directory 10g users should upgrade to Oracle Internet Directory 11g 11.1.1.7.

    8. Oracle Discoverer users should migrate to Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Business Intelligence Applications (OBIA), or Discoverer 11g 11.1.1.7.

    9. Oracle Portal 10g users should migrate to Oracle WebCenter 11g 11.1.1.7 or upgrade to Portal 11g 11.1.1.6.

    10. All Windows desktop users should migrate from JInitiator and older Java releases to JRE 1.6.0_51 or later 1.6 updates , or JRE 1.7.0_25 or later 1.7 updates.

    11. All Firefox users should upgrade to Firefox Extended Support Release 17.

    Related Articles

    Thursday Jun 06, 2013

    Discoverer 11.1.1.7 Certified with E-Business Suite

    Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.

    Discoverer graph screenshot

    Discoverer 11g (11.1.1.7) is now certified with Oracle E-Business Suite Release.  Discoverer 11.1.1.7 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.7.0, also known as FMW 11gR1 Patchset 6.  Certified E-Business Suite releases are:
    • EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher
    • EBS Release 12.0.6 and higher
    • EBS Release 12.1.1 and higher

    Certified Platforms

    Oracle Discoverer Release 11g R1 Patch Set 6 (11.1.1.7) is certified to run on any operating system for which Oracle WebLogic Server 11g is certified. For platform details, see:

    References


    Monday Apr 23, 2012

    Discoverer 11.1.1.6 Certified with E-Business Suite

    [Apr. 30, 2012 Update: Added IBM AIX on Power certification for EBS 12]

    Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.

    Discoverer graph screenshot

    Discoverer 11g (11.1.1.6) is now certified with Oracle E-Business Suite Release.  Discoverer 11.1.1.6 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.6.0, also known as FMW 11g Patchset 5.  Certified E-Business Suite releases are:
    • EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher
    • EBS Release 12.0.6 and higher
    • EBS Release 12.1.1 and higher

    Platforms certified for R12

    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (Red Hat Enterprise Linux 5)
    • Linux x86 (SLES 10)
    • Linux x86-64 (Oracle Linux 4, 5, 6 for EBS 12.1.1 and higher only)
    • Linux x86-64 (Red Hat Enterprise Linux 5)
    • Linux x86-64 (SLES 10)
    • Oracle Solaris on SPARC (64-bit) (9, 10, 11 for EBS 12.1.1 and higher only)
    • HP-UX Itanium (11.23, 11.31)
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • Microsoft Windows Server (2003, 2008* )
    • Microsoft Windows x64 (64-bit) (2008 R2 for EBS 12.1.1 and higher only)
    • IBM AIX on Power Systems (64-bit) 5.3, 6.1, 7.1)

    Platforms certified for Release 11i

    • Linux x86 (Oracle Linux 4, 5)
    • Linux x86 (Red Hat Enterprise Linux 5) 
    • Linux x86 (SLES 10)
    • Oracle Solaris on SPARC (64-bit) (9,10)
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003) 
    Other platform certifications still underway

    Certifications for other operating system platforms are still underway.  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.  

    References

    Friday Oct 28, 2011

    Premier Support ends December 2011 for Discoverer 10g, Portal 10g, Single Sign-On 10g, and others

    All Oracle E-Business Suite system administrators should check the Lifetime Support dates for their technology stack components regularly.  If you need a primer on how support policies for Fusion Middleware and Server Technologies components interact with E-Business Suite support dates, see:

    Table showing Fusion Middleware support timelines

    December 2011 is a critical threshold for several products used by Oracle E-Business Suite customers.  Premier Support ends on December 31st, 2011 for:

    1. Discoverer 10g
    2. Portal 10g
    3. Oracle Internet Directory 10g
    4. Single Sign-On 10g
    5. BPEL 10g
    6. Business Activity Monitoring 10g
    7. Business Intelligence Enterprise Edition 10.1.3.x
    8. WebCenter Suite 10.1.3.x
    9. Oracle Identity Manager 9.0.x

    Extended Support is not available for many these products -- check the Lifetime Support Policy for Oracle Fusion Middleware (PDF) for details.  All customers using these products should upgrade to the 11g equivalents as soon as possible.

    E-Business Suite 11i users running Oracle Single Sign-On 10g users should upgrade to Oracle Access Manager 10g.  Oracle E-Business Suite Release 12 users running Oracle Single Sign-On should upgrade to Oracle Access Manager 11g.

    Related Articles


    Thursday May 12, 2011

    Discoverer 11.1.1.4 Certified with EBS on AIX and Windows

    As yet-another follow-up to our original announcement, Oracle Discoverer 11.1.1.4 (Patchset 3) is now certified with Oracle E-Business Suite for five additional platforms.  Certified E-Business Suite releases are:

    • E-Business Suite 11i 11.5.10.2 + ATG RUP 7 and higher 
    • E-Business Suite 12.0.6 and higher
    • E-Business Suite 12.1.1 and higher
    Screenshot of Discoverer charts dialog box

    New platforms certified for R12

    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003, 2008 for EBS 12.1.1 only)
    • Microsoft Windows x64 (2008 R2 for EBS 12.1.1 only)

    New platforms certified for 11i

    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003)
    References
    Related Articles

    Monday Jan 31, 2011

    Oracle Discoverer (10.1.2.3) certified with EBS R12 on IBM: Linux on System z

    logo_ibm.jpg
    Oracle Discoverer 10g (10.1.2.3) is now certified with E-Business Suite Release 12 (12.1.2 or higher) on the IBM: Linux on System z platform. With this certification, Oracle Application Server 10g (10.1.2.3) is now fully certified with E-Business Suite on Linux on System z. Specifically, the following OracleAS 10.1.2.3 components are now certified for external integration with E-Business Suite R12 environments:
    • Single Sign-On 10.1.2.3
    • Oracle Internet Directory 10.1.2.3
    • Discoverer 10.1.2.3
    • Portal 10.1.4.2 (as included in OracleAS 10.1.2.3)
    • Web Cache 10.1.2.3
    The operating systems certified on this platform are:
    • Red Hat Enterprise Linux (RHEL) version 5 (64-bit)
    • Novell SUSE Linux Enterprise Server (SLES) version 9 (64-bit)
    • Novell SUSE Linux Enterprise Server (SLES) version 10 (64-bit)
    References
    Related Articles

    Sunday Aug 15, 2010

    Discoverer 11g (11.1.1.3) Certified with EBS on Twelve New Platforms

    Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data. 

    We certified Discoverer 11g version 11.1.1.3 (a.k.a. Patchset 2) with the E-Business Suite on six platforms last month.  Those certifications included Oracle Enterprise Linux, Red Hat Enterprise Linux, and SUSE Linux Enterprise Server.

    discoverer-screenshot-graphs.png
    As a follow-on to that original certification announcement, Oracle Fusion Middleware 11g Release 1 Discoverer version 11.1.1.3 is now certified with Oracle E-Business Suite Release 11i and R12 (12.0.x, 12.1.x) on a dozen additional platforms.

    New platforms certified for EBS 11i
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003)
    • Oracle Solaris on SPARC (64-bit) (9, 10)
    New platforms certified for EBS 12.0.x and 12.1.x
    • Linux x86-64 (Oracle Enterprise Linux 4, 5)
    • Linux x86-64 (RHEL 4, 5)
    • Linux x86-64 (SLES 10)
    • HP-UX Itanium (11.23, 11.31)
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003, 2008)
    • Oracle Solaris on SPARC (64-bit) (9, 10)
    References
    Related Articles

    Sunday Aug 08, 2010

    EBS Sysadmin Primer: Oracle BI Discoverer 11gR1

    [Editor: This is the fourth in a multi-part series from Nirzari Raichura, a senior member of our ATG Certification team, on essential Fusion Middleware concepts and tools for the EBS sysadmin]

    Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.  We certified Discoverer 11g version 11.1.1.3 (a.k.a. Patchset 2) with the E-Business Suite a few weeks ago.

    discoverer-screenshot-graphs.png
    With that recent certification, I think it's time to cover the installation and configuration of Discoverer 11g with E-Business Suite.  Discoverer 11g's integration with the E-Business Suite works identically to Discoverer 10g, and all of the business intelligence functionality continues to work as in previous Discoverer releases.  The major changes in this release come from Discoverer's installation dependencies on Oracle Application Server components.

    As with other Fusion Middleware components, Oracle Weblogic Server is the required application server for Discoverer 11g.  Like Oracle Identity Management 11g, Discoverer is loosely-coupled with Fusion Middleware's database and application server components. 

    Discoverer 11g Install comes bundled with Oracle Portal, Oracle Forms, and Oracle Reports, as in previous releases like Discoverer 10g.  Since it is loosely coupled with other Fusion Middleware components, you need to install a number of prerequisites prior to discoverer 11g install.

    All of these middleware components have to be at the same version level to work together.  I have summarized these dependencies in the following table:

    Table summarizing Discoverer 11g prerequisites
    References
    Related Articles


    Thursday Jul 01, 2010

    Discoverer 11g (11.1.1.3) Certified with E-Business Suite

    Oracle Business Intelligence Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.  We certified Discoverer 11g version 11.1.1.2 (a.k.a. Patchset 1) with the E-Business Suite earlier this year. 

    Discoverer 11g version 11.1.1.3 (a.k.a. Patchset 2) is now certified with Oracle E-Business Suite Release 11i and 12.

    discoverer-screenshot-graphs.png
    Certified EBS 11i Platforms
    • Linux x86 (Oracle Enterprise Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    Certified EBS 12 Platforms
    • Linux x86 (Oracle Enterprise Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    Other Platform Certifications Still Underway

    Our Applications Platforms Engineering team is still working on additional platforms, including Oracle Solaris on SPARC (64-bit), IBM AIX on Power Systems, HP-UX, and Microsoft Windows Server (32-bit).

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.   

    References
    Related Articles

    Monday May 03, 2010

    Discoverer 11g 11.1.1.2 Certified with EBS 12 on Five New Platforms

    [May 7 2010 Update: Removed Microsoft Windows Server 2008 reference]

    Oracle Fusion Middleware 11g Release 1 includes Oracle Discoverer.  Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.

    We certified Discoverer 11gR1 11.1.1.2 with the E-Business Suite Release 11i and 12 on Linux earlier this year.  Our Applications Platforms Group has just released five additional platform certifications for Discoverer 11.1.1.2 for Oracle E-Business Suite Release 12 (12.0.x and 12.1.x).

    discoverer-screenshot-graphs.png
    Certified EBS 12 Platforms
    • Linux x86-64 (Oracle Enterprise Linux 4, 5)
    • Linux x86-64 (RHEL 4, 5)
    • Linux x86-64 (SLES 10)
    • Oracle Solaris on SPARC (64-bit) (Solaris 9, 10)
    • HP-UX Itanium (11.23, 11.31)
    • HP-UX PA-RISC (64-bit) (11.23, 11.31)
    • IBM AIX on Power Systems (64-bit) (5.3, 6.1)
    • Microsoft Windows Server (32-bit) (2003)

    References
    Related Articles

    Tuesday Mar 23, 2010

    Discoverer 11g (11.1.1.2) Certified with E-Business Suite

    Discoverer is an ad-hoc query, reporting, analysis, and Web-publishing tool that allows end-users to work directly with Oracle E-Business Suite OLTP data.

    Discoverer 11g (11.1.1.2) is now certified with Oracle E-Business Suite Release 11i and 12.

    The latest release of Oracle Business Intelligence Discoverer 11g offers new functionality, including integration with Oracle Business Intelligence Enterprise Edition (OBIEE), published Discoverer Webservice APIs, integration with Oracle WebCenter, integration with Oracle WebLogic Server, integration with Enterprise Manager (Fusion Middleware Control) and improved performance and scalability.

    discoverer-screenshot-graphs.png
    Certified EBS 11i Platforms
    • Linux x86 (Oracle Enterprise Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    Certified EBS 12 Platforms
    • Linux x86 (Oracle Enterprise Linux 4, 5)
    • Linux x86 (RHEL 4, 5)
    • Linux x86 (SLES 10)
    Other Platform Certifications Still Underway

    Our Applications Platforms Engineering team is still working on additional platforms, including Oracle Solaris on SPARC (64-bit), IBM AIX on Power Systems, HP-UX, and Microsoft Windows Server (32-bit). 

    Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.   

    References
    Related Articles

    Friday Oct 16, 2009

    Using Oracle Application Server 10g with E-Business Suite (OpenWorld 2009 Recap)

    [Oct 19 2009 Update: If you registered for OpenWorld, here's a link to the OpenWorld On Demand page where you can download or listen to the live recording of this session as well as the presentation materials.]

    Every year I provide an OpenWorld update on the various ways that E-Business Suite users can use different Oracle Application Server 10g components.  This presentation covers many of the topics that I visit regularly on this blog, neatly summarizing them in a single package with the latest Fusion Middleware certified versions (and desupport notices) in one place:

    Architecture diagram showing sso oid and third-party LDAP integration with E-Business Suite

    This presentation covers:

    • A quick overview of the various Oracle Application Server 10g products that can be optionally integrated with the E-Business Suite, including:
      • Oracle Single Sign-On and Oracle Internet Directory
      • Oracle Access Manager and Oracle Identity Manager
      • Web Center and Portal
      • Oracle Business Intelligence Enterprise Edition and Discoverer
      • Web Cache
      • Oracle SOA Suite
      • Oracle Enterprise Manager
    • How Oracle Single Sign-On works with the E-Business Suite
    • How EBS users can be managed using Oracle Internet Directory
    • How EBS can be integrated via Oracle Single Sign-On with third-party authentication systems such as:
      • Windows Native Authentication via Kerberos
      • Netegrity Siteminder
      • IBM Tivoli Access Manager
      • PKI X.509v3 Digital Certificates
    • How EBS can be integrated via Oracle Internet Directory with third-party LDAP directories such as:
      • Microsoft Active Directory
      • Sun Java System Directory
      • Novell eDirectory
      • OpenLDAP
    Related Articles

    I've covered all of these topics already on this blog, with articles discussing the conceptual topics as well as new certification announcements.  See:

    Tuesday Jan 22, 2008

    Discoverer Cumulative Patchsets Now Certified for Apps 11i & 12

    If you're using Oracle Discoverer to analyze your E-Business Suite data, you know that we have always taken a very selective approach to the certification of Discoverer patches.  Our historical strategy has been to specify the smallest number of essential patches needed to use Discoverer with the E-Business Suite. With the introduction of Cumulative Patchsets for Discoverer, things have changed in an important way.

    Discoverer 10g Architecture:

    What Are Discoverer Cumulative Patchsets?

    Release vehicles for Discoverer bug fixes have evolved.  The latest iteration is the introduction of Cumulative Patchsets for Discoverer 10g.  As you might infer from their name, Cumulative Patchsets include the latest versions of all patches produced since the last major Discoverer release.  In other words, they include:
    • Patches contained in prior Cumulative Patchsets 
    • Latest versions of essential patches needed for compatibility with the E-Business Suite
    How Are Discoverer Cumulative Patchsets Different?

    The key difference boils down to the quality assurance stage.  One-time emergency patches for Discoverer are tested only to ensure that they fix a specific problem.  Very limited testing (if any) is performed to ensure that a given emergency patch doesn't introduce other issues in other areas.  Virtually no testing is done to check whether a given emergency patch conflicts with other emergency patches.

    Discoverer Cumulative Patchsets receive more systematic testing across the board to ensure compatibility with other emergency patches.  All of the released emergency patches are tested together as part of the release process for Cumulative Patchsets. 

    What About Compatibility with the E-Business Suite?

    As of today, E-Business Suite + Discoverer users have two certified options:
    1. Apply only the specific emergency patches needed for integrating Discoverer 10g in your E-Business Suite environments
    2. Apply the latest Discoverer 10g Cumulative Patchset. 
    This new certification policy applies to both E-Business Suite Release 11i and 12 environments.  You can apply Discoverer 10g Cumulative Patchset 3 or higher to your Apps environments. 

    The key phrase is, "or higher."  My E-Business Suite certification team will continue to certify selected Discoverer 10g Cumulative Patchsets, but you will no longer have to wait for our certification to be completed before applying a patchset that includes a fix for a bug that you're encountering.  The use of any Discoverer 10g Cumulative Patchset from 3 onwards is now fully supported with your E-Business Suite environment.

    References
    Related Articles

    Tuesday Oct 09, 2007

    Discoverer 10g 10.1.2.2 Certified with E-Business Suite

    [Oct 11 Update:  Added MS Win2k to list of certified platforms]

    The eagerly-awaited certification of Discoverer 10g 10.1.2.2 with E-Business Suite Release 11i and 12 was just released today.

    Discoverer 10g Architecture:

    Certified with E-Business Suite Release 11i

    Discoverer 10g 10.1.2.2 is certified with E-Business Suite Release 11i version 11.5.8 and higher.  The following platforms are certified:
    • Linux x86-32
    • Sun Solaris (SPARC)
    • HP-UX PA-RISC
    • IBM AIX
    • Microsoft Windows Server 2003
    • Microsoft Windows Server 2000
    Certified with E-Business Suite Release 12

    Discoverer 10g 10.1.2.2 is certified with E-Business Suite Release 12 version 12.0 and higher.  The following platforms are certified:
    • Linux x86-32
    • Linux x86-64
    • Sun Solaris (SPARC)
    • HP-UX PA-RISC
    • HP-UX Itanium
    • IBM AIX
    • Microsoft Windows Server 2003
    The Official Details

    Just to ensure that there's no confusion about the actual name of the patch, it is:

    • Oracle Application Server and Oracle Developer Suite 10g Release 2 (10.1.2) Patch Set 2 (10.1.2.2.0)
    The formal documentation for configuring the latest certified version of Discoverer 10g with the respective E-Business Suite releases can be found here:
    Related Articles

    Monday May 07, 2007

    OracleAS 10g Upgrade Paths

    [May 9, 2007 Update:  Corrected legend typo from OCSM to OCMS.  "OCMS" represents Oracle Communication & Mobility Server.  Elaborated on certification stance to remind readers that although OracleAS 10g 10.1.3 is part of Release 12's techstack, it can't be upgraded in place right now.]


    There are a lot of Oracle Application Server 10g releases.  I find it challenging to keep them straight myself, so I can only imagine how hard it must be for you to sort out upgrade paths between the various releases.  In response to popular demand at this year's Collaborate conference, here are my personal cheatsheet diagrams that I use to find upgrade paths between the various OracleAS 10g releases. 



    A Hand-Drawn Map Through the Woods

    A word of caution:  I've reviewed this information with our Oracle Application Server Release Managers, but these charts don't represent official documentation from Oracle Application Server Development.  In fact, I'm not sure that any single piece of official documentation captures this kind of information.  So, if there are any conflicts between what I show here and the official documentation, the latter prevails (and let me know, so I can fix my own diagrams).

    Distinguishing Between the Two Major OracleAS 10g Releases

    There are a couple of things you should bear in mind before reading these:


    1. The OracleAS 10g components used by the E-Business Suite -- Single Sign-On, Oracle Internet Directory, Discoverer, Business Intelligence, Portal, Web Cache, and Oracle Integration (including BPEL 10g) -- are released in the 10.1.2/10.1.4 codeline. 


    2. The OracleAS 10g 10.1.3.x codeline is the J2EE-only subset of OracleAS 10g.  These products are released on their own codeline and have a completely separate upgrade roadmap.  We don't certify any integrations between the E-Business Suite Release 11i and these products, although Release 12 includes 10.1.3 as its Java ORACLE_HOME.   I'm including my diagrams for this group, too, so you can see how the releases relate to each other.
    How to Read the Diagrams

    Here's a legend for reading the following diagrams:


    Updated Legend:


    If you haven't installed any OracleAS 10g releases before, you can start with any of the fresh install versions (marked with solid borders).  You can only apply incremental patchsets (marked with dashed borders) to an existing environment previously built with a fresh install version.

    Releases Useful for E-Business Suite Integrations

    The following chart shows upgrade paths between releases that are relevant to E-Business Suite sysadmins interested in using Oracle Application Server 10g components.  These components include Single Sign-On, Oracle Internet Directory, Discoverer, Business Intelligence, Portal, Web Cache, and Oracle Integration (including BPEL 10g and Business Activity Monitoring 10g).


    Oracle Application Server 10g Upgrade Paths:

    (click on the diagram for a larger version)

    Reading the chart, you can see that it's possible to upgrade from Oracle Application Server 10g 10.1.2.0.0 to the 10.1.2.2.0 Patchset.   Once you've done that, it's possible to install Portal 10.1.4.0.0 on top of that upgraded environment.

    A different path shows that it's possible to upgrade your OracleAS 10g 10.1.2.0.2 environment to the 10.1.2.2.0 Patchset. 

    Likewise, if you've installed OracleAS 10g 10.1.2.0.2 and upgraded that environment to use the latest Oracle Identity Management 10.1.4.0.1 release (marked as "IM"), you can upgrade that environment, in turn, to the 10.1.2.2.0 Patchset.

    The "Other" OracleAS 10g Release

    The diagram below is relevant for customers who are building their own J2EE applications using OracleAS 10g development tools, including Business Process Execution Language (BPEL), Business Activity Monitoring (BAM), Oracle Web Services Manager (OWSM), and Enterprise Service Bus (ESB).  With the exception of BPEL and BAM, E-Business Suite Release 11i users don't generally use any of the following releases, but I'm including this chart for the sake of completeness.  Release 12 includes OracleAS 10g 10.1.3 in its techstack but it can't be upgraded in place to a later version right now.


    J2EE Upgrade Paths:

    (click on the diagram for a larger version)

    A Final Word about Version Numbers

    For reasons too tortuous to go into here (and because I don't really understand them myself), Oracle Application Server version numbers don't necessarily correspond to the order in which a particular patchset was released.  They also don't mean that you can apply a higher version on top of an older version. 

    For example, the 10.1.3.2.0 Patchset was released after the 10.1.4.0.1 Identity Management (IM) release.  Since they're on separate codelines, you can't apply the 10.1.4.0.1 Identity Management release on top of the 10.1.3.2.0 Patchset.  That's not a meaningful combination since they're different products entirely. 

    When in Doubt, Contact Oracle Support

    It is not without some misgivings that I post this information here.  As is usually the case when wading into this area, these charts and their accompanying examples might have helped some of you but confused others. 

    Remember, I'm part of E-Business Suite Development, not Oracle Application Server Development.  In some ways, I'm a passerby in these parts, just like you.  So, if you do need more help in assessing the viability of a particular upgrade for your environment, it's advisable to go directly to the source:  Oracle Support is always your best option for getting a definitive answer to your questions.

    Related


    Monday Apr 23, 2007

    OracleAS 10g 10.1.2.2 Certified with Apps 11i

    The wait is over, at least for Linux platforms:  Oracle Application Server 10g 10.1.2.2 has been certified with the E-Business Suite Release 11i. 

    DMZ + OracleAS 10g + E-Business Suite Architecture:

    Just to ensure that there's no confusion about what's been certified, the full name of this patchset is:
    This latest certification includes the use of the following Oracle Application Server 10g components with Apps 11i:
    • Discoverer 10g
    • Portal 10g
    • Web Cache 10g
    Just for Linux... For Now

    This patchset has been certified for Linux platforms only

    We're working on the 10.1.2.2 certification for other platforms for E-Business Suite environments, but as usual, I don't have have a firm schedule for these other certifications or the other platforms yet.  You're welcome to monitor or subscribe to this blog for updates on the remaining certifications.

    Related


    Thursday Nov 09, 2006

    Waiting for Discoverer 10g 10.1.2.2 Certification with Apps 11i

    [Oct 9, 2007 Update:  As it turns out, there were some challenges identified that held up Discoverer 10.1.2.2 certification for a large number of operating system platforms.  The rest of the supported platforms have now been certified; see this latest announcement.]

    [Apr 24, 2007 Update:  Discoverer 10g 10.1.2.2 is
    now certified with the E-Business Suite Release 11i.]

    Well, some of you are really on the ball.  Even though it was just announced yesterday, I'm already getting emails about whether the newly-released Discoverer 10g 10.1.2.2 patch set can be used with the E-Business Suite Release 11i. 


    Discoverer 10g Architecture:



    The short answer is:  not yet.

    We're planning on this certification for Release 11i, but getting Release 12 out the door is our top priority right now.  As usual, I don't have have a firm schedule for this certification yet, but you're welcome to monitor or subscribe to this blog for updates on this certification.

    As part of our certification efforts, we'll ensure that our official Discoverer 10g interoperability documentation is updated with the latest recommended patch levels and integration procedures.  In the interim, we advise E-Business Suite customers to hold off on applying this patch to their Discoverer 10g environments. 

    Just to ensure that there's no confusion about the actual name of the patch, it is:

    • Oracle Application Server and Oracle Developer Suite 10g Release 2 (10.1.2) Patch Set 2 (10.1.2.2.0)

    Related
    The above is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle. 

    Monday Nov 06, 2006

    Using OracleAS 10g With The E-Business Suite

    Editor Jan. 12, 2007 Update:  Oracle Identity Management 10g 10.1.4.0.1 is now certified with the E-Business Suite. 

    No matter how hard I try to avoid it, my inbox always seem to pay for any time spent away, regardless of whether the time taken is for work or pleasure.  This is doubly true for time taken for conferences, since they tend to generate even more email.  That's life in the information era, I suppose.

    Apps 11i + OracleAS 10g Architecture:

    So, in a belated attempt to quell the tide from interested readers and conference goers, here's a pointer to the presentation materials for my session (S281709):
    Remember that the OpenWorld 2006 Content Catalog requires the following credentials to download conference materials:
    In my presentation you'll find coverage on:
    • Features and benefits of integrating the E-Business Suite with:
      • Single Sign-On & Oracle Internet Directory 10g
      • Discoverer 10g
      • Portal 10g
      • Web Cache 10g
    • Technical integration overview, covering:
      • Simple and advanced physical architectures
      • Logical architectures
    • Integration with third-party single sign-on and LDAP products
    • Release 11i application tier certification roadmap
    • Release 12 technology stack plans
    • Selected snapshots of customer architectures, including the use of :
      • Microsoft Active Directory
      • Windows Native Authentication (Kerberos)
      • Highly Available configurations
    Related

    Monday Sep 11, 2006

    Reminder: Discoverer 4i Desupport in October 2006

    Reminder:  the official desupport date for Discoverer 4i for E-Business Suite Release 11i users is at the end of next month -- October, 2006.

    Discoverer 10g Portlets Dashboard:

    If you haven't already upgraded to Discoverer 10g by now, you should do so immediately.  See the articles below for pointers to the official desupport notice and resources for upgrading your Apps 11i environment to use Discoverer 10g.

    Related

    Wednesday Aug 30, 2006

    Cloning Discoverer End-User Layers

    Given its utility, I'm highlighting a recent blog comment from Steve Fitzgerald, one of our Oracle BI specialists.  This was in response to our In-Depth: Cloning OracleAS 10g + E-Business Suite Environments article.

    Discoverer Export Wizard Screenshot:

    For the Discoverer users of the E-Business Suite, I will point your readers to "some old-fashioned elbow grease" to fill in the gaps. This will apply to
    import/export of an End-User Layer (EUL) at the database level.  It may not be necessary when cloning the entire database and not modifying the EUL, but will be if creating a DEV/TEST/PROD type clone. It might save a headache or two down the line :-).

    Discoverer recognizes EULs using unique reference numbers.  However, if you use the database export and import utilities to copy an EUL, the new EUL (including its reference number) will be identical to the original EUL.  When EULs have the same reference number, EUL consistency issues can arise if you do both of the following:
    • If you modify objects in both the original EUL and in the new EUL

    • Having modified objects in both EULs, if you then attempt to copy objects between the two EULs using the Discoverer Export Wizard and Import Wizard (or the Discoverer /export and /import commands)
    To avoid potential EUL consistency
    issues, run the eul5_id.sql script as the owner of the new EUL.  The eul5_id.sql script gives a new refererence number to the new EUL and thereby avoids any potential EUL consistency issues.

    Reference

    Monday Jul 10, 2006

    Decrypting Discoverer 10g Version Numbers

    [Editor Aug 31 Update:  References to Linux-specific patches 4241292 and 4576754 replaced with generic references]

    When I was younger, I thought I could change this world. Now I no longer think so but for emotional reasons I must keep on fighting a
    holding action.

    ~ Robert A. Heinlein

    If you've worked with Discoverer for any amount of time, you've probably noticed that there are a couple of different version numbers associated with each release.  I don't know about you, but I find this a bit confusing. 

    Discoverer 10g Architecture:

    A Holding Action

    Here's an attempt to help you decrypt and understand these version numbers.

    To understand this baroque situation, you need to distinguish between:
    • The Oracle Application Server 10g release, which represents the overall bundle that includes all underlying components like Single Sign-On, Portal, and Discoverer

    • The underlying detailed Discoverer 10g version number, which represents the specific version for the current executable installed

    • The version of Discoverer that you end up with after you've applied the interoperability patch required to integrate Discoverer with an E-Business Suite environment
    Released in Oracle Application Server 10g Version 10.1.2.0.0:

    Discoverer 10g Version 10.1.2.45.46C.

    If you want to integrate this release with the E-Business Suite, you need to apply the appropriate patch listed in Note 351721.1 for your platform.  This upgrades your Discoverer installation to:

    Discoverer 10g Version 10.1.2.45.48.

    Released in Oracle Application Server 10g Version 10.1.2.0.2:

    Discoverer 10g Version 10.1.2.48.18.

    If you want to integrate this release with the E-Business Suite, you need to apply the appropriate patch listed in Note 313418.1 for your platform.  This upgrades your Discoverer installation to:

    Discoverer 10g Version 10.1.2.50.05.

    Yes, yes... I know what you're thinking.  You might draw cold comfort from the fact that we enjoy this situation about as much as you do.  At least now you're armed with the same cheatsheet that we use internally for tracking this information.

    References

    Wednesday May 10, 2006

    In-Depth: Cloning OracleAS 10g + E-Business Suite Environments

    As much as I'd prefer to avoid the subject, it's time to turn to address a subject of much ongoing controversy, namely cloning.  Cloning an E-Business Suite environment is easy. Cloning an E-Business Suite environment that's been integrated with Oracle Application Server 10g is not quite as easy, unfortunately.

    What's Cloning?

    Cloning is the process of creating an identical copy of an already existing Oracle Applications system, including both the application-tier and database-tier.

    Why Clone?

    Reasons for cloning E-Business Suite environments include:
    • Creating a copy of the production system for testing updates
    • Migrating an existing system to new hardware
    • Creating a stage area to reduce patching downtime
    One of our more risk-averse customers informed me that they may create up to 15 clones of an E-Business Suite environment between the TEST and PRODUCTION rollout phases.

    The Easy Part

    The E-Business Suite Release 11i was architected to support cloning.  Experienced Apps DBAs know that the easiest way to create clones of their environments is to use the Rapid Clone utility introduced in 11.5.8.  Creating a n E-Business Suite clone is as simple as copying your application-tier and database-tier files to the new target system and then running the perl-based Rapid Clone (adcfgclone.pl) utility. 

    The Not-So Easy Part

    Oracle Application Server 10g was designed with different goals in mind.  Consequently, there are no Oracle tools available today to clone an entire OracleAS 10g environment in a single step.  In other words, OracleAS 10g does not have the equivalent of a Rapid Clone utility.

    In the absence of a single turnkey tool like Rapid Clone, creating clones of new OracleAS 10g environments is a more involved process.  Not impossible, mind you -- but definitely more involved.

    Things get even more complicated when an E-Business Suite environment is integrated with Oracle Application Server 10g

    Nothing But Net

    There are neither tools nor formal documents available from my group -- the Applications Technology Group -- or from Application Server Development, for cloning E-Business Suite environments that have been integrated with OracleAS 10g.

    This hasn't exactly been a pleasant state of affairs, especially if you happen to be the person responsible for telling customers about the absence of this documentation and tools.  No matter -- I'm tough; I can take it.

    But seriously, aside from this post, which will attempt to lay out general strategies for how you can fill in the gaps yourself through some old-fashioned elbow grease, there are no tools available to meet your comprehensive cloning requirements for combined OracleAS 10g + E-Business Suite environments today.  More on our future plans in a minute.

    Warning:  Trail Ahead Requires Exploration

    If you're willing to experiment a bit, the following are general guidelines to point you in the right direction.  Some customers and Oracle Consultants have used the following approaches to get the job done but have reported that there was some trial-and-error involved. 

    These are neither detailed nor comprehensive instructions.  The following should be attempted only by system administrators who have a solid understanding of the principles outlined in Metalink Note 261914.1.

    If you're going to experiment with these approaches, I strongly recommend that you take all sensible precautions, including backing up your environments at multiple stages, taking careful notes, and doing things in small, incremental steps to control your risk.

    Cloning Scenarios

    Assuming that you have an E-Business Suite environment that's been successfully integrated with OracleAS 10g, here are a few cloning scenarios that may apply to you:
    1. Create a clone of your Discoverer environment

    2. Create a clone of your Single Sign-On / Oracle Internet Directory environment
    3. Create a clone of your Portal environment 
    Creating a Clone of Your Discoverer 10g Environment

    If you've integrated Discoverer 10g with your E-Business Suite environment but have not chosen the Single Sign-On option, then the cloning process is relatively painless:
    1. Use Rapid Clone to create a clone of your E-Business Suite, including the application-tier and database-tier.  Remember that the E-Business Suite database already contains the Discoverer 10g End-User Layer.
    2. Create a fresh install of Discoverer 10g on your new server and point it to the End-User Layer in the cloned E-Business Suite instance.
    Creating a Clone of Your Single Sign-On / Oracle Internet Directory Environment

    If you've integrated Single Sign-On and Oracle Internet Directory 10g with your E-Business Suite environment, do the following:
    1. Use Rapid Clone to create a clone of your E-Business Suite, including the application-tier and database-tier.
    2. In your newly-cloned E-Business Suite instance, set the APPS_SSO_LDAP_SYNC profile option to "Disabled" at the site level (since there's no new Oracle Internet Directory instance to synchronize with yet).

    3. In your newly-cloned E-Business Suite instance, unlink all E-Business Suite users that were linked to the original Oracle Internet Directory 10g users (i.e. where FND_USER.USER_GUID is populated), since the those old links are no longer valid.  Those E-Business Suite users will need to be linked to their corresponding accounts in the as-yet non-existent new Oracle Internet Directory instance. 

    4. Create a fresh install of Single Sign-On and Oracle Internet Directory 10g on your new server.
    5. Assuming that you enabled bidirectional provisioning between the E-Business Suite and Oracle Internet Directory, do one of the following (but not all three):

      a) Redo your bulkload from the E-Business Suite into Oracle Internet Directory, reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.

      b) Export your LDAP namespace from your original Oracle Internet Directory instance into an LDIF file, and then import the LDIF file into the new Oracle Internet Directory instance.  Reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and (assuming that the Oracle Internet Directory accounts are identical to the E-Business Suite accounts) enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.

      c) Connect the original Oracle Internet Directory instance to your new Oracle Internet Directory instance via a connector, synchronizing the namespaces.  Reregister your E-Business Suite environment using the Bidirectional Provisioning Profile, and (assuming that the Oracle Internet Directory accounts are identical to the E-Business Suite accounts) enable the APPS_SSO_AUTO_LINK_USER profile option, and set the profile option APPS_SSO_LDAP_SYNC back to Enabled at site level.
    Creating a Clone of Your Portal Environment
    1. Portal requires a working Single Sign-On setup, so complete the previous section first.
    2. If you haven't already done so, create a fresh install of Portal 10g on your new server.

    3. Use the existing Portal 10g documentation to export your portal content and metadata from the original Portal instance.  Import that content into the new Portal 10g instance.
    4. Reregister the OAF Web Provider from your new E-Business Suite instance in your new Portal instance.
    Other Alternatives To Exploring On Your Own

    If you found the previous sections alarming and confusing, there are a few options:
    1. Hire an experienced consultant.  Check their references!  You don't want to pay someone for the privilege of training them -- including staff from Oracle Consulting.  There are some Oracle Consultants with experience in this area; email me if you'd like some contacts within Oracle.
    2. Wait for the formal documentation from the Applications Technology Group.  Be prepared to wait for a while, however.  A project proposal has been submitted for review but it has not been accepted or prioritized yet.  I'm continuing to press for the priority of this to be raised.  At present, there are no fixed schedules for this documentation yet.
    Good luck... and remember to take frequent backups.

    Sunday May 07, 2006

    In-Depth: Using Discoverer 10g with the E-Business Suite Release 11i

    [Oct 9, 2007:  Discoverer 10g 10.1.2.2 is the latest version certified for both E-Business Suite Release 11i and 12.  See this certification announcement for full details.]

    Oracle Discoverer is one of our most popular Oracle Business Intelligence tools for the E-Business Suite.  With a relatively small amount of training, it allows end-users to create Excel-like workbooks that answer business questions like, "How did sales of our Ultimate Titanium Turnip Twiddler improve over last year for the western region?"


    Discoverer 10 Screenshot:

    Discoverer Architectures in a Nutshell

    Discoverer is installed on a physically-standalone server or in a new ORACLE_HOME on an existing E-Business Suite Oracle9i Application Server 1.0.2.2.2 application server.

    Discoverer 10g Architecture:

    A prepackaged Discoverer End-User Layer for the E-Business Suite is installed in the E-Business Suite database.  This End-User Layer is a metadata repository contains business views that expose meaningful business concepts to end-users, shielding them from the complexity of the E-Business Suite data model.

    Discoverer workbooks provide users with graphical and tabular analytic options to analyze existing data to make business decisions.

    Summary of Discoverer Components
    • Power users use Discoverer Plus or Discoverer Desktop to create new workbooks
    • Regular business analysts use the browser-based Discoverer Viewer to analyze data
    • Casual end-users monitor business data via workbooks displayed in Discoverer Portlets in Oracle Portal
    • System administrators use the Windows-based Discoverer Administrator to manage the Discoverer End-User Layer
    What's Wrong with Discoverer 4i?

    Until recently, E-Business Suite users were restricted to using Discoverer 4i.  While still usable and useful, Apps DBAs know that Discoverer 4i has three major drawbacks:
    1. Discoverer 4i will be desupported in October, 2006
    2. Discoverer 4i can create heavy loads on your middle-tier and database
    3. It's elderly -- your users really want Discoverer 10g instead
    Upgrading to Discoverer 10g

    You can address all three of those drawbacks now:  Discoverer 10g is the latest release available, is easier to manage, and has a significantly smaller application-tier and database-tier operational profile than previous releases.

    We certified Discoverer 10g (10.1.2.0.2) with the E-Business Suite last year.  Although procrastination is often an effective workload management technique, there's no reason to postpone your installation or upgrade any longer:  this is a very worthwhile upgrade.

    Discoverer 10g is also one of the easiest components in Oracle Application Server OracleAS 10g to install with the E-Business Suite.  The process is straightforward:
    1. Install Discoverer 10g on a physically standalone server from your existing Discoverer 4i server

    2. Run the Discoverer 10g eulapi utility with the -AUTO_UPGRADE parameter.  This creates a copy of your existing Discoverer 4i, and then upgrades the copy to the Discoverer 10g End-User Layer format.  Your original Discoverer 4i End-User Layer remains untouched. 
    Minimal User Acceptance Testing Needed

    If you installed Discoverer 10g on a standalone server, you can run Discoverer 4i and 10g simultaneously.  This means that your end-users can compare their Discoverer 4i and 10g workbooks side-by-side. 

    User acceptance testing for your upgrade should take no time at all... and it's possible that your end-users may even be able to use your upgrade to justify that beautiful 21" LCD monitor to support this effort.  It's nice to make new friends, isn't it?

    Optional Integration with Oracle Single Sign-On & Oracle Internet Directory 10g

    Discoverer 10g can be installed in two different modes:

    1. The first and easiest method is to install it independently of Oracle Single Sign-On and Oracle Internet Directory 10g.  The advantage to this is that you can be running with Discoverer 10g extremely quickly, with minimal changes to your E-Business Suite environment.
    2. The second method requires your E-Business Suite environment to be integrated with OracleAS 10g and Single Sign-On first.  This admittedly takes more effort, but has the additional advantage of allowing Discoverer and the E-Business Suite to be integrated with third-party LDAP and single sign-on solutions.

    Integration with Oracle Portal

    If you go to the extra effort of integrating your E-Business Suite environment with OracleAS 10g and Portal, your end-users will be able to publish their workbooks and create executive dashboards like this:

    Discoverer 10g Portlets Dashboard:

    Getting a Lexus For Free

    I'm not a licencing professional, but my understanding is that Discoverer maintenance fees cover the latest versions... for free.  In other words, if you're licenced for Financials Intelligence or any other E-Business Suite Business Intelligence product, you should be able to upgrade to Discoverer 10g with no extra costs.

    If that applies to you, then this is equivalent to being able to trade in your rusty Toyota Accord for a free new Lexus. 

    If you don't know what your licencing terms are, I'd recommend that you contact your Oracle account manager for more information.

    Good luck with your upgrade.

    Related Articles:

    Monday May 01, 2006

    In-Depth: Using OracleAS 10g with E-Business Suite Release 11

    Editor Jan. 12, 2007 Update:  Oracle Identity Management 10g 10.1.4.0.1 is now certified with the E-Business Suite. 

    As promised earlier, this post represents the first of a series of in-depth discussions on using OracleAS 10g with the E-Business Suite Release 11.


    It is now possible to integrate the E-Business Suite Release 11i with OracleAS 10g, for the use of Single Sign-On, Oracle Internet Directory, Portal, Discoverer, Web Cache and Oracle Integration.

    Integrated, Not Upgraded

    The key concept is that Release 11i may be integrated with OracleAS 10g.  The existing E-Business Suite application server, Oracle9i Application Server 1.0.2.2.2, is not upgraded to OracleAS 10g; the two instances are integrated together in a loosely-coupled architecture like this:

    Simple OracleAS 10g + E-Business Suite Architecture:

    Remember that if you want to upgrade your existing E-Business Suite 9iAS application server to OracleAS 10g, you'll be able to do that in Release 12.  For Release 11i, it's always going to be an integration-based architecture.

    One Server or Two?

    The diagram above shows the existing E-Business Suite 9iAS services and the new external OracleAS 10g services running on two different physical servers.  That's our recommended configuration, particularly if you're planning to upgrade from Discoverer 4i to 10g (due to the former's obsolescence in Oct 2006).

    It's possible to install OracleAS 10g on the same physical server where 9iAS is installed... if you have sufficient resources available on that box.  You must install OracleAS 10g in a separate ORACLE_HOME.  OracleAS 10g cannot be installed into the existing E-Business Suite 9iAS ORACLE_HOME.

    What Are The Main OracleAS 10g Components?

    This is something new to E-Business Suite sysadmins, so you may have to review this a few times to let it sink in.

    Architecturally, you should think of OracleAS 10g as being comprised of middle-tier (application tier) products and infrastructure services.  Middle-tier products include Portal, Discoverer, and Oracle Integration.

    The OracleAS 10g Infrastructure includes Single Sign-On, Oracle Internet Directory, and the actual LDAP database where user credentials are stored.  In general, all of the OracleAS 10g middle-tier products share the same OracleAS 10g Infrastructure.

    Middle-tier products like Portal have content such as portal page definitions, pictures, downloadable files, and so on.  This content has metadata, too, which determines how content is displayed and accessed.  All of this product-specific content and metadata is stored in a database called the OracleAS 10g Metadata Repository.

    Installing OracleAS 10g (Over and Over)

    As you'd expect, there are several variants of how these components can be installed.  These variants are documented in excruciating detail in the OracleAS 10g Installation Guide for your operating system platform.  Arm yourself with coffee before reading the Installation Guide - it can be heavy going for a first-time reader.

    In general, the first component to be installed is the OracleAS 10g Infrastructure.  If you're starting out simply (which I'd recommend), you can install the OracleAS 10g Metadata Repository at the same time, like this:

    Simple OracleAS 10g Infrastructure:

    Advanced sysadmins have the option of installing the Infrastructure and Metadata Repository in different places and on different servers, like this:

    Split OracleAS 10g Infra + MR:

    If all you're interested in using is Single Sign-On and Oracle Internet Directory with the E-Business Suite, you're done on that front (for now). 

    If you're interested in using Portal or other middle-tier components like Oracle Integration, you need to run the Oracle Unversal Installer and install those components separately.  As part of their installation, you'll need to point those components to the OracleAS 10g Infrastructure and OracleAS 10g Metadata Repository that you created earlier.

    OracleAS 10g Runs Independently

    Now that your OracleAS 10g environment is installed, you should test it to ensure that it runs without any issues.  You should be able to log in to this environment, create and modify users, start up Portal, create custom portal home pages, and so on. 

    Connecting OracleAS 10g to the E-Business Suite

    Once your OracleAS 10g instance is proven to be working, you will proceed with connecting it to your E-Business Suite environment.  Doing so will enable your E-Business Suite to use Single Sign-On, Portal, and Discoverer services running on the OracleAS 10g instance. 

    I'll cover each of those options in subsequent "In-Depth" postings later this week.

    Related Articles:

    Monday Apr 17, 2006

    Some Good Discoverer Blogs

    Since we're on the topic, if you're a Discoverer user, you'll find a wealth of interesting information in the following blogs:
    Given that the E-Business Suite neighborhood in the blogosphere is sparsely-populated at present, I plan to assemble an annotated blogroll.  If you have a E-Business Suite-related blog, please drop me a line with a pointer to it.

    [Editor Update:  My annotated blogroll has since been created and now has several other interesting blogs linked.]

    Discoverer 4i To Be Desupported by October, 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).

    Related Article:

    About

    Search

    Categories
    Archives
    « April 2014
    SunMonTueWedThuFriSat
      
    1
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
       
           
    Today