SOA Gateway Custom PL/SQL Packages Deployed As REST Web Service Fail with Error 'FND_SOA_SERVICE_GENERATION_ERR##ServiceGenerationError: Error in Service GenerationProcedure not found' (Doc ID 2185000.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

Oracle E-Business Suite Integrated SOA Gateway - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.1.3 Integrated SOA Gateway, Installation issues

 



Referencing the below documentation to publish a custom PL/SQL package as REST web service on Integrated SOA gateway - EBS 12.1.3:

https://docs.oracle.com/cd/E18727_01/doc.121/e12065/T511473T543283.htm#sigdg_customannot


Users report the following error when publishing custom PL/SQL packages as REST web service on Integrated SOA gateway EBS 12.1.3:

ERROR
======
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.ui.ProviderAccess.generateWSDL : Generating Service : 1000
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : Sending Message : Generate:serviceType=REST&alias=USER_CREATION
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : For Class Id : 1000
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : Encoded ClassId : 1000
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : SOA_SERVER_URL : https://<machine>.domain.com:443
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : Host : https://<machine>.domain.com:443
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : Port : 443
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.sendMessageToServer : ticket is null : false
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.analyzeServerResponse : Input : false##FND_SOA_SERVICE_GENERATION_ERR##ServiceGenerationError: Error in Service GenerationProcedure not found: APPS.APPS.XX_GET_USER_CREATION_SOAGWAY.XX_USER_CREATION
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.analyzeServerResponse : ErrorCode from server : FND_SOA_SERVICE_GENERATION_ERR
Wed Aug 31 12:23:13 CDT 2016 : oracle.apps.fnd.soa.provider.util.ServerAccess.analyzeServerResponse : Throwing Exception from server : ServiceGenerationError: Error in Service GenerationProcedure not found: APPS.APPS.XX_GET_USER_CREATION_SOAGWAY.XX_USER_CREATION



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