Four Critical Changes for Customizations in Release 12

If you're planning to upgrade from the E-Business Suite Release 11i to Release 12, one of your most important preparatory tasks is to catalog all of the customizations you've deployed in production. 

You may have built customizations or extensions to Apps 11i using any of the following technologies:
  1. mod_plsql

  2. Oracle Reports Server
  3. Oracle Graphics Integration with Oracle Forms
  4. Oracle Applications Framework pages in the AK Repository (AK mode)
If so, you should review the following Metalink Note to evaluate the implications of Release 12's new technology stack on your deployment:
If you're looking for a bit of guidance on how to tackle this task, I've outlined a general business approach in this article:
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. 


Hello there, just few questions: after official release, how much infomation there will be about this kind of change?, and if so, how it will be organized? (on customization, upgrade, administracion) there will be a 12i especial center/mega-note?

Thanks a lot
Really looking for the 12i release

Posted by Jorge Suarez on January 17, 2007 at 03:04 AM PST #

Floyd, you do get around, don't you?  Feel free to quote this piece -- I agree that we need to get the word out (particularly on the mod_plsql topic).  Thanks for helping the Apps community get through to the acceptance stage. ;-)Regards,Steven

Posted by Steven Chan on January 18, 2007 at 11:58 AM PST #

Well, the Note that I've referenced is the official documentation that's intended to support you through the migration of your customizations for Release 12.  That Note points to detailed documentation that's intended for developer-class readers (some of that referenced documentation may as yet be unpublished).  If you need more information than what's available, please let us know the specific areas that need bolstering.  You can do that by logging a Service Request via Metalink.  Feel free to copy me on the SR number if you decide to go that route.Regards,Steven

Posted by Steven Chan on January 18, 2007 at 12:03 PM PST #


I write the "Fusion Corner" column for Solution Beacon's monthly newsletter on Oracle Apps. If you don't mind, I'd like to quote your post (with credit, of course) - we need to get this message out to as many customers as possible.


Posted by Floyd Teter on January 18, 2007 at 12:35 PM PST #

Hi Steven,

I'm interested to find out if there is any direction for Oracle Application Express (APEX) in relation to mod_plsql not being supported. I've worked on a handful of projects with APEX integrated to Oracle Applications, and all are using mod_plsql to integrate. Having to do a separate Oracle Application Server install purely for APEX isn't very nice! Thoughts?


Posted by Gareth Roberts on January 24, 2007 at 05:55 AM PST #

Hi, Gareth,Right -- that's pretty much the only architecture supported for Release 12 if you're dependent on mod_plsql.  There's no way of reenabling mod_plsql on the Release 12 application tier itself, so hosting it externally is the only viable architecture.I've passed your feedback on to our architects for this area.Regards,Steven

Posted by Steven Chan on January 24, 2007 at 07:40 AM PST #

hi steven,
i manage to upgarde out test enviromant successfully from to R12 and every thing is working fine excpt the cusomzed module even though we follow the oracle customization standerd and they used to work before upgrade. so i was wondering if there is any note or hint that can help me solve my issue. the issue is when i try to open the customized form i am getting "function not availabe to this responisblity" i will arrange to open a TAR.


Posted by Fadi Hasweh on March 25, 2007 at 01:30 AM PDT #

Hi, Fadi,Glad to hear that your R12 upgrade went smoothly.  I think that a TAR would be your best option for investigating any issues with your customized module.Good luck.Regards,Steven 

Posted by Steven Chan on March 25, 2007 at 02:24 PM PDT #


Just wanted to get some clarification on mod_plsql's future, outside of the Oracle Apps arena, is there a commitment to keeping mod_plsql supported in future releases of the Oracle database?



Posted by David Godfrey on May 27, 2008 at 01:45 PM PDT #

Hi, David,I can't speak for Oracle Application Server's plans officially since I'm part of the Applications development division.As far as I'm aware, the Oracle Application Server development team plans to continue to support the generic use of mod_plsql.  That said, it never hurts to log a Service Request against Oracle Application Server to get an official reply from that team.Regards,Steven

Posted by Steven Chan on May 28, 2008 at 03:42 AM PDT #

So I'm clear... will apex work on R12 or not?
We use it in 11i to give us a supportable way to give access to data that can't be easily combined in the application (from different pages/etc).

Posted by JD Austin on July 24, 2008 at 08:12 AM PDT #

Hi, John,

Yes, Application Express (APEX) can be used to develop those types of extensions. The Applications Express Development team is currently working on some guidelines on how to integrate APEX with the E-Business Suite.

I don't have a specific release date for that whitepaper yet, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as they're available.

You might also find a comment from APEX Development about their future plans of interest -- it's attached to the following article:


Posted by Steven Chan on July 24, 2008 at 08:19 AM PDT #

Hi Stevan,

Instance is at with database

Plan is to upgrade to R12 with so we can follow path A as per Note: 467778.1 but for 10g upgrade minimum prereq is as per Note:362203.1.

Do you think we should also upgrade 11510CU1 to 11510CU2? In my openion it shouldnt be required as we shall use filesystem of R12 so anyways we are not going to use filesystem of 11i anymore. Please confirm my understanding is correct, if not advise.


Posted by Naresh on August 20, 2008 at 12:56 AM PDT #

Hi, Naresh,

The Release 12 Upgrade Guide ( shows a supported upgrade path from either 11.5.10 Base, 11.5.10.CU1, or 11.5.10.CU2.

However, Note 362203.1 explicitly states 11.5.10.CU2 as a prerequisite for the 10gR2 database upgrade.

Given that you must have the highest common denominator in place, you need to upgrade to 11.5.10.CU2 if you wish to follow a fully-supported and certified path here.

Good luck with your upgrade.


Posted by Steven Chan on August 25, 2008 at 02:56 AM PDT #

Thanks Stevan for the reply and wishes.

I am fully not convinced on applying CU2 before 10g upgrade on in context of R12 upgrade. Since we shall install filesystem using rapidwiz for R12 in chapter 1 of upgrade guide (Part No. E12011-01) and lateron shall be upgrading the database in chapter 3. Here applying CU2 doesnt make sense to me as the filesystem instance would be using is of R12.


Posted by Naresh on August 26, 2008 at 06:15 PM PDT #


I *do* understand what you're trying to say.

It's always possible to take shortcuts, but recall that our official documentation and certified procedures are based on testbed environments where no steps have been skipped.

If you encounter a problem at a later stage, Oracle Support's standing instructions are to backtrack what's been done to an environment. If they find any divergence between what's been done vs. the official documentation, they will instruct you to redo whatever steps were missed or "improvised upon."

I can't officially recommend that you skip any steps or prerequisites in linked chains of documentation, for obvious reasons. Skilled DBAs and experiencd sysadmins can sometimes find more elegant ways of accomplishing the same goals. If you choose to go that route, my advice would be to document carefully what you've done and to test the end-point environment thoroughly.


Posted by Steven Chan on August 27, 2008 at 06:19 AM PDT #

Hi Steve,

Oracle Reports Server is one of technology deprecated in R12. Customers ask this how they will identify the custom objects ( Reports) are using report server? Is there any way to list all the objects using report server?

My understanding is that all custom rdf reports uses report server.

Posted by guest on April 03, 2014 at 03:33 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed


« April 2014