Sample JSON Payloads for the Oracle E-Business Suite Adapter as an Invoke Example for a PL/SQL REST Service

This section includes the JSON request and response payloads used in the example of adding the Oracle E-Business Suite Adapter as an invoke (target) connection in an integration.

For information on using these payloads, see: Add the REST Adapter as a Trigger (Source) Connection.

Sample Request Payload for the request.json File

{
  "PROCESS_ORDER_Input": {
    "RESTHeader": {
      "Responsibility": "ORDER_MGMT_SUPER_USER",
      "RespApplication": "ONT",
      "SecurityGroup": "STANDARD",
      "NLSLanguage": "AMERICAN",
      "Org_Id": "204"
    },
    "InputParameters": {
      "P_API_VERSION_NUMBER": "1.0",
      "P_INIT_MSG_LIST": "T",
      "P_RETURN_VALUES": "T",
      "P_ACTION_COMMIT": "T",
      "P_HEADER_REC": {
        "BOOKED_FLAG": "N",
        "ORDER_TYPE_ID": "1430",
        "ORG_ID": "204",
        "PAYMENT_TERM_ID": "4",
        "PRICE_LIST_ID": "1000",
        "SOLD_TO_ORG_ID": "1002",
        "TRANSACTIONAL_CURR_CODE": "USD",
        "OPERATION": "CREATE"
      },
      "P_LINE_TBL": {
        "P_LINE_TBL_ITEM": {
          "INVENTORY_ITEM_ID": "149",
          "LINE_TYPE_ID": "1427",
          "ORDERED_QUANTITY": "1",
          "PAYMENT_TERM_ID": "4",
          "PRICE_LIST_ID": "1000",
          "UNIT_LIST_PRICE": "12.55",
          "UNIT_SELLING_PRICE": "12.55",
          "OPERATION": "CREATE"
        }
      },
      "P_RTRIM_DATA": "n"
    }
  }
}

Sample Response Payload for the response.json File

{
  "OutputParameters" : {
    "X_RETURN_STATUS" : "S",
    "X_MESSAGES" : {
      "X_MESSAGES_ITEM" : [ {
        "MESSAGE_TEXT" : " Debug File: "
      } ]
    },
    "X_HEADER_REC" : {
      "ORDER_NUMBER" : 123
    }
  }
}