1. Using the Oracle E-Business Suite Adapter with Oracle Integration Generation 2
  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 Application Module Service 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_Reference

  • Define mappings for REST

Create mappings for EBS_Reference:

  1. In the 'EBS Java Service Demo' integration flow, click edit for the EBS_Reference icon.

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

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

      Right-click the ctx_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 'EMPLOYEE_DIRECT_ACCESS_V4.0' for the ctx_responsibility element.

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

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

    Path Element Value
    Request (Oracle E-Business Suite)/RESTHeader ctx_respapplication 'PER'
    Request (Oracle E-Business Suite)/RESTHeader ctx_securitygroup 'STANDARD'
    Request (Oracle E-Business Suite)/FilterParameters businessGroupId '202'
    Request (Oracle E-Business Suite)/FilterParameters absenceAttendanceTypeId '12'

    Description of mappingjava.gif follows
    Description of the illustration mappingjava.gif

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

  3. Create the mappings between the source and target elements:

    • In the Source section, expand the execute node, then the QueryParameters node.

      Select the personid element.

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

      Select the personid element.

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

    Once you complete this step, the mapped source value and the corresponding target element are marked with green checks.

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

Create mappings for REST:

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

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

    • In the Source section, expand the EBS_Reference Response (Oracle E-Business Suite) node, then the getPersonAbsenceBalanceDtlsResponse node, then the getPersonAbsenceBalanceDtls_Output node, then the OutputParameters node, then the Output node, and then the PerAbsenceBalanceDataBean node.

      Select the Personid element.

    • In the Target section, expand the REST Response (REST) node, then the Response Wrapper node, then the Get Person Absence Balance Dtls node, then the OutputParameters node, then the Output node, and then the Per Absence Balance Data Bean node.

      Select the Personid element.

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

  3. Use the same approach to complete the mappings for the elements listed in the following table.

    Source Path Source Element Target Path Target Element
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean BusinessGroupId REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean BusinessGroupId
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean AbsenceAttendanceTypeId REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean AbsenceAttendanceTypeId
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean AbsenceTypeName REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean AbsenceTypeName
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean Total REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean Total
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean Taken REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean Taken
    EBS_Reference Response (Oracle E-Business Suite)/getPersonAbsenceBalanceDtlsResponse/getPersonAbsenceBalanceDtls_Output/OutputParameters/Output/PerAbsenceBalanceDataBean Planned REST Response (REST)/REST Response/get Person Absence Balance Dtls/OutputParameters/Output/Per Absence Balance Data Bean Planned

    Description of javagetperson_mapping.gif follows
    Description of the illustration javagetperson_mapping.gif

    Once you complete this step, the mapped source value and the corresponding target element are connected by a line.

    Click Validate and then click Close to save your changes when prompted.

The two mappings are all created successfully.

Click Save to save your work.