Soluton for Exception FND SOA SERVICE EXECUTION ERR oracle a

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

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

CC 4.0 BY-SA版权

在尝试通过测试脚本调用Oracle EBS的Webservice时遇到FND_SOA_SERVICE_EXECUTION_ERR错误，错误信息提示无法创建或访问TopLink会话。通过后端SOA日志发现具体原因是缺少DBManagedConnectionFactory(userName)属性。解决方法参考Doc 1219823.1，涉及配置部署描述符并重启服务器。

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