1. Using the Oracle E-Business Suite Adapter with Oracle Integration Generation 2
  2. Oracle E-Business Suite Adapter Samples
  3. An Example of Using a PL/SQL REST Service as an Invoke (Target) Connection in an Integration
  4. Create Mappings

Create Mappings

This step is to create mappings between the source and target data structures in the integration. It includes the following mappings:

  • mappings for EBS_Reference
  • mappings for Source

Create mappings for EBS_Reference:

  1. In the Create Order integration flow, click edit for the Map to EBS_Reference icon. The mapper is displayed.
  2. In the mapper, perform the following tasks to create mappings:

    • In the Source section, expand the Source Request (REST) node, then the Request Wrapper node, then the PROCESSORDER Input node, and then the InputParameters node.

      Select the P_API_VERSION_NUMBER element.

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

      Select the P_API_VERSION_NUMBER element.

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

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


    At the top left are the Developer, Code, Test, and Recommend buttons. To the right are the Developer, XSLT, View, and Filter buttons. Below this are the Sources, Mapping Canvas, and Target sections. The P_API_VERSION_NUMBER source data element is mapped to the same P_API_VERSION_NUMBER target data element.

    Similarly, use the same approach to complete the mappings for the elements listed in the following table.

    Source Path Source Element Target Path Target Element
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/RESTHeader Responsibility EBS_Reference Request (Oracle E-Business Suite)/RESTHeader Responsibility
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/RESTHeader RespApplication EBS_Reference Request (Oracle E-Business Suite)/RESTHeader RespApplication
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/RESTHeader SecurityGroup EBS_Reference Request (Oracle E-Business Suite)/RESTHeader SecurityGroup
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/RESTHeader NLSLanguage EBS_Reference Request (Oracle E-Business Suite)/RESTHeader NLSLanguage
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/RESTHeader Org_Id EBS_Reference Request (Oracle E-Business Suite)/RESTHeader Org_Id
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/Input Parameters P_INIT_MSG_LIST EBS_Reference Request (Oracle E-Business Suite)/InputParameters P_INIT_MSG_LIST
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/Input Parameters P_RETURN_VALUES EBS_Reference Request (Oracle E-Business Suite)/InputParameters P_RETURN_VALUES
    Source Request (REST)/Request Wrapper/ PROCESSORDER Input/Input Parameters P_ACTION_COMMIT EBS_Reference Request (Oracle E-Business Suite)/InputParameters P_ACTION_COMMIT

  3. Once the mapping is complete, click Validate and Close to save your work.

  4. Click Exit Mapper.

Create mappings for Source:

  1. In the Create Order integration flow, click edit for the Map to Source icon. The mapper is displayed.

  2. In the mapper, perform the following tasks to create mappings:

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

      Select the X_RETURN_STATUS element.

    • In the Target section, expand the Source Reponse (REST) node, then the Response Wrapper node, and then the Output Parameters node.

      Select the X_RETURN_STATUS element.

    Drag the X_RETURN_STATUS element from the Source section to the X_RETURN_STATUS 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)/PROCESS_ORDERResponse/OutputParameters/X_MESSAGES/X_MESSAGES_ITEM MESSAGE_TEXT Source Reponse (REST)/Response Wrapper/OutputParameters/X_MESSAGES/X_MESSAGES_ITEM MESSAGE_TEXT
    EBS_Reference Response (Oracle E-Business Suite)PROCESS_ORDERResponse/OutputParameters/X_HEADER_REC ORDER_NUMBER Source Reponse (REST)/Response Wrapper/OutputParameters/X_HEADER_REC ORDER_NUMBER

    At the top left are the Developer, Code, Test, and Recommend buttons. To the right are the Developer, XSLT, View, and Filter buttons. Below this are the Sources, Mapping Canvas, and Target sections. The X_RETURN_STATUS, MESSAGE_TEXT, and ORDER_NUMBER source data elements are mapped to the X_RETURN_STATUS, MESSAGE_TEXT, and ORDER_NUMBER target data elements respectively.

    Once the mapping is complete, click Validate and Close to save your work.

  4. Click Exit Mapper.

Click Save to save your work.