OOW10 Day 2 mid-day update: Interesting new EBS techstack functionality

The draft of my Day 1 post is not quite complete, but I want to post this before my thoughts from the recent "EBS Vision, Strategy and Roadmap" session fade into an under-caffeinated haze. OpenWorld is a bit draining; I can only assume I will be a husk of my former self by Thursday evening.

The session covered a lot of information at a pretty high level, including information that is already familiar to people that have already migrated to R12. That's not suggesting that the content was not useful; about 67-75% of the very large room indicated by show of hands that they were still running on Oracle Applications 11i, and a significantly smaller percentage indicated that that they were in the middle of an R12 upgrade. The following points really stood out for me, though:

  1. Support for using Active Data Guard for an E-Business Suite reporting instance. The core challenge in using Active Data Guard and E-Business Suite is that you can't write to an Active Data Guard database, and the simple act of authenticating to E-Business Suite requires writing to the Oracle Applications tables. The Applications Technology Group has devised a way to get around (or perhaps more accurately, work with) this limitation, and have begun an early-adopter program for interested customers. Two important restrictions to note are:
    • The functionality is being made available as a patch on version 12.1.3 of Oracle Apps, so you'll need to be pretty current with your tech stack
    • This will only work for "read only" reports, though Oracle can also provide a method to identify which reports can be run against an Active Data Guard database instance.
  2. Lightweight multilingual support, a feature new to version 12.1.3, allows Apps users to perform general data processing (data entry, reporting, etc) in multiple languages without delivering the full applications UI in those languages. This has the advantage of reducing the patching/maintenance burden on Apps DBAs, and that's never a bad thing. :) It was noted in the presentation that traditional full multi-language implementations can coexist with additional "lightweight" language implementations, and that it's possible to migrate lightweight versions to full language implementations.
  3. Use of a staged APPL_TOP for upgrades from 11i to R12. This topic was actually covered by Robert Farrington on Steven Chan's blog last week, but it's worth calling out again. This feature has the potential to save a lot of time during an R12 upgrade; particularly when you consider that an R12 upgrade these days often will require applying a patchset atop the based release, with the accompanying rebuild of a staggering number of forms and reports.
  4. Finally, a "future release" of E-Business Suite (presumably 12.2) will include support for Edition-Based Redefinition. I had a slightly rambling blog post about this possibility earlier this year, and it's apparently going to become a reality. If you're interested in the possibility of near-zero-downtime EBS patching, now's the time to upgrade your database to 11gR2. Or you could wait until EBS Release 12.2 ships and upgrade both at once, but who needs that kind of stress?

As with all really cool Oracle Applications technical news, you'll undoubtedly find more cogent discussion on Steven Chan's blog in the coming days/weeks as the dust settles from Oracle OpenWorld. I'm just calling attention to these topics for people who might be interested, so you know to watch for more information.


  1. Praveen
    Posted 6 March 2011 at 8:20 | Permalink

    What are the marked differences between 12.1.3 and the upcoming 12.2?
    Does it make sense to wait for 12.2 ?
    By when will it be shipped??

  2. Posted 21 March 2011 at 8:43 | Permalink

    Hi Praveen,

    A target release date for 12.2 was not offered during the OOW talk I attended, which is not unexpected; Oracle doesn't get very specific about release dates. :-) If you're curious about what's coming in 12.2, you might want to reach out to your Oracle representative to see if they can give you some information that helps you to plan your upgrade strategy.


    John P.

Post a Comment

Your email is never published nor shared. Required fields are marked *