Configuring mod_plsql in EBS 12.2

Customer November 20, 2019 at 11:50 am

We need to enable `mod_plsql` within our EBS 12.2 Apache web server. This module is essential for developing small web applications using server PL/SQL. What steps are required to enable and configure `mod_plsql` in EBS 12.2?

Viewing 10 reply threads

Author
Replies
- Support November 20, 2019 at 9:28 pm
  `Mod_plsql` is a module included in the EBS 12.2 Apache web server, used for developing web applications with server PL/SQL. Enabling it involves taking specific steps to configure the web server component to define the Document Access Descriptors (DADs) and necessary security settings, integrating the PL/SQL gateway into the EBS technology stack.
- Customer November 22, 2019 at 5:29 pm
  If we were operating on an older version, like EBS 11i or 12.1.3, would the process for configuring `mod_plsql` be substantially different?
- Support November 24, 2019 at 1:52 am
  Yes, separate configuration documents are needed for older versions. Specific posts detail the required steps for Configuring mod_plsql in EBS 11i and Configuring mod_plsql in EBS 12.1.3. The configuration steps reflect the architectural differences in the Apache web server across EBS releases.
- Customer November 26, 2019 at 12:08 am
  We also rely on the Integrated SOA Gateway (ISG) for modern REST integrations. How does enabling `mod_plsql` relate to or interact with the ISG configuration in 12.2?
- Support November 27, 2019 at 8:32 pm
  While ISG provides modern, standards-based interfaces (like REST) , and `mod_plsql` supports older web application development using PL/SQL packages, they operate on different protocols/listeners within the EBS architecture. Both require distinct configuration paths, but securing both interfaces with TLS/HTTPS is separately critical.
- Customer November 28, 2019 at 1:07 am
  If we deploy a new custom PL/SQL application using `mod_plsql`, can we still leverage Blitz Report for transactional reporting within that application context?
- Support November 29, 2019 at 7:13 pm
  Blitz Report is integrated within the Oracle Forms and OAF pages of EBS. However, custom reports can retrieve data generated by any EBS component (including `mod_plsql` applications) by executing appropriate SQL within the Blitz Report interface, allowing quick analysis of the application’s transactional data.
- Customer December 1, 2019 at 6:48 am
  What tools can our DBA use to quickly diagnose issues if the Apache server or a concurrent manager fails after a configuration change?
- Support December 1, 2019 at 10:46 am
  DBAs utilize Blitz Report as a standardized toolkit for troubleshooting. They can instantly run concurrent request monitoring reports, which provide alerts for critical processes and deep diagnostics on request status, execution method, and run times, even filtering by Node or Manager Name.
- Customer December 3, 2019 at 8:12 am
  We need to automate the process of sending reports generated by our PL/SQL web app (or Blitz Report) to external systems like SharePoint Online from the Linux server.
- Support December 5, 2019 at 7:20 am
  You can use scripting solutions for this. There is documentation on Sending files from Linux to Sharepoint online using a python script. This provides a method to move generated reports (Excel, PDF) from the EBS server environment to external repositories.
Author
Replies