My Oracle Support Banner

Data Type Conversion Issue With Oracle ERP Complex BO APIs (Doc ID 2324018.1)

Last updated on NOVEMBER 15, 2023

Applies to:

Oracle SOA Suite - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

Data Type conversion issue with Oracle ERP Complex BO APIs

Doing plain conversion of 11g code to 12c and executing composites on 12.2.1.2 SOA cluster results in following type conversion error with the composite during run time

java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "<schema>.HZ_ORG_CUST_BO"

Following error was seen in the logs,

oracle.sysman.emInternalSDK.webservices.util.SoapTestException: Client received SOAP Fault from server : Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'dbReference' failed due to: Interaction processing error.
Error while processing the execution of the <schema>.HZ_ORG_CUST_BO_PUB.SAVE_ORG_CUST_BO API interaction.
An error occurred while processing the interaction for invoking the SCHEMA.HZ_ORG_CUST_BO_PUB.SAVE_ORG_CUST_BO API. Cause: java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "SCHEMA.HZ_ORG_CUST_BO"
Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-17060" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

 

java.lang.Exception: oracle.sysman.emInternalSDK.webservices.util.SoapTestException: Client received SOAP Fault from server : Exception occurred when binding was invoked.
Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'dbReference' failed due to: Interaction processing error.
Error while processing the execution of the SCHEMA.HZ_ORG_CUST_BO_PUB.SAVE_ORG_CUST_BO API interaction.
An error occurred while processing the interaction for invoking the SCHEMA.HZ_ORG_CUST_BO_PUB.SAVE_ORG_CUST_BO API. Cause: java.sql.SQLException: Fail to construct descriptor: Unable to resolve type "SCHEMA.HZ_ORG_CUST_BO"
Check to ensure that the XML containing parameter data matches the parameter definitions in the XSD. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value "-17060" to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers.
".
The invoked JCA adapter raised a resource exception.
Please examine the above error message carefully to determine a resolution.

at oracle.sysman.emas.model.wsmgt.WSTestModel.invokeOperation(WSTestModel.java:1745)
at oracle.sysman.emas.view.wsmgt.WSView.invokeOperation(WSView.java:565)
at oracle.sysman.emas.view.wsmgt.WSView.invokeTest(WSView.java:408)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.