My Oracle Support Banner

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

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.