1 Reply Latest reply: Dec 14, 2011 3:33 PM by lonneke RSS

    Error occured while service was processing while invoking Emp WS

    user10361326
      Getting error <faultstring>Error occured while service was processing.</faultstring> while invoking the Employee pl/sql webservice. Below is the payload I am sending to the webservice that is deployed in R12.1 instance using iRep. Please help.

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:hr="http://xmlns.oracle.com/apps/per/soaprovider/plsql/hr_employee_api/" xmlns:cre="http://xmlns.oracle.com/apps/per/soaprovider/plsql/hr_employee_api/create_employee/">
      <soapenv:Header>
      <hr:SOAHeader>
      <hr:Responsibility>SYSTEM_ADMINISTRATOR</hr:Responsibility>
      <hr:RespApplication>SYSADMIN</hr:RespApplication>
      <hr:SecurityGroup>Standard</hr:SecurityGroup>
      <hr:NLSLanguage>AMERICAN</hr:NLSLanguage>
      <hr:Org_Id>204</hr:Org_Id>
      </hr:SOAHeader>
      <wsse:Security soapenv:mustUnderstand="1" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
      <wsse:UsernameToken wsu:Id="UsernameToken-Vm6jzMWeZx220sdBFHZ93A22" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
      <wsse:Username>SYSADMIN</wsse:Username>
      <wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">x</wsse:Password>
      </wsse:UsernameToken>
      </wsse:Security>
      </soapenv:Header>
      <soapenv:Body>
      <cre:InputParameters>
      <cre:P_VALIDATE>false</cre:P_VALIDATE>
      <cre:P_HIRE_DATE>17-JUN-07</cre:P_HIRE_DATE>
      <cre:P_BUSINESS_GROUP_ID>202</cre:P_BUSINESS_GROUP_ID>
      <cre:P_LAST_NAME>Employee</cre:P_LAST_NAME>
      <cre:P_SEX>M</cre:P_SEX>
      <cre:P_PERSON_TYPE_ID>13</cre:P_PERSON_TYPE_ID>
      <cre:P_PER_COMMENTS>Test</cre:P_PER_COMMENTS>
      <cre:P_DATE_EMPLOYEE_DATA_VERIFIED></cre:P_DATE_EMPLOYEE_DATA_VERIFIED>
      <cre:P_DATE_OF_BIRTH>01-JAN-1981</cre:P_DATE_OF_BIRTH>
      <cre:P_EMAIL_ADDRESS>x@gmail.com</cre:P_EMAIL_ADDRESS>
      <cre:P_EMPLOYEE_NUMBER>123421</cre:P_EMPLOYEE_NUMBER>
      <cre:P_EXPENSE_CHECK_SEND_TO_ADDRES></cre:P_EXPENSE_CHECK_SEND_TO_ADDRES>
      <cre:P_FIRST_NAME>ORACLE FORUM 3</cre:P_FIRST_NAME>
      <cre:P_KNOWN_AS>Raj</cre:P_KNOWN_AS>
      </cre:InputParameters>
      </soapenv:Body>
      </soapenv:Envelope>