Add the REST Adapter (Trigger) and Oracle E-Business Suite Adapter (Invoke) to the Integration

In this example, the orchestration flow diagram created for this integration includes the following activities:

  • The REST Adapter as a trigger activity called "REST" for the "RESTSample" connection created earlier.

    This trigger activity uses the endpoint's relative resource URI /getPersonAbsenceBalanceDtls/ through the REST Adapter.

    See: Add the REST Adapter as a Trigger (Source) Connection.

  • Mappings defined for "EBS_Reference"

    It allows you to map and pass the trigger parameters to the "EBS_Reference" activity to invoke the "Get Person Absence Type Balances" Oracle E-Business Suite REST service.

    See: Create Mappings.

  • The Oracle E-Business Suite Adapter as an invoke activity called "EBS_Reference" for "EBSDemo" connection that you created earlier.

    This invoke activity uses the "Get Person Absence Type Balances" method with the “read”operation from the "Self-Service HR" REST service when adding the Oracle E-Business Suite Adapter as an invoke. This service retrieves the available absence details from Oracle Human Resources Suite.

    See: Add the Oracle E-Business Suite Adapter as an Invoke (Target) Connection.

  • Mappings defined for "REST"

    This activity assigns the available absence related elements from the "EBS_Reference" activity to the corresponding elements in the "REST" activity.

    See: Create Mappings.


This image shows the "EBS Java Service Demo" integration diagram for using a REST Adapter as a trigger and Oracle E-Business Suite Adapter as an Invoke connection in an integration. From top to bottom are the REST Adapter "REST" Trigger icon, "EBS_Reference" mapping, Oracle E-Business Suite Adapter "EBS_Reference" Invoke icon, and "REST" mapping.

Add the REST Adapter as a Trigger (Source) Connection

After creating an integration “EBS Java Service Demo”, you need to add a trigger (source) connection in the integration. The trigger (source) connection can be any application adapters suitable for your integrations. In this example, the REST Adapter is used for the integration.

Perform the following steps to add the REST Adapter as a trigger (source) connection:

  1. In the "EBS Java Service Demo" integration canvas, click the + sign in the integration canvas or click Triggers Triggers icon on the side of the canvas. A list of trigger connections appears.

  2. Search the Oracle E-Business Suite connection called "RESTSample" from the list of selection. The REST Adapter Endpoint Configuration Wizard appears.

  3. Enter the following information in the Basic Info page:

    • What do you want to call your endpoint? - Enter the name of this endpoint, such as "REST".

    • What does this endpoint do? - Enter the usage of this endpoint, such as "Provide REST endpoint with input payload to obtain person absence details".

    • Select to configure multiple resources or verbs (maximum 11) - Leave this box unchecked.

    Click Next.

  4. Enter the following information in the Resource Configuation page:
    • What does this operation do? - Enter the usage of this operation, such as "Provide REST endpoint with input payload to obtain person absence details".

    • What is the endpoint's relative resource URI? - Enter “/getPersonAbsenceBalanceDtls/”.

    • What action does the endpoint perform? - Select "GET" from the drop-down list.

    Ensure that you select the following two check boxes for this trigger (source) connection:

    • Add and review parameters for this endpoint

    • Configure this endpoint to receive the response

    Click Next.

  5. In the Request Parameters page, perform the following tasks:


    This image shows the Request Parameters page of the REST Adapter Configuration Endpoint wizard. There are following fields displayed from top to bottom: Operation Name, Resource URI, HTTP Method, followed by Specify Query Parameters region, then below there are the Add and Remove button, then below there is a table with two columns (Name and Data Type) and one table row with corresponding values (“personid” and “integer”).

    • The Resource URI field displays the “/getPersonAbsenceBalanceDtls/” information you entered earlier.

    • In the “Specify Query Parameters” region, click Add to enter the following information in a new row:

      • Name: Enter “personid”.

      • Data Type: Select “Integer” from the list.

    Click Next.

  6. In the Response page, select the JSON Sample button for this example.

    Click <<inline>> to enter the following JSON payload:

    {
     "getPersonAbsenceBalanceDtls" : {
      "OutputParameters" : {
       "Output" : {
        "PerAbsenceBalanceDataBean" : [ {
         "Personid" : 1,
         "BusinessGroupId" : 2,
         "AbsenceAttendanceTypeId" : 3,
         "AbsenceTypeName" : "string",
         "Total" : 0.0,
         "Available" : 0.0,
         "Taken" : 0.0,
         "Planned" : 0.0
        } ]
       }
      }
     }
    }

    This image shows the Response page of the REST Adapter Configuration Endpoint Wizard, with the JSON payload entered in the Enter Sample JSON field.

    Click OK, and then Next.

  7. This displays the Summary page of the REST service information that you specified earlier. Click Done.

    Click Save to save your work. The RESTSample connection now appears in the canvas.

Add the Oracle E-Business Suite Adapter as an Invoke (Target) Connection

After adding the source connection in the integration “EBS Java Service Demo”, you can add the Oracle E-Business Suite connection "EBSDemo" as an invoke (target) connection in the integration.

Perform the following steps to add the Oracle E-Business Suite Adapter as an invoke (target) connection:

  1. In the “EBS Java Service Demo” integration canvas, hover your cursor over the lines right after the Trigger icon and then click the + sign. Search and select the "EBSDemo" connection that you created earlier from the Invokes selection.

    The Oracle E-Business Suite Adapter Configuration Endpoint Wizard appears.

  2. In the Basic Info page, enter the following information for your endpoint:

    • What do you want to call your endpoint? - Enter "EBS_Reference".

    • What does this endpoint do? - Enter "Get person absence details".

    Click Next.

  3. In the Web Services page, specify the following information for your target connection:


    This image shows the "Web Services" page of the Oracle E-Business Suite Adapter Configuration Endpoint Wizard. The following fields are displayed top to bottom, including Product Family, Product, Interface Type, API, Internal Name, and Description. In the API field, two options that are “Filter by name” and “a list of API names” are displayed top to bottom.

    • Product Family: Select "Human Resources Suite" from the drop-down list.

    • Product: Select "Human Resources".

    • Interface Type: Select "Java" from the list.

    After you select a desired product family, a product, and an interface type, a list of Java APIs including Oracle seeded APIs and custom ones contained in the selected product "Human Resources" is populated for further selection.

    Select a desired Java API name, such as “Self-Service HR”. The corresponding API internal name and description are automatically populated.

    Click Next.

  4. The selected API internal name appears in the Operations page.


    This image shows the Operations page of the Oracle E-Business Suite Adapter Endpoint Configuration Wizard. The following fields are displayed top to bottom: API, Methods, Operation, Service Status, and Description

    • Method: Select a desired method name contained in the selected “Self-Service HR” API for this invoke (target) connection. For example, select "Get Person Absence Type Balances".

    • Operation: Select “Read” as the value from the drop-down list.

    Click Next.

  5. The Summary page displays all the selected interface details. This information includes the selected "getPersonAbsenceBalanceDtls" Method and Operation “Read” (with "Ready to Use" status) contained in the selected Java REST web service from the Human Resources Suite product family and Human Resources product. This page also displays the default interaction pattern "Synchronize" for the selected service operation.

    The Oracle E-Business Suite Adapter Target Endpoint configuration is successfully created.

    Click Done.

  6. Click Save to save your work.

The connection for Oracle E-Businses Suite now appears on the canvas.