Wednesday Apr 08, 2009

WebCenter 10g 10.1.3.4 Certified with E-Business Suite Release 12

Oracle Web Center is a suite of development tools that can be used to build web-based applications using technologies such as SOA, JSR-168, and WSRP.  The Oracle WebCenter Framework allows you integrate E-Business Suite Release 12 portlets into a custom web-based application.

We certified Web Center 10.1.3.3 with Oracle E-Business Suite Release 12 last May.  Following up on that certification train, Web Center 10.1.3.4 is now certified with Apps 12 (12.0.4 and higher).

CreateApps: Screenshot of Oracle JDeveloper showing the initial dialog box for creating a new WebCenter application

For full details, see:

Certified Platforms

  • Linux x86-32
  • Linux x86-64
  • Sun Solaris SPARC
  • HP-UX PA-RISC
  • HP-UX Itanium
  • IBM AIX
  • Microsoft Windows 2003

Related Articles

Sunday Mar 29, 2009

Premier Support for OC4J 10.1.3.3 ends in July 2009

Java logo

Oracle E-Business Suite Release 12 includes OracleAS 10.1.3 Oracle Containers for J2EE (OC4J) for running its Java-based content.  We certified Apps 12 with OracleAS 10.1.3.3 in January 2008 and with OracleAS 10.1.3.4 in December 2008. 

You should be aware that the OracleAS 10.1.3.3 grace period will end in July 2009.  After July 2009, you will still be able to download existing OracleAS 10.1.3.3 patches, but new patches will be issued only for the latest 10.1.3.4 release.

If you're running your E-Business Suite environment on OracleAS 10.1.3.3, I would strongly recommend planning an upgrade to the most-current certified OC4J release. As of today, that's OracleAS 10.1.3.4.  Future readers coming across this article should refer to this blog's one-page Certifications summary for the latest certified configurations.

Want To Know More About Support Policies?

The Server Technologies support policies have recently changed in some important ways.  I've discussed the E-Business Suite implications of those changes in these articles: 

Your Thoughts?

I don't represent Server Technologies organization (I'm in E-Business Suite Development), but I'm happy to pass on your thoughts and feedback about Oracle's support policies to management teams in those groups.  Feel free to post a comment below or send me a private email.

Related Articles

Saturday Mar 28, 2009

Premier Support for Forms 10.1.2.2 Ends in April 2009

Oracle Fusion Middleware Forms Logo

Oracle E-Business Suite Release 12 includes OracleAS Forms & Reports 10g as part of its technology stack.  EBS 12.0.0 shipped with Forms 10.1.2.0.2.  We certified Forms 10.1.2.2 with EBS 12 in August 2007 and with Forms 10.1.2.3 in November 2008.

You should be aware that the Forms 10.1.2.2 grace period will end in April, 2009.  After April 2009, you will still be able to download existing Forms 10.1.2.2 patches, but new patches will be issued only for the latest 10.1.2.3 release.

If you're running your E-Business Suite environment on Forms 10.1.2.2, I would strongly recommend planning an upgrade to the most-current certified Forms release. As of today, that's Forms 10.1.2.3.  Future readers coming across this article should refer to this blog's one-page Certifications summary for the latest certified configurations.

Want To Know More About Support Policies?

The Server Technologies support policies have recently changed in some important ways.  I've discussed the E-Business Suite implications of those changes in these articles: 

Your Thoughts?

I don't represent Server Technologies organization (I'm in E-Business Suite Development), but I'm happy to pass on your thoughts and feedback about Oracle's support policies to management teams in those groups.  Feel free to post a comment below or send me a private email.

Related Articles

Wednesday Mar 25, 2009

Secure Enterprise Search 10.1.8.4 Certified with EBS 12

Oracle Secure Enterprise Search (SES) 10.1.8.4 is now certified with Oracle E-Business Suite Release 12.  If you missed our late-2007 announcement about this certification, here's a recap of the basics.  Secure Enterprise Search (SES) provides new search capabilities for R12: Apps users can search for E-Business Suite data using a unified search engine, with search results displayed based upon their Applications responsibilities. Searches can be performed on structured and unstructured data. Notably, search results respect multi-level security, including:

  • Role-based access control (RBAC) functional and data security
  • Product-specific security policies

Oracle Secure Enterprise Search screencap: Screen capture of Oracle Secure Enterprise Search 10g with Assets Inquiry screen for E-Business Suite Release 12.0.3

For example, an authorized E-Business Suite user could use the search screen above to search for "Assets" in "Northpark," yielding the following results:

SES search results: Oracle Secure Enterprise Search 10g sample search results for an E-Business Suite Release 12.0.3 search

Prerequisites

  • Oracle E-Business Suite Release 12 version 12.0.4 and higher

  • Oracle Secure Enterprise Search 10.1.8.4

Supported Platforms

Secure Enterprise Search may be optionally installed on standalone external server and integrated with EBS 12.  The operating system platforms supported for the standalone Secure Enterprise Search instance are:

  • Linux x86 (Oracle Enterprise Linux 4, Red Hat Linux 3, 4; SUSE Linux Enterprise Server 9)

  • Linux x86-64 (Oracle Enterprise Linux 4, Red Hat Linux 3,4; SUSE Linux Enterprise Server 9)

  • Solaris SPARC (Solaris 8, 64-bit; Solaris 9, 64-bit; Solaris 10, 64-bit)

  • HP-UX PA-RISC (11.11 64-bit; 11.23 64-bit)

  • AIX 5L Based Systems (AIX 5.2 ML01, 64-bit; 5.3, 64-bit

  • HP-UX Itanium 11i v2 (11.23)

  • Windows Server (2003 - all editions)

References

Tuesday May 06, 2008

E-Business Suite + Fusion Middleware Best Practices Center Launched

If you've been watching Oracle's ERP strategy, you'll notice that there's been a profound shift in emphasis over the last few years.  The E-Business Suite is now acknowledged to be only one part of your organization's overall software environment, and we're investing heavily in integration technologies such as Service-Oriented Architecture (SOA).

FMW Best Practices Screenshot: Screenshot of Oracle E-Business Suite + Fusion Middleware Best Practices Center

My colleagues in the Fusion Middleware group have just launched a new Oracle E-Business Suite & Fusion Middleware Best Practice Center.  This site has step-by-step tutorials covering topics that include:
They've also started a blog that already has a rich set of deep technical articles covering topics such as:
If you're already developing SOA-based applications involving the E-Business Suite, or just curious about what's now possible with our latest tools, this site is worth a look.

Related Articles

Tuesday Apr 22, 2008

New Whitepaper: E-Business Suite Development Using OAF & ADF

Customers, partners and system integrators often develop extensions to Oracle E-Business Suite (EBS) applications. Such extensions have traditionally used the same technology stack (Forms or OA Framework) that the original EBS application was built with.  This ensured that the extensions are fully compatible with the rest of the installed EBS applications.

R12 OAF Techstack: Block diagram showing the OA Framework Technology Stack for E-Business Suite Release 12

With the emergence of the next generation Fusion Middleware technology stack, especially the Application Develoment Framework (ADF), an increasingly-common question is whether to use OAF or ADF to develop E-Business Suite Release 12 extensions.

Our E-Business Suite Applications Technology group has released a long-awaited whitepaper addressing this question. This whitepaper discusses the similarities, differences and overlaps between the OAF and ADF stacks. 

If you're considering these technology stacks for your Apps R12 extensions, I'd strongly recommend reviewing this whitepaper:
Related Articles

Sunday Apr 20, 2008

Comparing OEM Data Masking and AMP Data Scrambling Features

[Editor note: Sep 3 2010:  The embedded table (the final figure in the article) lists a line that reads, "Pre-Defined Masking Configuration for EBS."  This is an error.  It should read, "Pre-Defined Masking Algorithms for EBS."]

My last article spurred a flood of questions about the difference between Oracle Enterprise Manager (OEM) Data Masking and the Application Management Pack's (AMP) Data Scrambling features.

What is Data Masking?

The act of anonymizing customer, financial, or company confidential data to create new, legible data, which retains the original data's properties, such as its width, type, and format.

Datamasking:

The Oracle Enterprise Manager Data Masking Pack uses an irreversible process to replace sensitive data with realistic looking but scrubbed data based on masking rules.  This ensures that original data cannot be retrieved, recovered or restored.

This feature was introduced in Oracle Enterprise Manager 10gR4.

Datamasking-fig:

Major features of Data Masking

  • Maintains Automatic Database Referential Integrity when masking primary keys
    • Implicit - database enforced
    • Explicit - application enforced
  • Provides out-of-the-box Data mask format library
  • View sample data before masking
  • Application masking templates using the Export Mask Definition capability
  • Define once; execute multiple times

Datamasking-Formats:

Masking processes are traditionally slow because they perform table updates.  The Data Masking Pack takes an advantage of built-in optimizations in the database to disable database logging and runs in parallel to quickly create a masked replacement for the original table.

Distinguishing OEM Data Masking and AMP Data Scrambling

The OEM Data Masking is a part of Database Management Pack.  Data Scrambling is a part of the Application Management Pack for E-Business suite, a plug-in for the Oracle Enterprise Manager.

Database Scrambling can only be performed when cloning E-Business Suite environments using the Applications Management Pack.

Here's a detailed comparison of the OEM Data Masking and Applications Management Pack Data Scrambling capabilities:

Distinction-Masking-Scrambling-1: Matrix comparing OEM Data Masking features with Application Management Pack Data Scrambling features

Related Articles


Thursday Mar 27, 2008

Oracle Single Sign-On and Oracle Internet Directory 10g 10.1.4.2 Certified with Release 11i

Looks like another good week for certification announcements. Close on the heels of announcing Database 11gR1 certification,  we are announcing the certification of Oracle Single Sign-On and Oracle Internet Directory 10g 10.1.4.2 with Oracle E-Business Suite Release 11i. Existing 11i environments using earlier version of SSO & OID can be upgraded to the 10.1.4.2 Patch Set. Customers on 10.1.2.0.2 version of SSO & OID must first upgrade to 10.1.4.0.1 and then apply the 10.1.4.2 Patch Set.

10142Patchset:

Certified Operating System Platforms

  • Linux x86-32
  • Sun Sparc Solaris
  • HP-UX PARisc
  • IBM AIX
  • Microsoft Windows 2003

The latest certified configuration is documented in:

Related Articles

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

Tuesday Sep 11, 2007

Latest JDeveloper 10g with OA Extension Now Available for Apps 12

[Nov 6, 2007 Update:  A newer version for Apps 12.0.3 has just been released.  See this article for details]

A new update has just been released for Oracle JDeveloper 10g with OA Extension for E-Business Suite Release 12 environments.  The latest release of JDeveloper and the Oracle Applications Extension allows developers to build OA Framework-based applications for Apps 12.0.2 and ATG RUP 2.

Expenses R12 Screenshot:

The latest update is released as:
This update requires:
See the patch's README for more details about prerequisites, installation, and configuration.

A plethora of information on personalizing and extending OA Framework-based applications for E-Business Suite Release 12 can be found in this documentation roadmap:
Related

Tuesday Sep 04, 2007

Using Forms + Reports 10g Builders with Release 12

[Oct 19, 2007 Update:  A bug prevented the execution of any Oracle Reports on 10.1.2.2 on the IBM AIX platform.  Patch 6341158 has been released to resolve this issue]

Good things always seem to happen while I'm out of the office.  This may be a good incentive for me to spend more time on vacation (even though my groaning inbox begs to differ).

Expenses R12 Screenshot:

While I was out, a new Note was published externally:
The newly-published Note 444248.1 provides the rest of the picture outlined in this companion document:
How Do These Notes Relate?

We now have a complementary set of documents.  Once you've upgraded your E-Business Suite Release 12 environment with the latest version of Forms & Reports 10g using Note 437878.1, you can configure your development environment using the guidelines and procedures in the newly-published Note 444248.1.

The latter Note is full of tips on:
  • Running the Forms 10g Builder
  • Running the Reports 10g Builder
  • Setting up an R12 environment with a separated Developer Suite 10.1.2 instance
  • Compiling forms and reports

Related

Monday Aug 13, 2007

Upgrading Release 12 to Forms 10.1.2.2

I'm pleased to announce that you can now upgrade your Release 12 environments to use the latest version of Forms & Reports 10g.  This caps off a string of recent new certifications, including Single Sign-On 10.1.4.0.1, Portal 10.1.4.1, and Web Cache 10.1.2.2.

Expenses R12 Screenshot:

This update allows Release 12 users to take advantage of the latest stability, performance, and security updates in the latest Forms & Reports 10g 10.1.2.2 release. 

Supported Platforms
  • Linux x86-32
  • Linux x86-64
  • Sun Sparc Solaris
  • HP-UX PARisc
  • HP-UX Itanium
  • IBM AIX
  • Microsoft Windows 2003
For More Information
Related


Sunday Aug 12, 2007

WebCache 10g (10.1.2.2) Certified with Apps 11i and 12

Oracle Web Cache 10g (10.1.2.2) is now certified with E-Business Suite Release 11i and 12.  E-Business Suite administrators may use the latest version of Oracle Web Cache 10.1.2.2 to provide caching, reverse-proxy, and failover and surge protection for their environments.

E-Business Suite WebCache: Diagram showing Oracle Web Cache in front of an E-Business Suite environment

Supported Configurations

Release 11i
  • E-Business Suite 11.5.9 or higher
  • Web Cache 10g 10.1.2.2
Release 12
  • E-Business Suite 12.0.0 or higher
  • Web Cache 10g 10.1.2.2

Upgrading to Web Cache 10.1.2.2

E-Business Suite users can upgrade to the latest version by installing Oracle Application Server 10g 10.1.2.0.2, and then applying the Oracle Application Server 10g Release 2 Patch Set 2 (10.1.2.2).

For More Information
Related

Saturday Aug 11, 2007

Portal 10g (10.1.4.1) Certified with Apps 11i and 12

Oracle Portal 10g (10.1.4.1) is now certified with E-Business Suite Release 11i and 12.  Apps 11i and 12 users can integrate their environments with custom portals built with Oracle Portal.

Applications Navigator Portlet R12:


Supported Configurations

Release 11i
  • E-Business Suite 11.5.8 and higher
  • Portal 10g 10.1.4.1
Release 12
  • E-Business Suite 12.0.0 and higher
  • Portal 10g 10.1.4.1
Upgrading to Portal 10g 10.1.4.1

E-Business Suite Release 11i and 12 customers can get to Portal 10g 10.1.4.1 in the following ways:
  1. Install Portal 10.1.4 and upgrade it to 10.1.4.1 by applying the Oracle Application Server 10g Release 2 Patch Set 2 (10.1.2.2)
  2. Install Portal 10.1.2.0.2, upgrade it to Portal 10.1.4, and then upgrade to 10.1.4.1 by applying the Oracle Application Server 10g Release 2 Patch Set 2 (10.1.2.2)
For More Information
Related

Friday Aug 10, 2007

Using Single Sign-On 10g (10.1.4.0.1) with Release 12

Single Sign-On & Oracle Internet Directory 10g (10.1.4.0.1) are now certified with Oracle E-Business Suite Release 12.  Existing Release 12 environments using Single Sign-On & Oracle Internet Directory 10g 10.1.2.0.2 may be upgraded to the latest version.

Release 12 OracleAS 10g Integration: Diagram showing integration between E-Business Suite Release 12 and a standalone Oracle Application Server 10g (OracleAS 10g) server Diagram showing integration between E-Business Suite Release 12 and a standalone Oracle Application Server 10g (OracleAS 10g) server

Applications Release 12 users can configure their environments to delegate user authentication to an external Single Sign-On 10g 10.1.4.0.1 instance.  In this optional configuration, Single Sign-On validates E-Business Suite user credentials against an external Oracle Internet Directory 10g 10.1.4.0.1 instance.[Read More]

Friday Aug 03, 2007

End of Premier Support for Portal and Login Server 3.0.9

We deliver new patches and fixes for products while they're covered by Premier Support.  As of July 31, 2007, Premier Support has officially ended for Portal 3.0.9, Login Server 3.0.9, and Oracle Internet Directory 3.0.1 for E-Business Suite customers. 
Portal Upgrade Paths:

In addition, in December 2006 Sun has since desupported JDK 1.3, the prerequisite for Portal and Login Server 3.0.9.  So, there's no putting it off any longer:  it's really time to upgrade now.

Possible Prerequisites for Future ATG Rollups?

If Oracle's desupport of Portal 3.0.9 combined with Sun's desupport of JDK 1.3 aren't sufficient to convince you that it's time to upgrade, here's one more thing to consider:  future ATG Rollups may include dependencies that force existing Portal 3.0.9 users to upgrade to Portal 10g.

We are considering updating our ATG Family Pack Rollup packaging to include the heretofore-separate Single Sign-On 10g integration code.  The latter patch has been released separately for customers interested in integrating their environments with Oracle Application Server 10g. 

If the Single Sign-On 10g integration code is included in a future ATG Family Pack Rollup, say -- strictly hypothetically --ATG RUP 7, then existing Portal 3.0.9 users will have to upgrade to Portal 10g before they can apply the latest ATG Family Pack Rollup. 

It is expected that Release 11i environments using FND_USER-based authentication (instead of Login Server 3.0.9) will be unaffected by this change in packaging.  That is, if you're using FND_USER-based authentication today, you should be able to continue doing so even if the SSO 10g integration code is included in the latest ATG Family Pack Rollup.  But (and this is an important "but") this is subject to our internal validations of this configuration. 

Bottom Line:  Upgrade to Portal 10g Now

Regardless of what transpires with our inchoate changes to future ATG Family Pack Rollups, the following conclusion is inescapable:  if your Apps 11i environment is still on Portal 3.0.9, you should start your upgrade to Portal 10g immediately.

Related

Friday Jun 29, 2007

Apps Management Pack for E-Business Suite on Solaris Now Available

The Applications Management Pack for the E-Business Suite was originally available only for Linux platforms.  For those of you waiting for the latest generation of our systems management tool to be ported to your operating system, some good news:  it's now available for Sun Solaris.

Enterprise Manager Screenshot:

The Application Management Pack for Oracle E-Business Suite extends Oracle Enterprise Manager 10gR3 Grid Control to help monitor and manage Applications environments.  This latest version can be used to manage the following environments:
  • E-Business Suite Release 12.0 and higher
  • E-Business Suite Release 11.5.10 with ATG RUP 4 or higher
Free downloads for Oracle Enterprise Manager 10g Grid Control are available, but it's important to note that the Application Management Pack for Oracle E-Business Suite is a separately licensed product.  If you'd like to do a hands-on evaluation of this latest release, you should give your Oracle account team a call.

Tuesday May 22, 2007

Demantra, OracleAS 10.1.3 and the E-Business Suite

There's been a recent surge of questions asking whether the E-Business Suite can be used with Oracle Application Server 10g 10.1.3 and Demantra, one of our new product family members. 

Demantra Demand Management screenshot:

I'm not a Demantra specialist, but from an Apps architectural perspective, the short answer is:  yes.  There are a few things to remember about this integration:
  1. The E-Business Suite Release 11i's application-tier runs on Oracle9i Application Server 1.0.2.2.2 only.  It must stay at this level.  It may not be upgraded to either Oracle Application Server 10g 10.1.2.x or 10.1.3.x.
  2. The E-Business Suite Release 11i can be integrated with an external server running Oracle Application Server 10g 10.1.3.x.  There are no restrictions on integrating Apps 11i with OracleAS 10.1.3.x.  We have not certified this configuration but it's supported.  Remember that there's an important distinction between certification and support.
  3. Alternately, if you have sufficient capacity on your existing E-Business Suite application server, you can install Oracle Application Server 10g 10.1.3.x in a separate ORACLE_HOME on an existing E-Business Suite server.
  4. You then install Demantra on top of the external Oracle Application Server 10g 10.1.3.x environment.  The standalone Demantra environment then connects to the E-Business Suite environment.
  5. Demantra is an Oracle SSO-enabled partner application, too.  If your E-Business Suite environment has been integrated with Single Sign-On 10g and Oracle Internet Directory 10g, you can integrate that combined environment with Demantra, too, to provide Single Sign-On capabilities across Apps and Demantra.
Possible Java Runtime Engine Conflicts

Demantra runs on the latest Sun Java Runtime Engine (JRE) plug-in on the desktop.  Oracle E-Business Suite's Forms-based products run on Oracle Jinitiator on the desktop.  Depending on how your end-users run Demantra, there may be conflicts between these two Java plug-ins, notably if the same users wish to access the E-Business Suite's Forms-based content at the same time that they're running Demantra. 

If so, there's light on the horizon:  we're still in the process of certifying the native Sun JRE plug-in with the E-Business Suite.  Once that certification is complete, E-Business Suite users can use the native Sun JRE plug-in instead of Jinitiator, eliminating any conflicts.

If your organization wishes to deploy Demantra now, before the E-Business Suite's certification of the native Sun JRE plug-in is complete, you may wish to register in our E-Business Suite Early Adopter Program.  I'm still accepting customer nominations for this Early Adopter Program; for details, see:
References

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. 

Wednesday Nov 08, 2006

Mod_plsql Not Supported in E-Business Suite Release 12

[July 11, 2008 Update:  Many readers have raised questions about why mod_plsql was removed from Release 12. Others have asked what to do about their mod_plsql-based Apps 11i customizations and extensions when upgrading to R12.

George Buzsaki,our preeminent E-Business Suite architect, has put together an excellent new whitepaper that addresses these topics.  For a pointer to that whitepaper, see this article.]

[June 4, 2008 Update:  It should be stressed that the Oracle E-Business Suite is distinct from Oracle Application Server.  Oracle E-Business Suite Development chooses to use specific Oracle Application Server components in the E-Business Suite technology stack.  These decisions by E-Business Suite Development should not be interpreted to represent the release policies or plans for Oracle Application Server. 

It must be emphasized that Oracle is fully committed to supporting
mod_plsql as part of Oracle Application Server and as part of the Oracle Database distribution into the indefinite future.]

One of my degrees is in psychology -- cognitive science, to be exact -- so it's interesting when that world intersects with my present work in the IT industry.  A landmark text in grief counseling is Elizabeth Kubler-Ross' On Death and Dying, in which she described the general grieving process as proceeding in roughly five stages:
  • Denial and isolation
  • Anger
  • Bargaining
  • Depression
  • Acceptance
Floyd Teter has astutely pointed out that OpenWorld's news of mod_plsql's demise in Oracle E-Business Suite Release 12 may trigger this process for some of you.  So, to help you through the first stage of denial, on behalf of the Applications Technology Group, I'll officially reiterate that here:
  • Release 12 will not support the use mod_plsql
Switching to Oracle Application Framework in Release 12

If you're planning on upgrading to R12 and you currently have Release 11i customizations that depend on mod_plsql, you would be well-advised to do the following things immediately:
  1. Inform your management about this upcoming change

  2. Prepare a comprehensive inventory of all of your existing 11i mod_plsql customizations and dependencies

  3. Review R12 capabilities with your business users and stakeholders, to see if your customizations are still needed

  4. If yes, budget time in your R12 upgrade cycle for:
  • A test install of an R12 demonstration environment to support a functional review with your business users, to see if the customizations can be further weeded out by relying on native R12 functionality

  • Training yourself and your developers in the Oracle Application Framework (OAF)

  • Doing the actual conversion from mod_plsql to the OA Framework model
For obvious reasons, the Release 12 Oracle Application Framework documentation is not available publicly yet.  In the meantime, it can't hurt to review the existing OA Framework documentation for Release 11i, which will help you get a general sense of the migration process. 

We plan to release some specific technical guidance on preparing your custom development for R12 soon; watch this space for that announcement.

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. 

Wednesday Oct 18, 2006

Portal 10.1.4 Certified for the E-Business Suite

It's taken a lot longer than we expected, but Portal 10.1.4 has just been certified with the E-Business Suite Release 11i.

Portal 10g Screenshot:

There are a number of interesting new features in Portal 10.1.4, including the Oracle Portlet Factory, JSR-168 and WSRP support, Struts support, BPEL integration, a new Instant Portal, and others. 

The Portal 10.1.4 certification with the E-Business Suite requires the latest Oracle Applications Framework Web Provider, which might lead to other prerequisites such as Applications Technology Group (ATG) Family Pack H Rollup 4 (11i.ATG_PF.H RUP 4, Patch 4676589).  Other prerequisites will depend on your existing configuration.  I'd recommend reviewing the documentation below carefully.

References:

Wednesday Sep 13, 2006

Using OracleAS 10g and Apps in an Enterprise Configuration

I've been receiving a number of questions about integration architectures from customers who have multiple ERP systems.  These long-suffering system administrators are getting awfully tired of maintaining overlapping user namespaces for each of these systems separately. 

Now that all Oracle applications, including the E-Business Suite, have been certified with Oracle Application Server 10g, it's possible to use a single instance to provide identity management services across your enterprise.

Shared Enterprise Oracle Application Server 10g:

Shared OracleAS 10g Services Across the Enterprise

As shown above, you can now install a single instance of Oracle Application Server 10g and use it to provide unified identity management and portal services to applications across your enterprise.  Applications that delegate user authentication to this central Oracle Application Server 10g instance are called partner applications.

The E-Business Suite, PeopleSoft, and Oracle Collaboration Suite can all be registered as partner applications with Oracle Application Server 10g.

Users log onto Oracle Single Sign-On 10g, which provides access to all registered partner applications.  A single user definition is maintained centrally by Oracle Internet Directory 10g, which is much more efficient (and safer) than maintaining overlapping user namespaces in each of the individual partner applications.

If you're so inclined, you can create a portlet in Oracle Portal that links to specific functions in each of the partner applications.

Integration with Third-Party Identity Management Systems

The centrally-shared Oracle Application Server 10g instance can be integrated with third-party identity management systems.  I've covered this integration already, so rather than repeating myself here, see this article if you'd like more details about how that works:
Taking No Chances

As the axiom goes, if you put all of your eggs in one basket, you'd better watch that basket carefully.  The same goes for centralizing all of your identity management and portal services.  If that system goes down, the outage now affects all registered partner applications. 

High Availability Shared Enterprise Apps Architecture:

To avoid those awkward morning-after discussions with your executives, you should ensure that your central Oracle Application Server 10g environment is:
  • Scaled to handle the combined peak loads of all partner applications
  • Has failover capabilities for both the application tier as well as the database tier
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

Thursday Aug 24, 2006

DMZs, SSL and RAC for OracleAS 10g + Release 11i

I know that many of you have been waiting for this announcement for a long time, so it's a real pleasure (and relief) to be able to tell you that Build 4.0 is finally here.


A new version of the OracleAS 10g integration with the E-Business Suite has been released for use with ATG Family Pack H Rollup 4.  This long-awaited integration patch, also known as Build 4.0, includes full support for three additional configurations:  DMZs, RAC, and SSL.

Demilitarized Zones and OracleAS 10g Integrations

In prior releases, there were a number of challenges to integrating an OracleAS 10g instance with an E-Business Suite environment deployed in a demilitarized zone (DMZ) configuration with multiple web entry points.  Some awkward workarounds existed, but they were incomplete, technically clumsy, and didn't work consistently in all circumstances.

With this latest release, full support for OracleAS 10g + E-Business Suite + DMZ configurations is now available.  This release allows you to register multiple E-Business Suite application servers (e.g. internal and external Oracle9i Application Server 1.0.2.2.2 instances) with an OracleAS 10g and Single Sign-On instance, supporting the proper redirection of traffic to the appropriate server after authentication. 

This means that architectures like this are now fully supported:

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

Registration with SSL-Enabled Oracle Internet Directory Hosts

In prior releases, it wasn't possible to register your E-Business Suite environment with an Oracle Internet Directory host deployed in a Secure Sockets Layer (SSL) configuration.

In this latest release, if your Oracle Internet Directory host is configured for SSL-enabled LDAP operations, you can use wallets in Oracle Wallet Manager to secure all LDAP operations.

Oracle Internet Directory Integration with RAC-Enabled Release 11i Databases

In prior releases, if your E-Business Suite database was configured to use Real Application Clusters (RAC), the synchronisation of user information between Oracle Internet Directory and FND_USER was handled by a specific database server in your RAC cluster.

If that database node failed, the synchronisation of user attributes between Oracle Internet Directory and the E-Business Suite wouldn't failover to other database server nodes.  Updates of user information in either direction would be suspended until the designated RAC database node came back online.

In this latest release, the E-Business Suite RAC service name is used when registering the Release 11i instance with Oracle Internet Directory.  All user synchronisation events are handled by the E-Business Suite RAC cluster now, so if a given RAC node fails, synchronisation of user information will continue as long as other RAC nodes are still running.

References

Thursday Aug 17, 2006

In-Depth: Synchronizing Oracle HRMS with OID

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

I've now devoted several articles to managing E-Business Suite users with Oracle Internet Directory 10g.  But what about situations where you need to manage Oracle Human Resources employees in Oracle Internet Directory?  Or create E-Business Suite accounts automatically for new employees?  That's where the Oracle HR Agent comes into the picture.


Oracle HR Agent Screenshot:

Users vs. Employees

For starters, let's distinguish between users and employees:

USER:  An E-Business Suite user is someone who needs to be able to log into Apps.  That user might need to file expense reports, view her payslip, or file purchase requisitions.  All E-Business Suite users have userids and records in the FND_USER repository, and have associated responsibilities that govern what the functions and data that they can access.

EMPLOYEE:  An employee is someone whose information is managed by the Human Resources module in the E-Business Suite.  Oracle Human Resources tracks information like employee numbers, manager hierarchies, and other personally identifiable information like birthdates.

Employees aren't Necessarily Users



Not all employees are users, and vice versa.  For example, a major retailer might use the E-Business Suite's Human Resources modules to manage employee information for their cashiers, but those cashiers may not be authorized to log into the E-Business Suite at all.


When Worlds Overlap

From an organizational standpoint, this distinction makes a lot of sense.  The HR department manages employees, and the IT department manages E-Business Suite accounts. 

But what happens when those worlds overlap?  Following the example above, what about a scenario where the cashiers are permitted to view their payslips via the Self-Service Human Resources module?

In this scenario, the same person would be represented in two places:
  1. In the Human Resources module
  2. In the Apps FND_USER repository
For E-Business Suite environments that aren't integrated with Oracle Internet Directory, user records need to be individually maintained in each location.

Creating Employee Entries in Oracle Internet Directory

It's possible to use the Oracle Internet Directory Human Resources connector to push employee information from Oracle HR to Oracle Internet Directory.

HRMS to OID:

You can export a subset of employee data from Oracle Human Resources into Oracle Internet Directory.  The connector includes both a prepackaged integration profile and an Oracle Human Resources agent that handles communication with Oracle Internet Directory.

You can schedule the Oracle Human Resources connector to run at any time, configuring it to extract incremental changes from the Oracle Human Resources system. You can also set and modify mapping between column names in Oracle Human Resources and attributes in Oracle Internet Directory.

Exportable HR Attributes

There's a long list of HR employee attributes that you can send to Oracle Internet Directory, including:
  • First name, last name
  • Title
  • Sex
  • Date of birth
  • Employee number
  • Email address
  • Others...
Making A Round Trip

If you recall from a previous article, you can synchronize user information between Oracle Internet Directory and the E-Business Suite's FND_USER like this:

OID to FND_USER Sync:

Therefore, it's possible for employee information to make a round-trip like this:

HR to OID to FND_USER:

Not In the Opposite Direction

This architecture would support a business flow where a new employee is registered in E-Business Suite Human Resources by the HR department.  That employee's information is then propagated via Oracle Internet Directory to FND_USER, where an IT administrator grants the appropriate Apps responsibilities to the user.

The opposite direction is not supported.  It is not possible to have an employee created in Oracle HR based upon a new user entry in Oracle Internet Directory.

Useful for You?

I've heard anecdotal reports that this is a common use case, but actual customer sightings of this in the wild have been rare.  If you're using this setup now, or are interested in using this setup, please drop me a line; I'd be very interested in hearing about your requirements.

Related

Tuesday Aug 15, 2006

Oracle Identity Management 10g (10.1.4.0.1) and Release 11i

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

Oracle Identity Management 10g (10.1.4.0.1) is now available for download.  This release marks a milestone release for Oracle Identity Management, offering significant enhancements and fixes in terms of performance, stability, integration, usability and platform support.


E-Business Suite Certification Underway

The Applications Technology Group is certifying E-Business Suite Release 11i with Oracle Identity Management 10.1.4.0.1 now.  I don't have firm schedules for the certification yet, but feel free to subscribe to this site if you'd like to be automatically notified when it's completed. 

In the meantime, Oracle Identity Management 10g (10.1.2.0.2) is the latest certified version for E-Business Suite Release 11i customers.

Friday Aug 11, 2006

COREid, Thor, Xellerate and Others

[March 19, 2009 Update: Clarified text to emphasize that integrations of OAM, OIM, OVD, ESSO, and OWSM with EBS are supported by the Identity Management group.]

[August 11, 2008 Update: It's technically feasible to integrate the E-Business Suite with Oracle Single Sign-On. Oracle Access Manager (a.k.a. COREid) may, in turn, be integrated with Oracle Single Sign-On to provide additional authentication and integration options. If Windows Native Authentication and Kerberos are also used with this combination -- namely, E-Business Suite, Oracle Single Sign-On, and Oracle Access Manager -- the combined length of the redirected URLs may exceed web browser limits and user authentication will fail. Oracle recommends against the use of this particular combination of technologies for production environments.

[Editor:  Apparently there are some unusual packaging and licencing particulars around Oracle Enterprise Single Sign-On and Oracle Web Services Manager.  This article has been updated to reflect these oddities.]

In our recent string of acquisitions, Oracle has made a number of purchases in the identity management space.  These have been rolled into the Oracle Identity and Access Management Suite of products.  The obvious question probably occurs to you:  can you use these with the E-Business Suite?

Oracle Identity Suite Architecture:

What's in Oracle Identity and Access Management?

First, it's important to be very clear about which products are included in this suite.  These are:
Aug 14 Update:  Within minutes of publishing this article, Oracle staff who pay attention to things like licencing excitedly informed me that the following products have "special" licencing terms.  This being a technical blog and not a marketing one, I'm going to blithely sidestep this discussion.  If you really have burning questions about licencing, I'm sure your neighbourhood Oracle account team will be happy to fill you in on these products:

Supported with the E-Business Suite


All of the Oracle Identity and Access Management Suite products shown above are supported by the Oracle Identity Management group for use with the E-Business Suite Release 11i and the upcoming Release 12.  In other words, you may follow the generic Oracle Identity Management documentation for integrating the above products with E-Business Suite environments; questions about that generic documentation should be directed to Oracle Identity Management Support.

In addition, the E-Business Suite has special certified integrations with Oracle Single Sign-On and Oracle Internet Directory.  The Applications Technology Group has produced specific documentation and patches for these configurations for E-Business Suite customers.

What Happens If You Run Into a Problem?

For an extensive discussion about the distinction between supported vs. certified configurations, see Certification & Support for Third-Party Products.  We support more configurations than we actually certify.

If you run into a problem when using any of the products above with E-Business Suite environments, you have two options for getting support:
  1. Log a Service Request against the E-Business Suite

    Applications Support Engineers will attempt to isolate the problem. 

    If the problem's root cause lies in the E-Business Suite, such as Oracle Financials, then the Service Request will be handled by an Applications Support Engineer.

    If the problem is isolated to a product in the Identity and Access Management Suite, then the Service Request will be routed to an Identity Management Support Engineer.
  2. Log a Service Request against the Identity and Access Management Suite

    Identity Management Support Engineers will attempt to isolate the problem.

    If the problem's root cause lies in an Identity and Access Management Suite product, such as Oracle Identity Manager, then the Service Request will be handled by an Identity Management Support Engineer.

    If the problem is isolated to the E-Business Suite, then the Service Request will be routed to an Applications Support Engineer. 
Passing the Buck

All Oracle products should work together.  If you find yourself in a situation where your Service Request is being bounced around, don't just suffer through it.  Call Oracle Support and escalate to a Duty Manager, who can ensure that your SR isn't treated like the proverbial buck that no one wants to handle.

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. 

Thursday Aug 10, 2006

Aliases, Maiden Names and Nicknames

You know, I've never really understood how nicknames are worked out.  It makes sense that Jon can be short for Jonathon.  But how do you get from John to Jack?  And from William to Bill?


Regardless of the mystifying linguistic antecedents, you can accomodate this state of affairs for user management with the combination of Oracle Internet Directory and the E-Business Suite.

Linking Apps Users with OID Users

If you've been following our series of articles on using Single Sign-On and Oracle Internet Directory 10g with the E-Business Suite, you know that we link user accounts in Oracle Internet Directory with their corresponding user accounts in the E-Business Suite, like this:

Link Apps Account to OID 2:

Every user in Oracle Internet Directory has a Global Unique Identifier (GUID).  The E-Business Suite stores this Global Unique Identifier in its own user directory (FND_USER), creating a unique link between the two accounts.

Using Different Names in Apps and OID

Since the users are linked by a numerical Global Unique Identifier, it doesn't matter if their actual userids in the two namespaces don't match exactly.  In addition to accomodating those mystifying nicknames, aliases, and maiden names, this is useful for integrating the E-Business Suite with LDAP directories with different userid naming conventions.

In the example above, the user's ID in Oracle Internet Directory is "john.smith", whereas his userid in Apps is "jsmith".  The user logs on to Single Sign-On using his "john.smith" userid and transparently passes through to Apps with responsibilities tied to his "jsmith" account. 

Assuming Multiple Identities

One of our largest E-Business Suite customers -- one of the world's largest multinationals -- has centralized their global business services.  In this business model, a single purchasing agent acts as the purchaser for different geographic organizations. 

Each of these different organizations have their own business setups, so separate user accounts have been created for each organization.  A given purchasing agent logs into the E-Business Suite using different accounts.

The brute-force approach to handling this is to require the purchasing agent to remember different passwords for each account.  A more elegant solution is to link his Oracle Internet Directory userid to each of the different Apps accounts, like this:

Link Multiple Apps Accounts:

Using this approach, the purchasing agent logs into Single Sign-On using his "john.smith" account.  One of the linked accounts is flagged as the default account, and he can easily switch to the other accounts without having to log out and back in again with a different userid.

Not in the Other Direction

This "one-to-many" link is fully supported with both Release 11i and 12.  In other words, you can link a single Oracle Internet Directory account to multiple Apps accounts.

"Many-to-one" links are not supported, however.  In other words, it's not possible to link multiple Oracle Internet Directory accounts with a single Apps account.

Integration with Third-Party LDAP Directories

You might have a third-party LDAP whose userid naming conventions differ from your E-Business Suite environment.  If so, your best approach is to ensure that Oracle Internet Directory is populated with those third-party userids, like this:

About

Search

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