Soluton for Exception:FND_SOA_SERVICE_EXECUTION_ERR:oracle.apps.fnd.soa.util.SOAException

最新推荐文章于 2025-09-16 10:39:54 发布

最新推荐文章于 2025-09-16 10:39:54 发布 · 924 阅读

文章标签：

本文解决了一个关于使用测试脚本调用OracleEBS的Webservice时出现的错误问题。错误提示为FND_SOA_SERVICE_EXECUTION_ERR，并在SOA日志中详细记录了异常原因，涉及TopLinkSession创建及连接数据存储的问题。解决方案包括检查部署描述符中的连接设置。

使用测试脚本调用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