EBS R12 integration with WebCenter – Error retrieving WSDL at URL OA_HTML/ portlets/ WSRPBaseService?WSDL
This post covers issue encountered during EBS R12 integration with Oracle WebCenter.
Oracle EBS R12 integration with Oracle Webcenter Suite is explained in My Oracle Support Note # 1074345.1
For EBS-WebCenter integration :
1. You must first register WebCenter server in list of allowed servers to access EBS OA_HTML/portlets/*******.
This is done by adding webcenter server name in s_trusted_portal in Context File and run AutoConfig here and here
Note: Running autoconfig adds server name in apps.conf under $INST_TOP/ora/10.1.3/Apache/Apache/conf/apps.conf (For R12)
2. You must then register EBS Suite Portlet Producer with Oracle WebCenter so that EBS Portlets can be displayed to WebCenter page .
EBS Portlet Producer can be registered with WebCenter either using WebLogic Scripting Tool – WLST : registerWSRPProducer or using FMW Control /em of webcenter (GUI).
If you register Portlet Producer in webcenter and hit error like
____
Error occurred while performing mbs.queryNames(objname) for “oracle.webcenter.portlet:name=ProducerManager” None
Error retrieving WSDL at URL “http://innowave12.com:80/OA_HTML/portlets/WSRPBaseService?WSDL”
____
Then check following things
a) Check if WebCenter server can telnet to EBS on port 80 (web port) – If not then check if EBS Middle Tier is up and EBS Apache port is open (80 in this case) between WebCenter and EBS
b) Check if you can access URL http://innowave12.com:80/OA_HTML/ portlets/WSRPBaseService?WSDL from webcenter machine . Use tool like wget on Unix
c) If from wget you get error code 500 , then check EBS Suite OC4J logs (Oracle Container 4 Java). For log location in EBS R12, click here
In my case error message was 403 – Access Denied which means EBS Suite has denied access to WebCenter Server for URI /OA_HTML/portlets/WSRPBaseService?WSDL
Output from wget http://innowave12.com:8000/ OA_HTML/portlets/ WSRPBaseService?WSDL (from webcenter node)
___
Connecting to
> innowave12.com[192.168.1.12]:8000… connected.
> HTTP request sent, awaiting response… 403 Forbidden
> 16:51:49 ERROR 403: Forbidden.
___
This message means that WebCenter server can connect to EBS Suite server but access to URI OA_HTML/portlets/WSRPBaseService?WSDL is denied by server (ERROR 403: Forbidden)
If you check EBS Apache Server access_log & error_log (for log location in EBS R12 click here )
_______
[Mon Jan 30 11:10:20 2012] [error] [client 10.10.1.24] [ecid:1327921819: 172.22.81.141 :6094906:0:1167,0] client denied by server configuration: /OA_HTML/portlets/WSRPBaseService
_______
Where IP address of WebCenter machine is 192.168.1.15 (10.10.1.24 is one of IP from NAT pool load balancer and request to EBS goes via load balancer)
Access to URI is controlled by configuration file
$INST_TOP/ora/10.1.3/Apache/Apache/conf/apps.conf with entry like
Default Entry
<Location ~ /OA_HTML/(portlets|providers)/*>
Order deny,allow
Deny from all
Allow from localhost
</Location>
Above setting allows access to portlet URL only from localhost address of EBS Middle Tier
After adding Webcenter Server hostname/IP in context file (s_trusted_portal) you should see entry like
<Location ~ /OA_HTML/(portlets|providers)/*>
Order deny,allow
Deny from all
Allow from localhost webcenterhost 192.168.1.15
</Location>
Above configuration means on /OA_HTML/(portlets|providers)/* , access is allowed only from localhost, webcenterhost and 192.168.1.15.
Issue: In my case request from WebCenter host to EBS goes via Load Balancer and though request to portlet originates from WebCenter Host, for EBS client is Load Balancer NAT address.
Fix: Add load balancer NAT address in s_trusted_portal in context file and run Auto Config.
More on EBS R12 Integration with WebCenter later