Integrated SOA Gateway EBS-R12 - 'SOA Provider Access is not available'

Hello Tech Community,


In this post, I will be discussing the issue that I came across the Integrated SOA Gateway. Everything was configured as per the implementation guide and was working fine. Then came the R1213 upgrade from R1212 and here we are with the issue. Let's get started. This is Linix (RedHat 5.5 x86-64) with EBS R12.1.3.


Error:


This issue is encountered while generating web service from a native java api through SOA Gateway.

Also cannot view the wsdl file from the hyperlink. Infact the hyperlink seems to be freezed.
The webservice must be deployed with the usename/password token- 
This generates a secondary error when deploy button is pressed.


The Error that display is - 'SOA Provider Access is not available'


The Navigation path is: EBS Login --> Integration Repository Administrator --(select the Integration Repository Tab)--> java -->(Your application) then the WSDL that you want to generate to




Debugging:


1- Since the Integrated SOA Gateway was working before the upgrade - so thought may be there is an issue with getting the WSDL generated so tried the following from the mid-tier:


$FND_TOP/bin/soagenerate  irepname= logfile= 


I gave the irepname that developer was using while he got the error. My irep name was "
oracle.apps.po.service.poxrqerq.POXRQERQServices_DocStyle"


The WSDL was generated fine.


2- Tried from the front end to deploy and I got the same error.


3- Now the testing time for the SOA Gateway  and found the issue.


First  Test got me to the issue. Tried following and got Error.


http://amghost5:8090/webservices/SOAProvider/?testquery


This should return " Test Response" but it  returned HTTP 500 Error.




Cause:


During the upgrade the xml file that host the ASADMIN password was reset to defalut of "welcome" while the DB has the modified password.


Solution:


edit the following file with the password that you have in DB with clear text for ASADMIN as "!MyPassw0rd" - Please note the "!" before the real password.



$ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml

The password can be verified as:

select fnd_web_sec.validate_login('ASADMIN','MyPassw0rd') from dual;

If password is not known the change the password as:

       1. Log on to Oracle E-Business Suite using sysadmin/sysadmin.

         2. Select the User Management responsibility in the Navigator.

         3. Click the Users link from the navigation menu to open the User Maintenance window.

         4. Locate 'ASADMIN' user by entering information in the search area to retrieve the 'ASADMIN' user.

         5. Click the Update icon next to the ASADMIN user to open the Update User window.

         6. Remove the Active To date field and click Apply.

         7. Click the Reset Password icon next to the ASADMIN user to open the Reset Password window.

         8. Enter new password twice and click Submit.

Restart the OAFM 

cd $ADMIN_SCRIPTS_HOME


./adoafmctl.sh stop

./adoafmctl.sh start

./adoacorectl.sh stop

./adoacorectl.sh start

Then check the status by:

./adopmnctl.sh status

Now test the SOA Gateway page again:


http://amghost5:8090/webservices/SOAProvider/?testquery 


and it resturns the test response.


Now Generate and deploy the WSDL - all is fine.