SOA Gateway API - FND_SOA_SERVICE_EXECUTION_ERR java.sql.SQLException: ORA-04063: package body has errors ORA-06508: PL/SQL: could not find program unit being called (Doc ID 2011602.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3 version, SOA Gateway API Installation Issues

When attempting to invoke a service using a custom package, the following error occurs:


ERROR
-----------------------
Error FND_SOA_SERVICE_EXECUTION_ERR

Error Details
"4001901" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.DBConnection.getJDBCConnection" "Statement" "Obtained new Jdbc Connection via Apps DataSource"
"4001902" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.IRepAccess.getIrepName" "Statement" "IREP_NAME: GNDL_EBS_ORDER_WS fetched for msgid: 11355"
"4001903" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "irepName returned to AuditUtil is : GNDL_EBS_ORDER_WS"
"4001904" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "Response Body : SOAP-ENV:ServerFND_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"
"4001905" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "msgId : 11355"
"4001906" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "operationName : GET_EBS_ORDER_SUMMARY_INFO"
"4001907" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "responseDate : Tue Apr 28 12:35:27 EDT 2015"
"4001908" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "errorCode : FND_SOA_SERVICE_EXECUTION_ERR"
"4001909" "28-Apr-2015 12:35:27" "oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse" "Statement" "errorTrace: 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:371)
at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:958)
at oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:388)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
...

Further examination of the logs will show the following error:

java.sql.SQLException: ORA-04063: package body ""APPS.XX_Custom_Package"" has errors
ORA-06508: PL/SQL: could not find program unit being called: ""APPS.XX_Custom_Package""



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Modify an existing custom package used by the service

2. Upload the modified custom package to the Integration Repository

3. Regenerate the WSDL

4. Test the regenerated WSDL for errors

Changes

 There were changes made to the existing custom PL/SQL package in the Integration Repository, including updates to included fields, tables, etc.

The new custom PL/SQL package is then reloaded to the Integration Repository.

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