How to Enable PL/SQL gateway (MOD_PLSQL) in Oracle EBS R12.2

Oracle disabled mod_plsql support by default in EBS R12.1, and much to my surprise that Oracle still put mod_plsql stuff in EBS 12.2.  Again it is not enabled by default, but making it work is not a difficult task at all.

All the changes mentioned below is in fs1, but it could be fs2 depends on which one is your running instance.

(1) Stop or start the Apache by adapachl.sh script.  No need to stop the Weblogic since this functionality is provided by Apache Mod.

(2) Identify the running oracle_apache.conf file under directory
$IAS_ORACLE_HOME/instances/EBS_web_[SID]_OHS1/config/OHS/EBS_web_[SID]

Add a line at the end of this file:
include ${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/plsql.conf
The variables specified in config file will be resolved during runtime.  So no need to put the actual path in there.

(3) The file plsql.conf mentioned in this line is not exist (under the same directory of oracle_apache_conf just modified).  Make a copy of this file from directory
$ORACLE_HOME/Apache/modplsql/conf

Modify the lines similar as follows:

#Window 
LoadModule plsql_module "${ORACLE_HOME}/ohs/modules/mod_plsql.dll"
#Linux/Unix
LoadModule plsql_module "${ORACLE_HOME}/ohs/modules/modplsql.so"

# Turn on logging for debug only!!
PlsqlLogEnable on

PlsqlLogDirectory ${ORACLE_INSTANCE}/diagnostics/logs/${COMPONENT_TYPE}/${COMPONENT_NAME}

include "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/mod_plsql/dads.conf"

include "${ORACLE_INSTANCE}/config/${COMPONENT_TYPE}/${COMPONENT_NAME}/mod_plsql/cache.conf"

(4) The file dads.conf does exist but the content is empty.  So add the mod_plsql location for your instance

<Location /pls/[SID] >

SetHandler pls_handler

Order deny,allow

Allow from all

AllowOverride None

PlsqlDatabaseUsername apps

PlsqlDatabasePassword apps

PlsqlDatabaseConnectString localhost:1521:[SID] ServiceNameFormat

PlsqlAuthenticationMode Basic

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

PlsqlRequestValidationFunction XX_MOD_PLSQL_CHECK

PlsqlErrorStyle DebugStyle

<Location >

(5) The rest of the setup will be identical to R12.1
http://symplik.blogspot.com/2013/10/how-to-enable-plsql-gateway-in-r12.html