Configuring mod_plsql in EBS 12.2

Customer November 20, 2019 Questions & Answers 11 replies

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?

11 replies

Support Enginatics November 20, 2019
`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
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 Enginatics November 24, 2019
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
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 Enginatics November 27, 2019
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
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 Enginatics November 29, 2019
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
What tools can our DBA use to quickly diagnose issues if the Apache server or a concurrent manager fails after a configuration change?
Support Enginatics December 1, 2019
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
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 Enginatics December 5, 2019
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.

You must be logged in to reply to this post.