1. Using the Oracle E-Business Suite Adapter with Oracle Integration 3
  2. Oracle E-Business Suite Adapter Samples
  3. Examples of Using a Java REST Service as an Invoke (Target) Connection in an Integration
  4. Use a Java REST Service of Business Service Object Subtype as an Invoke (Target) Connection
  5. Create Mappings

Create Mappings

After adding the trigger (source) connection and invoke (target) connection in your integration, you can create the following mappings to pass the required parameter values to the subsequent REST services:

  • Define mappings for EBS_Site request

  • Define mappings for RESTSample response

Create mappings for EBS_Site request:

  1. In the 'EBS Site' integration flow, click Edit Edit icon for the EBS_Site icon.

  2. Perform the following tasks to create mappings between elements:

    • In the Source section, expand the RESTSample Request (REST) node, then the Request Wrapper node, and then the Site node.

      Select the Site Number element.

    • In the Target section, expand the EBS_Site Request (Oracle E-Business Suite) node, then the InputParameters node, and then the site node. Select the SiteNumber element.

    Drag the Site Number element from the Source section to the SiteNumber element in the Target section to map the data.

    Similarly, use the same approach to map the elements from the same Source location to the same Target location listed in the following table:

    Source Element Target Element
    Site Name SiteName
    Site Type SiteType
    Site Status SiteStatus
    Brand Name BrandName
    Country Country
    Address1 Address1

    The Site Number, Site Name, Site Type, Site Status, Brand Name, Country, and Address 1 source elements are mapped to the same corresponding target elements.

  3. Perform the following tasks to assign constant values to the target elements:

    • In the Target section, expand the EBS_Site Request (Oracle E-Business Suite) node, and then the RESTHeader node.

      Right-click the Responsibility element and select Create Target Node from the drop-down menu.

    • In the Expression Builder at the bottom of the page, click the "Switch to Developer View" icon and then enter 'RRS_USER' for the Responsibility element. Save your entry.

      A function icon is added to the Mapping Canvas section for the target Responsibility element node.

    Similarly, use the same approach to assign constant values to the target elements listed in the following table:

    Path Element Value
    EBS_Site Request (Oracle E-Business Suite)/RESTHeader RespApplication 'RRS'
    EBS_Site Request (Oracle E-Business Suite)/RESTHeader NLSLanguage 'AMERICAN'

    This image shows the mapper for the EBS_Site activity. At the top left are the Designer, Code, and Test buttons. To the right are the Developer, XSLT, View, and Filter buttons. Below this are the Sources, Mapping Canvas, and Target sections. The Site Number, Site Name, Site Status, Brand Name, Country, and Address1 source data elements are mapped to the same correponding elements under the Site node of the Target section. Three function boxes are visible in the Mapping Canvas for the Responsibility, RespApplication, and NLSLanguage target data elements.

    After you complete this step, the function icons should appear in the Mapping Canvas section for the corresponding target elements.

  4. Click Validate and then exit the Mapper. Click Save to save your work.

Create mappings for RESTSample response:

  1. In the middle of the integration, click edit for the RESTSample icon.

  2. Create mappings to map the source and target elements.

    • In the Source section, expand the EBS_Site Response (Oracle E-Business Suite) node, then the createSiteResponse node, then the createSite_Output node, and then the OutputParameters node.

      Select the string element.

    • In the Target section, expand the RESTSample Response (REST) node, and then the Response Wrapper node.

      Select the Message element.

    Drag the string element from the Source section to the Message element in the Target section to map the data.


    The string element in the Source section is mapped to the Message element in the Target section.

  3. Click Validate and then exit the Mapper. Click Save to save your work.