Not sure this is the correct forum to post this question, but any pointer to this issue will be highly appreciated.
When I tried to generate the .wsdl in Integrated SOA Gateway in E-business suite R12.1.4, having the following error. any clues on the below error, I followed all the installation steps and also did bounce the middle tier once.
Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service Generationoracle.jpub.Doit.main([Ljava.lang.String;, java.sql.Connection, oracle.jpub.mesg.AbstractMessages)' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details
I am facing a similar error while trying to expose a custom PL/SQL interface through Integrated SOA Gateway. I have been able to upload the custom PL/SQL method definition into iRep using an .ildt but on trying to generate the WSDL I get the following error:
Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service Generationnull' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details
I tried the following as per Oracle support and able to generate the wsdl though, but not invoke the webservices.
1. Applied the patch 8607523
2. Took the translator.jar file from the patch 8857799 and replaced the current translator.jar file
3. Deploy the adapters.
$FND_TOP/bin/txkrun.pl -script=CfgOC4JApp -applicationname=pcapps