My Oracle Support Banner

Invoking JCA Adapter Crashes (Doc ID 2366965.1)

Last updated on MARCH 06, 2018

Applies to:

Oracle Service Bus - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.1.3.0 version, OSB Core Functionality

Invoking JCA adapter Crashes

When Invoking JCA adapter from pipeline it crashes, but when calling the Business Service Directly it is working fine.

ERROR
-----------------------
OSB-380001,BINDING.JCA-11633

Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.tip.adapter.sa.api.JCABindingException: oracle.tip.adapter.sa.impl.fw.ext.org.collaxa.thirdparty.apache.wsif.WSIFException: servicebus:/bus.svc/PowerCard/CardActivity/wsdl/bus_svc_PowerCard_CardActivityTable_getData.wsdl [ bus_svc_PowerCard_CardActivityTable_getData_ptt::bus.svc.PowerCard.CardActivityTable.getData(bus.svc.PowerCard.CardActivityTable.getDataInput_msg,bus.svc.PowerCard.CardActivityTable.getDataOutputCollection) ] - WSIF JCA Execute of operation 'bus.svc.PowerCard.CardActivityTable.getData' failed due to: Pure SQL Exception.
Pure SQL Execute of select CHANNEL, SERVICE_TYPE, SERVICE_REFERENCE, IDENTIFIER_ID, IDENTIFIER_TYPE, CR_ACCOUNT_NBR, TRANSACTION_REF_NUM, to_char(STATEMENT_DATE,'yyyy-mm-dd hh:mm:ss') , to_char(TRANSACTION_DATE,'yyyy-mm-dd hh:mm:ss'), TRANSACTION_TYPE, DEBIT_CREDIT_FLAG, BILLING_AMOUNT, BILLING_CURRENCY, MERCHANT_NAME, MERCHANT_CITY, TRANSACTION_AMOUNT, TRANSACTION_CURRENCY, TRANSACTION_DESC, TRANSACTION_STATUS, INSTALLMENT_AMOUNT, INSTALLMENT_CURRENCY, OUTSTANDING_BALANCE from AUDI_MW_CARD_ACTIVITY_TABLE_V1 where SERVICE_REFERENCE = ? failed.
Caused by java.sql.SQLException: Missing IN or OUT parameter at index:: 1.
; nested exception is:
 BINDING.JCA-11633
Pure SQL Exception.

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!


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