Sample Payloads

This appendix covers the following topics:

Sample XSD for the Create_Invoice Activity Used in the Business Event Example

The following information shows the sample xsd used for the Create Invoice REST service. This service is added through the REST Adapter for the business event example described earlier. For information on how to use this sample xsd in an integration, see: Adding the Oracle E-Business Suite Adapter (Trigger) and the REST Adapter (Invoke) to the Integration.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="CREATE_SINGLE_INVOICE_Input">
<xs:complexType>
<xs:sequence>
<xs:element name="RESTHeader">
<xs:complexType>
<xs:sequence>
<xs:element name="Responsibility" type="xs:string"></xs:element>
<xs:element name="RespApplication" type="xs:string"></xs:element>
<xs:element name="SecurityGroup" type="xs:string"></xs:element>
<xs:element name="NLSLanguage" type="xs:string"></xs:element>
<xs:element name="Org_Id" type="xs:string"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="InputParameters">
<xs:complexType>
<xs:sequence>
<xs:element name="P_API_VERSION" type="xs:int"></xs:element>
<xs:element name="P_INIT_MSG_LIST" type="xs:string"></xs:element>
<xs:element name="P_COMMIT" type="xs:string"></xs:element>
<xs:element name="P_BATCH_SOURCE_REC">
<xs:complexType>
<xs:sequence>
<xs:element name="BATCH_SOURCE_ID" type="xs:int"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="P_TRX_HEADER_TBL">
<xs:complexType>
<xs:sequence>
<xs:element name="P_TRX_HEADER_TBL_ITEM">
<xs:complexType>
<xs:sequence>
<xs:element name="TRX_HEADER_ID" type="xs:int"></xs:element>
<xs:element name="TRX_NUMBER" type="xs:string"></xs:element>
<xs:element name="CUST_TRX_TYPE_ID" type="xs:string"></xs:element>
<xs:element name="BILL_TO_CUSTOMER_ID" type="xs:int"></xs:element>
<xs:element name="SHIP_TO_CUSTOMER_ID" type="xs:string"></xs:element>
<xs:element name="COMMENTS" type="xs:string"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="P_TRX_LINES_TBL">
<xs:complexType>
<xs:sequence>
<xs:element name="P_TRX_LINES_TBL_ITEM">
<xs:complexType>
<xs:sequence>
<xs:element name="TRX_HEADER_ID" type="xs:int"></xs:element>
<xs:element name="TRX_LINE_ID" type="xs:string"></xs:element>
<xs:element name="LINE_NUMBER" type="xs:string"></xs:element>
<xs:element name="DESCRIPTION" type="xs:int"></xs:element>
<xs:element name="QUANTITY_ORDERED" type="xs:string"></xs:element>
<xs:element name="QUANTITY_INVOICED" type="xs:int"></xs:element>
<xs:element name="UNIT_SELLING_PRICE" type="xs:string"></xs:element>
<xs:element name="LINE_TYPE" type="xs:int"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="P_TRX_DIST_TBL">
<xs:complexType>
<xs:sequence>
<xs:element name="P_TRX_DIST_TBL_ITEM">
<xs:complexType>
<xs:sequence>
<xs:element name="TRX_DIST_ID"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="P_TRX_SALESCREDITS_TBL">
<xs:complexType>
<xs:sequence>
<xs:element name="P_TRX_SALESCREDITS_TBL_ITEM">
<xs:complexType>
<xs:sequence>
<xs:element name="TRX_SALESCREDIT_ID"></xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

Sample JSON Payloads for the Oracle E-Business Suite Adapter as an Invoke Example

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: Adding 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
    }
  }
}