Invoking Web Service Delpoyed Through Integrated SOA Gateway Fails With ORA-06531: Reference to uninitialized collection (Doc ID 1633582.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On R12.1.3, invocation of API HZ_PARTY_SEARCH:FIND_PARTIES, results in the following error message:

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

SOAlog.log shows the following error:

oracle.apps.fnd.soa.provider.SOAProvider.createErrorResponseMessage : Setting fault string = 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
:Please see service monitor logs for full error trace
Wed Feb 26 12:03:19 GMT 2014 : oracle.apps.fnd.soa.provider.SOAProvider.createErrorResponseMessage : Error Response Message Created
Wed Feb 26 12:03:19 GMT 2014 : oracle.apps.fnd.soa.provider.SOAProvider.processMessage : 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
at oracle.apps.fnd.soa.provider.services.jca.JCAHandler.handleRequest(JCAHandler.java:135)
at oracle.apps.fnd.soa.provider.SOAProvider.processMessage(SOAProvider.java:366)
...
...
Caused by: org.collaxa.thirdparty.apache.wsif.WSIFException: file:/oracle/RXCDHD01/inst/apps/RXCDHD01_rxcdhd01a1/soa/PLSQL/1178/FIND_PARTIES.wsdl [ FIND_PARTIES_ptt::FIND_PARTIES(InputParameters,OutputParameters) ] - WSIF JCA Execute of operation 'FIND_PARTIES' failed due to: Error while trying to prepare and execute an API.
An error occurred while preparing and executing the ISG_HZ_PAR_FIND_P1217940.HZ_PARTY_SEARCH$FIND_PARTIES API. Cause: java.sql.SQLException: ORA-06531: Reference to uninitialized collection
ORA-06512: at "APPS.ISG_HZ_PAR_FIND_P1217940", line 1
ORA-06512: at "APPS.ISG_HZ_PAR_FIND_P1217940", line 1
ORA-06512: at line 1
[Caused by: ORA-06531: Reference to uninitialized collection
ORA-06512: at "APPS.ISG_HZ_PAR_FIND_P1217940", line 1
ORA-06512: at "APPS.ISG_HZ_PAR_FIND_P1217940", line 1
ORA-06512: at line 1
]
; nested exception is:
ORABPEL-11811
Error while trying to prepare and execute an API.

 

Cause

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 hundreds of Community platforms