Integration

Get Involved. Join the Conversation.

Topic

    logu Prasanth
    Unable to get a Response from EBS using rest API In SOAP UI.
    Topic posted March 25, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Agent, API, Cloud, Connection, Database, E-Business Suite, ERP Cloud, Integration, Mapping, Orchestration, REST, SOAP, Web Services, xml 
    47 Views, 2 Comments
    Title:
    Unable to get a Response from EBS using rest API In SOAP UI.
    Summary:
    Unable to get REST URI Response thorough SOAP UI.
    Content:

    We are deployed PLSQL record type code in EBS as REST API. 

    we are unable to get a response through SOAP UI. we are getting below Error

    <data contentType="text/plain" contentLength="303"><![CDATA[{
     "ISGServiceFault" : {
       "Code" : "ISG_SERVICE_EXECUTION_ERROR",
       "Message" : "Error while executing service",
       "Resolution" : "Please check Server logs.",
       "ServiceDetails" : {
         "ServiceName" : "XXDH_NEW_BUD_CHK",
         "OperationName" : "create_temp_tbl",
         "InstanceId" : "0"
       }
     }
    }]]></data>

    I attached xsd file for your reference. kindly tell me the input(json type) for REST URI

    Document:

    Comment

     

    • Hemanth Lakkaraju

      The schema provided is incomplete. But this should be on similar lines

      {
        "db:CREATE_TEMP_TBL_Input": {
          "@xmlns:db": "http://xmlns.oracle.com/apps/ap/rest/XXDH_NEW_BUD_CHK/create_temp_tbl/",
          "@xmlns:head": "http://xmlns.oracle.com/apps/fnd/rest/header",
          "db:InputParameters": {
            "db:V_BUDGET_REC": { "db:PR_NUMBER": "1234" }
          }
        }
      }