Invoking Web Service Deployed Through Integrated SOA Gateway Fails With ORA-06531: Reference to uninitialized collection
(Doc ID 1633582.1)
Last updated on MAY 22, 2024
Applies to:
Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and laterInformation 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/RXCDHDxx/inst/apps/RXCDHDxx_xxxxxxx/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.
: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/RXCDHDxx/inst/apps/RXCDHDxx_xxxxxxx/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.
Changes
n/a
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 |