My Oracle Support Banner

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 DECEMBER 04, 2019

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: Irep_name_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 : Irep_name_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 :XXX"
"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

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


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