Mod_plsql is an Apache web server extension that can be used to develop web application pages using Server PL/SQL.
Architecture diagram showing flow from client to mod_plsql Apache mod to Oracle database

The Past is Prologue
Unlike Oracle E-Business Suite Release 11i, Release 12 does not include mod_plsql as part of its technology stack. I’ve briefly discussed this architectural change in the following two articles:
It should be stressed 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.
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.
Going Into More Detail
Many of you 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, and more: The whitepaper discusses:
  • The architectural rationale for dropping mod_plsql in EBS 12
  • Prioritized recommendations for dealing with custom mod_plsql pages from EBS 11i
  • Deployment and coding considerations when using mod_plsql in EBS 12

An Open Conversation
George concludes the whitepaper by emphasizing that we encourage you to use your Release 12 upgrade as an opportunity to eliminate customizations or replace them with the use of native functionality or supported personalization or extension technologies.
We don’t expect this to be the final word in this discussion, but something that provides an informed starting point in an ongoing dialogue with us. If you have thoughts or questions about this whitepaper, please post them as comments here. If we’re lucky, we’ll get George and the mod_plsql development team participating directly in these online discussions with you.
Related Articles