Soluton for Exception:FND_SOA_SERVICE_EXECUTION_ERR:oracle.apps.fnd.soa.util.SOAException-优快云博客

使用测试脚本调用Oracle EBS的一Webservice，报下边的错误：

FND_SOA_SERVICE_EXECUTION_ERR:oracle.apps.fnd.soa.util.SOAException: ServiceExecutionError: Error while executing the service Exception returned from JCA Service Runtime. Exception returned from JCA Service Runtime. null

从后端收集SOA Log里能够看到详细的错误信息:

Caused by: org.collaxa.thirdparty.apache.wsif.WSIFException: file:/xxx/soa/PLSQL/4392/XXXXXWS.wsdl [ XXXXXWS_ptt::XXXXXWS(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'XXXXXWS' failed due to: Could not create/access the TopLink Session.
This session is used to connect to the datastore.
; nested exception is:
ORABPEL-11622
Could not create/access the TopLink Session.
This session is used to connect to the datastore.
See root exception for the specific exception. You may need to configure the connection settings in the deployment descriptor (i.e. $J2EE_HOME/application-deployments/default/DbAdapter/oc4j-ra.xml) and restart the server. Caused by javax.resource.spi.InvalidPropertyException: Missing Property Exception.
Missing Property: [DBManagedConnectionFactory.userName].
Make sure the property is set in the interaction (activation) spec by editing its definition in the wsdl.
.

at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:642)
at oracle.tip.adapter.client.JCABindingOperation.invokeWsifProvider(JCABindingOperation.java:275)
at oracle.tip.adapter.client.JCABindingOperation.executeRequestResponseOperation(JCABindingOperation.java:182)
... 30 more