2 Replies Latest reply on Jul 12, 2019 9:18 AM by Ramaraju

    Exception 'Error occurred while generating the web service'

    Ramaraju

      Hi All,

      REST Web Service throwing following error in EBS R12.2.7

       

      Exception 'Error occurred while generating the web service' occurred when attempting to perform 'generate'. Please view Log/Error details for more information.

       

       

      http://devr12app.bluestarinc.com:8010/OA_HTML/cabo/images/skyros/t.gif
      Error in the generating PLSQL package oracle.apps.fnd.isg.common.error.ISGException: Error in the generating PLSQL package at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:498) at oracle.apps.fnd.isg.app.ebs.designer.db.DBRestDesigner.generateService(DBRestDesigner.java:52) at oracle.apps.fnd.isg.app.common.designer.AbstractServiceDesigner.designService(AbstractServiceDesigner.java:34) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateService_Internal(ServiceAdministrator.java:453) at oracle.apps.fnd.isg.app.common.admin.ServiceAdministrator.generateNdeployService(ServiceAdministrator.java:154) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:971) at oracle.apps.fnd.isg.mgmt.server.AdminService$1GenerateNDeployTask.execute(AdminService.java:953) at oracle.apps.fnd.isg.mgmt.server.ISGServerMBean$ThreadedTaskRunner.run(ISGServerMBean.java:114) at java.lang.Thread.run(Thread.java:745) Caused by: oracle.apps.fnd.isg.common.error.ISGException: Error in generating function artifacts at oracle.apps.fnd.isg.fmw11.designer.db.DBArtifactsGenerator.generateArtifacts(DBArtifactsGenerator.java:196) at oracle.apps.fnd.isg.app.common.designer.db.DBServiceDesigner.generateArtifacts(DBServiceDesigner.java:332) ... 8 more Caused by: BINDING.JCA-11819 Database type not supported. Encountered a database type APPS.XXBSI_ORDER_PUB_X7684046X4X1 that is either not supported or is not implemented. Parameter P_ORDER_LIST is of type APPS.XXBSI_ORDER_PUB_X7684046X4X1 which is either not supported or is not an implemented datatype. Check to ensure that the type of the parameter is one of the supported datatypes or that there is a collection or user defined type definition representing this type defined in the database. at oracle.tip.adapter.db.sp.xsd.oracle.DatabaseBrowser.expandParameter(DatabaseBrowser.java:210) at oracle.tip.adapter.db.sp.xsd.oracle.DatabaseBrowser.expandParameters(DatabaseBrowser.java:92) at oracle.tip.adapter.db.sp.xsd.XSDGenerator.generateInputRootElement(XSDGenerator.java:373) at oracle.tip.adapter.db.sp.xsd.XSDGenerator.generateXSD(XSDGenerator.java:441) at oracle.apps.fnd.isg.fmw11.designer.db.DBArtifactsGenerator.generateArtifacts(DBArtifactsGenerator.java:91) ... 9 more

       

      We found below Oracle Doc ID regarding this issue. It is suggest to apply Patch 16496309 but we have 12c SOA. Also they provided below workaround.

       

      WORKAROUND:

      Create a custom PL/SQL package to act as a wrapper.  The wrapper is then exposed through SOA Gateway as a REST service and accepts the event message from SOA and then makes a programmatic call to WF_EVENT.raise.  The wrapper works because it does not include any parameters that are objects with member functions.

      NOTE: As this is a customization, it is not supported.  Please be sure to follow customization practices to keep them from being removed by patching or upgrades.

      Deploy REST Service For PL/SQL Fails Due To Unsupported DataType(Doc ID 2031414.1)

       

      Can anyone please suggest on above Oracle Doc ID.

       

      Thanks,

      Ramaraju