My Oracle Support Banner

Cannot Deploy a Service due to Erorr Could not Find Annotated plsql Procedure in Database (Doc ID 2442330.1)

Last updated on MAY 01, 2019

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 : 12.1.3 version, Installation Issues
When trying to deploy INV_LOT_API_PUB and INV_SERIAL_NUMBER_PUB Web Services, errors are generated.

ERROR
-----------------------

Error Deploying INV_SERIAL_NUMBER_PUB:
Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: WsdlParseError: WsdlParseError: Error in WSDL Parsing. /oracle/EBS/inst/apps/<ServerName>_<SID>/soa/PLSQL/2417/INV_SERIAL_NUMBER_PUB_soap_http.wsdl (No such file or directory)' when attempting to perform 'GETSOAPWSDL'. Please view Service Provider logs for more details
Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service GenerationProcedure not found: APPS.INV_SERIAL_NUMBER_PUB.POPULATEATTRIBUTESCOLUMN' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details

Error Deploying INV_LOT_API_PUB:
Service Provider Access resulted in exception 'oracle.apps.fnd.soa.util.SOAException: ServiceGenerationError: ServiceGenerationError: Error in Service Generation Could not find annotated plsql procedure in database!!!' when attempting to perform 'GENERATE'. Please view Service Provider logs for more details

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Integrated SOA Gateway
2. Integration Repository
3. Find the service
4. Click on Deploy

Changes

 

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


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