« August 2006 | Main | October 2006 »

September 2006 Archives

September 1, 2006

Sneak Preview: Apps Tech Track at OpenWorld

I'm puzzled by the absence of a detailed list of sessions on the official OpenWorld website.   The agenda is absolutely stuffed this year.  In addition to my own three sessions, here's a sneak peek at some of the Applications Technology sessions that I think will be worth attending.

Oracle OpenWorld 2006 logo:

Extremely Noteworthy (I'll be attending these myself)

  • Technology Directions for Oracle Applications:  Cliff Godwin (S281377)
  • Oracle E-Business Suite Technology Updates:  Lisa Parekh (S280814)
  • Oracle E-Business Suite Customers: 10 Things You Can Do Now to
    Prepare for Oracle Fusion Applications:  Nadia Bendjedou (S281651)
  • Deep Dive: Oracle E-Business Suite Release 12 New Technology Stack:  Ivo Dujmovic (S281383)
Focus on Release 12
  • Oracle Application Framework (OAF): Architecture, Personalization,
    and Extensibility in Oracle E-Business Suite Release 12:  Sara Woodhull
    (S281402)
  • Oracle E-Business Suite Release 12: Installation and Cloning Enhancements: Robert Farrington, Andrew Rist (S281403)
  • Oracle E-Business Suite System Management: Release 12 New Features:  Biju Mohan (S281397)
  • Oracle E-Business Suite Release 12: Process, Integration, and Eventing:  Mark Craig (S281412)
  • Oracle Workflow: Oracle E-Business Suite Release 12 Updates: Kevin Hudson (S281414)
Interesting Case Studies
  • Oracle Case Study: Global Operations with Oracle E-Business Suite:  Bret Fuller (S281391)
  • Oracle and Pella: A Case Study in Reducing Oracle E-Business Suite
    Maintenance Downtime:  Ric Ginsberg, Dhilip Ranganathan (S281398)
  • Customer
    Case Study: Build an Advanced Oracle E-Business Suite Architecture
    (with a Thousand Concurrent Users) and Massive Reporting by Leveraging
    Oracle RAC and IBM Servers:  Paul Bramy, Alain Roy (S281594)
  • Customer Case Study: Implementing Oracle Applications 11.5.10 on
    Oracle Real Application Clusters 10g and Automatic Storage Management: 
    Kai Yu (S281386)
Hardcore Sessions for Apps DBAs
  • Tuning Oracle E-Business Suite:  Ahmed Alomari (S281393)
  • Partitioning and Purging Best Practices for Oracle E-Business Suite:  Ahmed Alomari (S281654)
  • Leveraging Oracle Database 10g Features with Oracle E-Business Suite:  Ahmed Alomari (S281384)
  • MAA Best Practices: Building an Oracle E-Business Suite Maximum Availability Architecture:  Lyn Pratt (S283064)
  • Security Administration in Oracle E-Business Suite: Overview of
    Oracle User Management:  Sanjeev Topiwala, Roger Wigenstam (S281395)
  • Oracle E-Business Suite Patch Management: A Dive into OAM/AD Features:  Kenneth Baxter (S281399)
  • E-Business Suite Lifecycle Management:  Michael Mast (S281396)
Interesting and Intriguing
  • Service-Enabling Oracle E-Business Suite:  Arun Manchanda, Veshaal Singh (S281415)
  • Oracle Fusion Applications User Experience: Jeremy Ashley, Killian Evers (S281652)
  • Oracle XML Publisher: Enterprise Reporting and Delivery Platform:  Osama Elkady (S281400)
  • Towards Fusion: Identity Management for Oracle Applications including Oracle E-Business Suite, PeopleSoft and Siebel:  Ed King, Sid Choudhury (S281634)
  • How to Secure Your Oracle E-Business Suite Deployment:  Robert Armstrong (S281394)
  • Using Oracle SOA Suite with Oracle E-Business Suite:  Arun Manchanda, Sameer Phatarpekar (S281413)
  • How to Personalize Your Oracle E-Business Suite Without Writing Code: A Talk About Forms Personalization and the OA Framework:  Gregory Frost (S282865)
  • Oracle Forms Personalization Without Coding:  Bill Sawyer (S281409) 
My Own Sessions
  • "Meet the Experts" from the Applications Technology Group
  • Using Oracle Application Server 10g with Oracle E-Business Suite (S281709)
  • Customer Case Study: Leveraging the Enterprise Identity Management Capabilities of Oracle Application Server 10g with Oracle E-Business Suite:  Arun Chan, Mike Kron (S283122)
  • Customer Case Study (Rafael):  Oracle 10g Identity Management with Oracle E-Business Suite:  Gilad Bilia (S281389)
  • And... at unpredictable times, I'll be at the Release 12 Technology Stack booth (Pod A75 in the Oracle Demogrounds)
OpenWorld X-Treme

This is a series of hands-on sessions and workshops on specialized topics.  There's an E-Business Suite technology track that covers Oracle XML Publisher, Daily Business Intelligence (DBI) Customization and Extensibility, Oracle User Productivity Kit (UPK) for E-Business Suite Applications, and Business analysis and simulation.

Related

September 5, 2006

XML Publisher and The E-Business Suite

This is a long-overdue pointer to one of the hottest new technologies for the E-Business Suite:  XML Publisher
(XMLP), which has been instrumental in changing the way we think about
how Apps data can be used by end-users for reports and other business
documents.

XML Publisher Workflow:

Into the Hands of End-Users

XML Publisher is interesting in that it allows end-users -- using tools such as Microsoft Word and Adobe Acrobat -- to create richly-formatted templates for reports and business documents containing Apps data.

XML data extracts from E-Business Suite concurrent programs are merged with those templates at runtime, generating output in PDF, HTML, RTF, EXCEL (HTML), or even text for use with EFT and EDI transmissions.

Advanced Tools for the Data Center

In addition to the potential of this tool to allow your end-users to create simple reports for themselves, there are advanced options for integration with email systems, faxes, WebDAV, FTP, HTTP, barcodes, and more. 

Those topics are discussed in the excellent XML Publisher Blog, which features technical articles directly from the XML Development team.  Note also that there will be several XMLP-related sessions at OpenWorld this year, which are linked to in this article.

Related

September 6, 2006

Using Database Partitioning with the E-Business Suite

[Nov 13, 2009 Update: Removed outdated reference to alterations to preseeded partitioned objects.]

[May 27, 2008 Update:  Added link to latest official documentation for DB partitioning for Apps 11i]

A frequently-asked question is, "Can I use the database partitioning feature in my E-Business Suite environment?"  The answer to this question is yes:  the use of custom partitioning with the E-Business Suite is fully supported.  In addition, several Apps modules take advantage of partitioning right out of the box.

Database Partitioning Methods:

What Does "Fully Supported" Mean?

If custom partitioning causes a particular E-Business Suite flow or transaction to fail and the failure is caused by standard Apps product code, it is considered a product defect, as Oracle Applications is committed to being transparent to custom partitioning.  Oracle Development will issue patches or workarounds for all reported issues with standard Apps product code.

What's Custom Partitioning?

Custom partitioning applies when an existing standard Apps product table is not partitioned and the table is redefined as a partitioned table by:
  1. Using the range, list, hash, or composite partitioning method; or,
     
  2. The partition scheme and/or partitioning method of an existing standard product table which is already partitioned (as part of the standard product) is altered from that which is included in the base product.
Database Partitioning Methods 2:

Examples of Custom Partitioning

For example, if you choose to partition the table OE_ORDER_LINES_ALL which is currently not partitioned in the standard product, then this is an example of custom partitioning. 
Standard Apps Partitioning "Out of the Box"

Oracle Applications utilizes partitioning in the standard product including the following modules:
  • Advanced Planning and Scheduling
  • Payables (Trial Balances)
  • Projects Resources
  • Workflow
  • Directory Services
  • Daily Business Intelligence
  • HR (Employee Directory)
  • Engineering
  • and other products...
In cases where an Apps table has a natural and logical partition key and the majority of the runtime access path (of the standard product) is based on this natural partition key, Oracle Applications will investigate delivering the table as a partitioned table as part of the standard installation.  

Partitioning Based on Functional Implementation

Many E-Business Suite tables do not have a natural partitioning key which would apply to all customers, simply because the data distribution and access path is highly dependent on each customer's functional implementation.  However, you are free to partition the tables in a logical manner based on your own requirements.

For example, many of our Oracle Financials customers partition the table GL_BALANCES by either period_name or set_of_books_id, depending on their implementation:
  • Some customers have a large number of books for which partitioning by set_of_books_id makes sense
     
  • Other customers use a single or a few set of books for which period_name makes sense. 
Since the majority of the GL runtime SQL includes the filters period_name or set_of_books_id, these columns are logical choices for the partition key.

Using Partitioning to Boost Performance

The use of custom partitioning can improve the performance and manageability of your E-Business Suite environment, and many customers are already seeing the numerous benefits of custom partitioning.  Choosing the optimal partitioning method and partition key requires careful and thorough analysis of your system including the access paths of the relevant tables.  For examples and guidelines, refer to the presentation and forma ldocumentation:
If you're interested in more details about partioning and purging Apps environments, Ahmed Alomari is reprising this popular session at OpenWorld 2006, also.

Testing & Licencing

It is important that you thoroughly test the affected Apps modules after implementing custom partitioning, to ensure that your objectives of employing custom partitioning -- including performance and manageability -- have been achieved.

Just one final thing:  if you implement custom partitioning, you must license the database partitioning option.  Your Oracle account representative is always your best source for licensing details. 

References
Related Articles

September 7, 2006

Introducing Pranjal Deosthali, Guest Author

Rounding out our coverage for the database tier, I'm pleased to welcome Pranjal Deosthali as a new contributor to this website.  Pranjal is part of the Applications Technology Group Development team that specializes in high-end database configurations for the E-business Suite.

Here's a short bio:

Pranjal Deosthali is Manager of Advanced Database Configurations in the Applications Technology Integration Group. His responsibilities include integration of various database configurations like Real Application Clusters (RAC), Automatic Storage Management (ASM) and Standby database with Oracle E-business Suite.

Pranjal has been with Oracle since 2003, working with the Applications Technology Stack team before his present role. Pranjal has 11 years of experience in software development, database and IT infrastructure management at Oracle, GE and Cummins Inc.

Pranjal works in the Oracle India Development Centre (IDC) office located in Hyderabad, India.

Stay tuned; his first article is coming soon.

September 8, 2006

Pre-Release Browsers: Why Internet Explorer 7 Matters

[Editor Dec 14 Update:  IE 7 is now certified with the E-Business Suite.  See Microsoft IE 7 Certified with Apps 11i.]

[Editor Update May 21, 2008:  Keith
has moved on to another team within Oracle and, sadly, is no longer an
active contributor to this blog.  Feel free to direct any questions
about his posted articles directly to Steven Chan, instead.]


After a lengthy and unintended delay, I will now begin the "last" of my
three-part series on working with pre-release browers. I would like to say I
saved the best for last, but I'll try to be more objective and say that it's
really the hardest that I saved for last: Internet Explorer 7. In
fact, it turned out to be so hard, that the issue is best divided into two
separate posts, so perhaps you haven't seen the last of this topic yet.

Microsoft Internet Explorer 7 logo 2: <br>

For this post, I'll concentrate on why you will most likely want to test Internet Explorer 7 before it is released, and how to avoid some potentially nasty surprises when it is released, and shows up overnight on every PC in your organization -- even though you told everyone not to download it on their own. As one might expect, Microsoft is eager to help you on both points, with readily available IE 7 release candidate downloads, and a highly important Blocker Toolkit to manage the incoming tide.

Bigger than Big

Microsoft Internet Explorer 7 (IE 7) is one of the most talked about
updates in browser history. Most notably, it is Microsoft's first major
update to their core browser product in nearly five years. IE 7 has promised many new features
that bring it up to parity with competing browsers such as Mozilla Firefox and
Apple Safari, but the biggest changes, despite being under the covers, will have even more of an impact in the IT department than on the users' desktops.

Microsoft is making great efforts to do a better job of adhering to web
standards, and "clean up" much of the buggy CSS and JavaScript behavior that
has been the bane of every web developer's existence. Chances are if you're reading this blog, you don't design web sites for
a living, so you may be wondering, why is this so important to you? The
answer comes in two parts.


Seeing is Believing

First off, if you customize the look and feel of any Oracle HTML-based applications, you're probably more impacted than you may know.

It's important to understand that you can't throw an HTTP request
around without hitting a website these days that doesn't have some kind of
code branch along the lines of "if IE then do this (hack-filled code), else
do this (standard code)". Microsoft is well aware of how this practice has
ballooned over the years, and because of this, they made the unusual move of
sending out an early warning to web developers and site maintainers around
the world, saying that many of these web page "hacks" will not only fail to work with IE 7, but will actually fail to render properly, yielding unintended consequences and, in some cases, totally unreadable or non-functional web pages.

This means that testing your internal web-based
applications and even helping to test vital supplier web sites is crucial to
ensure a smooth transition with IE 7 arrives. Included in that list of applications is any customizations you may have made to E-Business Suite.

Granted, it will be difficult to fully test it without certified E-Business Suite code; rest assured, we've got a headstart on our certification efforts and are working hard to keep the gap between release and certification as small as possible. In the meantime, you will probably get the best results by extracting your customized HTML code and testing it independently from the rest of the E-Business Suite code. This will also allow you to roll out your changes along with any interoperability patches we may require as quickly as possible.

Coming Soon to a PC in Front of You

The second reason for the importance of pre-release testing is that
Microsoft is sending you this new browser whether you like it or not.

Capitalizing on its popularity, and the fact that they have control over the product
as a "core component of the operating system", the new browser version will
be automatically delivered to all Windows XP and Windows Server 2003 users that have the
Automatic Updates feature configured on their desktop. Although it won't
exactly be forced on users, IT departments that have configured
their users to automatically download and install updates from
Microsoft will find that one day in the near future, quite suddenly,
everyone will have gone from running IE 6 to IE 7. (Ed. Update: This actually won't happen invisibly; customers will always have to consent to the upgrade in a pop-up window. See the followup to this article for more details.)

If you aren't sure, open up Automatic Updates from the Control Panel. If you see something configured like this:

Automatic Updates: If the first bullet is selected, as shown here, IE 7 will automatically be downloaded and installed. If the second bullet is selected, the user will have the ability to deselect IE 7 before installing any other updates.<br>

then IE 7 will automatically be downloaded and installed to your machine. If the second bullet is selected, you will have the ability to deselect the IE 7 update before installing any other downloaded updates.

While Microsoft is simultaneously using the lure of new features and
security improvements to encourage its user base to upgrade, they are also
taking advantage of their deep OS integration to minimize the user base
running the older, outdated browser as quickly as possible. There are
certainly benefits to this approach, but the impact it will have on IT
departments and web designers around the world that have yet to clean up
their IE-specific code is nothing short of painful.

Damming the River

Before you panic, however, Microsoft has you covered. Microsoft is
offering a bone to the IT departments out there in the form of an Internet
Explorer Blocker Toolkit
. This toolkit will allow you to configure your network
so that the browser update is "blocked" before it can be delivered to PCs in
your domain, until you decide your organization is ready for it.

Oracle has recently published
MetaLink
Alert 390582.1

on this topic; if you're interested in learning more about this tool, I
encourage you to check it out.

In fact, I would go so far as to recommend that everyone that
is responsible for PCs that are using Internet Explorer to access E-Business
Suite review this alert as soon as possible.

Alternatively, if you have control over automatic updates on your
machine or your network, you may want to turn off the feature that
automatically applies these patches. (If you're one of the many companies
that believes in testing automatic updates before deploying them widely,
then you're probably already doing this, and should be insulated from the
sudden change.)

Preparation Before Preparation

The upshot of all of this is that before you can prepare to test your
applications and services with the new version of Internet Explorer, you
should prepare everyone else by ensuring the update doesn't get deployed
prematurely.

Very soon, I'll discuss how you can go about testing IE 7 on your
network without getting in the way of your E-Business Suite usage. Depending
on your goal, as you'll soon find out, this turns out to be either very easy
or very hard.

Related

September 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

September 12, 2006

Windows Vista Client Certification for Release 11i (Update #1)

[Nov 8, 2007 Update:  Vista is now certified with IE 7 for E-Business Suite Release 11i and 12.  See this article for full details.]

[Oct 11, 2007:  See the latest
Update #5: Vista Certification with the E-Business Suite]

Resisting the almost-overwhelming temptation to editorialize about Microsoft Windows Vista itself, I'm going to shackle myself to answering the simple (and increasingly common) question, "Will the E-Business Suite Release 11i be certified with Vista?"

Microsoft Windows Vista Logo 2:

We do have plans to certify Windows Vista desktop clients with Release 11i.  We are evaluating the feasibility of two different certifications released on separate schedules:
  1. Certification of JInitiator running with Microsoft Internet Explorer 7.x on Windows Vista desktops
     
  2. Certification of the native Sun Java plug-in running on Windows Vista desktops 
Details about specific versions of JInitiator, IE 7, Sun Java plug-ins, and the actual Vista editions required for these certified configurations are all still being evaluated.  There are additional complications arising from Sun's pending desupport of Java 1.3, and our plans for these certifications are ultimately gated by Microsoft's release of Windows Vista and IE 7. 

If you're coming to the conclusion that everything in this article is subject to change, you'd be correct. 

Keep your eyes on this space.  Once we see the final versions of these products, I'll post updates on our certification plans here.

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. 

September 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

September 14, 2006

John Wookey on Oracle's Apps Strategy

In a break from our usual coverage, this isn't a technology stack-related article.  But bear with me; it's worth your while.

John Wookey doesn't have the luxury of writing articles every day.  In fact, given that he's got the hardest job in Silicon Valley, it's amazing that he has the time to write anything at all.

Therefore, if he's taken time out of his schedule to update his blog, I always sit up and pay attention.  Even if you're an Apps DBA whose primary concern is applying ATG RUP 4, John's latest article discusses some of the thinking behind our Applications Unlimited commitments and warrants some reflection:


September 15, 2006

Cheatsheet: Supported Database Configurations with Apps 11i

You are in a maze of twisty little passages, all alike.

~ Adventure, Crowther & Woods

A customer's innocent question this morning resulted in a tedious half-hour rummaging around Metalink, my browser's bookmarks, my sprawling email archives, and my own blog articles in an effort to collect references to Apps database interoperability Notes in a single place.  Grrr.

In case you share some of the same difficulties tracking down database-related Notes for the E-Business Suite, here's a short cheatsheet with the minimum Apps versions required:

Using Specific Database Versions with Apps
Using Split Configurations (64-Bit DB Servers) with Apps
  • 9iR2 (9.2.0.7) split-configuration requires 11.5.8 (Note 304489.1)
  • 10gR1 (10.1.0.4) split-configuration requires 11.5.9 CU2 (Note 356839.1)
  • 10gR2 (10.2.0.2) split-configuration requires 11.5.9 CU2 (Note 369693.1)
Using RAC + ASM with Apps

September 18, 2006

Encrypting Traffic Between 11i Application and Database Tiers

Editor Sep 20 Update:  Added discussion of performance impact for this configuration

It's now possible to encrypt the SQL*Net traffic that flows between your E-Business Suite Release 11i application and database tier servers.

ASO diagram:

This long-awaited certification is delivered through an Oracle database feature called Oracle Advanced Security Option (ASO).  For reasons too arcane to discuss here, this is also  referred to as Advanced Networking Option (ANO).

The process involves installing an E-Business Suite Concurrent Manager patch and Oracle Advanced Networking, changing several configuration files, and then relinking your Apps executables.

The minimum prerequisites for this configuration include:
  • Oracle Applications 11.5.10 users with RUP 3 or later (11i.ATG.PF.H RUP3 patch 4334965 or later)
Exception for HP-UX Users

HP-UX users cannot enable ANO/ASO until the resolution of bug 5398088. This bug prevents access to MOD PL/SQL from the $IAS_ORACLE_HOME.

Negligible Impact on Performance

Several readers have asked about the performance overhead for this configuration.  According to our E-Business Suite Performance Group, the overhead is approximately 5%, mainly due to an increase in round-trips and payload size as well as some trivial amount of packet processing when ASO is enabled.

For security-conscious customers, this overhead is a small price to pay for the added security for encrypting this sensitive traffic.

Related

September 20, 2006

In Depth: Try Internet Explorer 7 Beta without Breaking EBS

[Editor Dec 14 Update:  IE 7 is now certified with the E-Business Suite.  See Microsoft IE 7 Certified with Apps 11i.]


In this fourth post of our increasingly inappropriately-named trilogy (kudos to Douglas Adams), we expand on the concept of why you might want to test pre-release versions of Internet Explorer, by discussing how to do your pre-release testing, and how to do so safely.

Minor Errata

But first, I'd like to provide a quick update on my previous post. In there, I mentioned that Microsoft would be delivering Internet Explorer 7 via Automatic Updates, and that you might want to take steps to avoid it showing up by surprise. Well, it turns out Microsoft won't becatching users completely by surprise; unlike other auto-updates, this one will come with a warning dialog, requiring users to explicitly accept the upgrade.

IE 7 Warning Message:

Nevertheless, forearmed is forewarned, and use of the blocking tool iscertainly the safer and better recommended approach.

What Sounds So Easy Isn't

In an ideal world, you should be able to try new software alongside old software to make sure you like it and that it works with complex web-based software such as Oracle E-Business Suite before getting rid of your old software. You may have gotten the impression that this should be pretty easy, especially if you read the article that covered how to do this with Firefox 2 Beta.

Well, the good news is that Microsoft makes it very easy to download and install IE 7 Beta for testing. But the bad news is that Microsoft is digging in its heels when it says that IE is "part of the operating system". This means that it's all but impossible to run IE 7 and IE 6 at the same time.

There are several approaches you can take, some fast and easy, and some difficult and resource intennsive. Unfortunately, the easy ones are the least complete, and the most accurate way to test is the hardest. I'll discuss three options, starting with the safest and most supported method, and move in increasing levels of kludginess.

The Box Inside the Box

Microsoft's official recommendation for testing IE 7 is to use a separate PC that does not contain any mission-critical applications on it. In the world of practicality, this barely enters the atmosphere, since it's the mission critical apps that you want to test the most.

So Microsoft's official solution to this is virtualization. Steven already discussed this topic briefly in an older blog entry, as related to E-Business Suite. In this case, you can use a tool such as VMWare Server 1.0 or Microsoft Virtual PC 2005 -- both totally free -- to create a virtual instance of Windows running on your machine.

IE in Virtual Machine: IE 7 running inside a virtual machine, with IE 6 running on the host OS.<br>

It's an elegant, easy-sounding solution, but isn't just for anyone. First, it requires that you have access to a Windows XP install CD, or a previously created virtual image that was made in your organization. (Unlike Linux-based images that can be distributed freely, the licensing requirements of Windows insist that you create your own virtual images, with your company's serial key and activiation codes.) Second, it requires a lot more physical resources: while the browser requires only a negligible amount of disk space and RAM, an entire virtual machine for Windows requires about 8-10 GB of disk space, and a machine with at least 1 GB of RAM (but 2 GB is recommended).

However, if you can manage to leap past these hurdles, the upshot is that you'll have a virtual copy of Windows XP, where you can safely upgrade to Internet Explorer 7 and do your testing in a fully-supported, yet isolated fashion. The image above shows IE 6 running on a host OS, side-by-side with IE 7 running in a guest (virtual) OS.

Only for the Truly Brave

Technically, there is one other supported method for testing Internet Explorer 7, and that's by installing a pre-release copy of the forthcoming Windows Vista client. Release Candidate 1 of the new operating system is available for open testing, and if you really feel brave, you can install this on a new machine (or, unofficially, in a virtual machine), and use the version of Internet Explorer that is included in the OS itself.

For the record, this version of IE is actually "Windows IE 7 in Windows Vista", as opposed to "Windows IE 7 for Windows XP" [emphasis added by me], which you can download separately. No, I'm not making up those product names. Although these are actually separate products, the additional features in the Vista version -- Protected Mode, Parental Controls, and improved Network Diagnostics -- are all beneath the covers, so you shouldn't notice any differences for the purposes of testing basic web usage and how pages render.

While this approach doesn't require any fewer resources, you at least get the added bonus of experimenting with the new Windows client UI as well, if that's your idea of fun. (Tell your boss you're "getting a headstart.")

Using the Back Door

Back in the Good Ol' Days of Internet Explorer 5.0, Microsoft included a "compatibility" option in their install that allowed users to keep IE 4 on their machine, while running IE 5 alongside. This was mostly a nod to web developers (and the relatively fewer corporate users that existed at the time), as Microsoft understood the need to test web sites against and run them with older browser versions until the newer versions took a significant enough foothold and were fully supported. Starting in IE 5.5, this practice was no longer officially supported, but the feature remained present in an undocumented form, through which users (mostly savvy web developers) could install IE in its own directory and, by the presence of a "secret" file, instruct it to only load DLLs only from that directory. This worked up until the latest version, IE 6 Service Pack 2.

For better or for worse, Microsoft implemented new security restrictions in IE 7 that require the addition of over 1500 new registry entries in order to run the browser, effectively closing that hole (or at least making it much, much harder to exploit), and thus forcing developers -- and users -- to take drastic steps to work with IE 7 Beta without giving up their fully supported IE 6 installation. If you're really under the gun, and need to do some work with IE 7, but you don't have time to set up a separate machine or a virtual machine, you might want to try this "standalone" version of IE 7.

Fortunately, it's very easy to try. Everything you need, including instructions and links to download the necessary pieces, can be found at http://tredosoft.com/IE7_standalone. (If you prefer to see what this program is doing, you can follow this alternate link to Jon Galloway's blog. Jon is the pioneer in reverse engineering all this registry work that Microsoft has done, and most of us have him to thank for coming up with this approach.)

Here's how it works: you download the latest IE 7 version, but extract the files into a directory, rather than installing it. You'll also need to apply a minor update to some XML files. Then, you will use a standalone launch program (IE7S.exe) to launch the browser. This program will automatically populate your registry with many of the required entries to run IE 7, then clean them out when you exit the browser, restoring your system to its original state.

IE in Standalone Mode: IE 7 running in standalone mode (with IE 6 also running)<br>

While this approach seems as elegant as the old days, I must warn that there are some severe caveats here. Most notably, many of IE7's new features (and some old ones) don't work, including RSS feeds, favorites, the search box, and the menu bar, because the necessary registry entries have yet to be uncovered and incorporated into the standalone launch program.

For the purposes of testing web site compatibility and page rendering, this approach is generally acceptable, if limited. Nevertheless, the program is fairly crippled without a complete set of registry entries to work with -- even drop-down menus weren't working in the last version I tried. So if your primary goal is brief compatibility testing  -- particularly if you have a lot of advanced Cascading Style Sheets (CSS) -- and you don't want to spend a lot of time and resources on setting up a VM, then this is something worth considering.

The Low-Tech Approach

Finally, I would be remiss in not mentioning one last option: just go ahead and install IE 7 for testing, and uninstall it when you're finished playing with it. The uninstall has been well tested by many users and is reportedly very clean now, but I would still do a full backup of your OS ahead of time, just to be safe.

Note that in order to uninstall IE 7, you'll need to check the "Show updates" option in your Add/Remove Programs applet, then look under "Windows XP - Software Updates" in order to find it.

Show Updates checkbox: The "show updates" checkbox at the top of the Add/Remove Programs applet.<br>

Microsoft also promises that users can uninstall IE 7 at any time, even after the final version is pushed down to users, and revert back to a fully working version of IE 6 Service Pack 2.

While this approach is certainly easy and safe, it doesn't fully meet the qualifications of our experiment, which is to leave you with a supported version of IE in place while doing your testing. So be sure to install the latest copy of Firefox so you can access E-Business Suite in the meantime, if necessary.

Final Preparation

Before you head out and start using IE 7, I want to recommend a few additional links for more information.

  • Microsoft hosts an IE 7 Readiness Toolkit, which consists of documents all kinds of detailed information on deploying and developing for the new version of IE.

  • The IE-Vista site contains what I believe to be the most comprehensive list (outside of Microsoft's own bug reporting system, which is anything but easy to browse) of known issues with the beta and release candidate versions of IE 7. If you're having problems, you should definitely check here first.

  • It's never too late to give Microsoft your feedback (though that's not to say it isn't too late for anything you report to get fixed in the final version of IE 7). You can sign up to participate in Microsoft's Beta program by visiting Microsoft Connect, which will give you access to early (non-public-release) test builds, as well as mechanisms for providing feedback directly to the product teams on issues you may encounter.

Go Get Started

I hope this series of articles on pre-release browsers has been useful to many of you. Exploring new technologies is interesting for some, and important for others, but the difficulties that can lurk in the shadows often make people more reluctant to experiment. With the right amounts of preparation and advanced knowledge, however, the seemingly impossible can become a realistic plan of attack.

Happy browsing!

Related

September 22, 2006

OCFS2 or ASM for Apps 11i?

Hmmm.  Let's see how many cryptic acronyms we can stuff into a six-word title... There's been a flurry of Oracle Cluster File System-related queries this week; must have something to do with the impending Autumnal equinox. 


Simultaneous Write Access to a Data File

When you deploy Real Application Clusters (RAC) in your Apps environment, you deploy a cluster of database servers that access datafiles on a shared storage system, like this:

RAC ASM Shared Cache Architecture:

Conventional file systems lock a file whenever it's accessed, preventing others from modifying it at the same time.  Serializing write accesses between multiple database servers undermines the very point of having a RAC cluster, so operating system vendors and various others have come up with a range of solutions.

Oracle has two technologies that support this: 
The former -- for Linux platforms -- has gone through a few iterations and is now dubbed OCFS2.  Oracle has released OCFS2 under the GNU General Public Licence (GPL).

Oracle Cluster File System or Automatic Storage Management?

Given the choice between using OCFS2 or ASM, the Applications Technology Group strongly recommends the use of Automatic Storage Management for E-Business Suite database servers.  E-Business Suite Release 11i is formally certified with Automatic Storage Management.  For an in-depth discussion of what "E-Business Suite certification" really means, see:
Supported for use with Apps Database Servers Only

Due to our focus on Release 12 and Fusion, the Applications Technology Group does not plan to perform formal certification of the E-Business Suite Release 11i with OCFS2.  The underlying OCFS2 technology has been certified for use with Oracle databases and Real Application Clusters.  So, it should work transparently with E-Business Suite databases, too.

The Applications Technology Group will support the use of OCFS2 for the
E-Business Suite 11i database tier but not the application server tier.

OCFS2 is certified with a specific set of RAC versions, so Apps customers interested in using this technology must check the OCFS2 documentation to ensure that their desired Oracle database and Linux combinations are certified together.

What Does "Support" Mean?

As is the usual case for these types of "supported but not certified" configurations, you should thoroughly test OCFS2-based E-Business Suite RAC environments prior to production rollouts.

If you report any issues with this configuration, Oracle will attempt to issue a fix or workaround for OCFS2 or the E-Business Suite.  This may not be technically feasible in all cases.  If it isn't technically feasible, the Applications Technology Group may recommend that you convert your E-Business Suite RAC implementations to use Automatic Storage Management instead.

Related

September 26, 2006

Applying O/S Patches to Apps Environments

Operating system (O/S) vendors often recommend applying latest patches or a specific patch to fix a specific issue you are facing, so you may wonder if these O/S patches could possibly have a negative impact on your E-Business Suite environment.

Unfortunately, it is not unknown for an O/S patch to have an impact on Oracle software.  For example, see:

So, how do you identify and mitigate potential risks?

E-Business Suite Certified with Top Level O/S Versions

In general, Apps 11i performs certifications with only the top level operating system version (Solaris 9 or AIX 5.3 for example).  Specific operating system requirements such as kernel settings or O/S patch requirements are documented in:

  • The platform specific release notes
  • Certify
  • Metalink notes relating to eBiz itself or the technology components
Oracle Support would not normally discourage customers from applying any additional O/S patches recommended by O/S vendors unless specific issues have been found and documented that affects Oracle software.

Test Thoroughly Prior to Production Rollouts

As with any patching activity, Oracle recommends that you perform sufficient testing in a representative TEST system prior to implementing in PRODUCTION, to ensure there are no issues introduced by any such changes. 

Minimizing O/S Patching Risks

So, what proactive steps can you take to minimize the risk?   Before applying an O/S patch:
  1. Search Metalink for any known issues. 
     
  2. If you have any specific concerns, pose the question in the Oracle Forums to see if your peers have any experiences they can share.
     
  3. Search your O/S vendor's knowledge base and forums for any reported issues.

It is also prudent to have a tested emergency rollout strategy in place to allow you to recover if an issue is only found once implemented in the PRODUCTION environment.

Getting Help with O/S Patch Problems

If you are unfortunate enough to experience problems after applying an O/S patch (hopefully in your TEST environment), raise a Service Request with the appropriate Oracle Support team to get help with identifying the root cause of your issue.   Oracle Support will likely expect you to work primarily with your O/S vendor in the initial stages of such an investigation, so you should certainly be engaging your O/S vendor support team as part of the problem resolution process

In conclusion, any change introduces risks as well as the benefits.   Planning, research, a healthy dose of paranoia -- and as much testing as possible -- will allow you to minimize and mitigate the risks involved with applying O/S patches, giving the best chance of a successful implementation.

About September 2006

August 2006 is the previous archive.

October 2006 is the next archive.

Many more can be found on the main index page or by looking through the archives.

Google Search

Archives

Subscribe to Updates

Powered by
Movable Type and Oracle