1 Reply Latest reply: Sep 3, 2013 5:58 AM by 942954 RSS

    Integrated SOA Gateway issue: SOAP UI call ends with error

    H.Yilmaz
      -- EBS 12.1.3 (no upgrade, directly installed.. is a test instance)

      Hello, i need help in calling a deployed webservice in Integrated SOA Gateway in EBS.

      -> Setup SOA Gateway is done.

      -> FND_PROFILE PL SQL API is deployed as a Webservice.

      To test the webservice i have taken the soap ui tool an send follwowing Request XML:

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:fnd="http://xmlns.oracle.com/apps/fnd/soaprovider/plsql/fnd_profile/" xmlns:get="http://xmlns.oracle.com/apps/fnd/soaprovider/plsql/fnd_profile/get/">
      <soapenv:Header>

      <wsse:Security xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" mustUnderstand="1">
           <wsse:UsernameToken>
           <wsse:Username>asadmin</wsse:Username>
           <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">welcome</wsse:Password>
           </wsse:UsernameToken>
           </wsse:Security>


           <fnd:SOAHeader>
                <!--Optional:-->
      <fnd:Responsibility>APPLICATION_DEVELOPER</fnd:Responsibility>
      <!--Optional:-->
      <fnd:RespApplication>FND</fnd:RespApplication>
      <!--Optional:-->
      <fnd:SecurityGroup>STANDARD</fnd:SecurityGroup>
      <!--Optional:-->
      <fnd:NLSLanguage>AMERICAN</fnd:NLSLanguage>
      <!--Optional:-->
      <fnd:Org_Id>204</fnd:Org_Id>
      </fnd:SOAHeader>
      </soapenv:Header>
      <soapenv:Body>
      <get:InputParameters>
      <!--Optional:-->
      <get:NAME>USER_ID</get:NAME>
      </get:InputParameters>
      </soapenv:Body>
      </soapenv:Envelope>


      The Responce is saying:

      ....
      <faultstring xmlns="">Error occured while service was processing.</faultstring>
      ...


      In the SOA Monitor i can see all Requests being send from SOA UI. The detail error message says:

      oracle.apps.fnd.soa.util.SOAException: ServiceProcessingError: Exception returned from JCA Service Runtime. file:/opt/app/OMSOAF/inst/apps/OMSOAF_sf2p-dev-oapp1/soa/PLSQL/2678/GET.wsdl [ GET_ptt::GET(InputParameters, OutputParameter) ] - WSIF JCA Execute of operation 'GET' failed due to: Could not instantiate InteractionSpec oracle.tip.adapter.apps.AppsStoredProcedureInteractionSpec due to: Error while setting JCA WSDL Property.
      Property setIRepOverloadSeq is not defined for oracle.tip.adapter.apps.AppsStoredProcedureInteractionSpec Please verify the spelling of the property.
      nested Exception is: ORABPEL-12532 Error while setting JCA WSDL Property................
      ..............


      Do anyone has an idea?

      Thank you in advice!