Create Mappings

Oracle E-Business Suite Business Event is defined by the WF_EVENT_T data structure. After adding the required connections to the integration, you need to create the following mappings to pass the required parameter values to the subsequent REST services:

  • Define mappings for Get_Order

  • Define mappings for Create_Invoice

Create Mappings for Get_Order

In this example, a sales order Header Id is available as one of the business event parameters. In WF_EVENT_T, event parameters are available as Name-Value pair in repeating Parameter element. To obtain the value of the Header Id parameter and pass it to the subsequent Get_Order service call, you need to create mappings for Get_Order.

  1. In the Order_Status_Update integration flow, click edit for the Map to Get_Order icon.

    The mapper is displayed.


    Description of order_update_map.gif follows
    Description of the illustration order_update_map.gif

  2. In the mapper, the business event related elements are displayed in the Source section, whereas the Get_Order related parameters are listed in the Target area. To obtain the value of the sales order Header Id (P_HEADER_ID) included as part of the event parameters and pass it to the subsequent Get_Order REST service, you need to define the XSL expression for the P_HEADER_ID parameter.

  3. Define the XSL expression for the P_HEADER_ID parameter by performing the following tasks:

    1. In the Target section, expand the GET_ORDER_Input node, and then the InputParameters node. Click the P_HEADER_ID element to open the Build Mappings page.

    2. In the Mapping area of the Build Mappings page, notice that the P_HEADER_ID element is displayed as the Target element.

    3. In Source section of the Build Mappings page, expand the BusinessEvent_Input node, then the InputParameters node, then the BusinessEvent node, then the ParameterList node, and then the Parameter node.

    4. Drag and drop the Value element from the Source section to the Mapping section as the value for the P_HEADER_ID element.

    5. Similarly, drag and drop the XSL element "if" and the Name element from the Source section to the Mapping section to define the XSL expression <xsl:if test="nssrcmpr:Name='HEADER_ID'">.

    6. Drag and drop the XSL element "for-each" from the Source section to the Mapping section to define the XSL expression <xsl:for-each select="/nssrcmpr:BusinessEvent_Input/nssrcmpr:InputParameters/nssrcmpr:BusinessEvent/nssrcmpr:ParameterList/nssrcmpr:Parameter">.


      Description of map_for_p_header_id.gif follows
      Description of the illustration map_for_p_header_id.gif
    7. Save your work.

      Expand the nodes to ensure that the P_HEADER_ID parameter is included as part of the structure.

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

    1. In the Target section, expand the GET_ORDER_Input node, and then the RESTHeader node.

      Click the Responsibility element to open the Build Mappings page.

    2. Enter "ORDER_MGMT_SUPER_USER" in the text box as the value for the Responsibility element.

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

    Path Element Value
    GET_ORDER_Input/RESTHeader RespApplication ONT
    GET_ORDER_Input/RESTHeader SecurityGroup STANDARD
    GET_ORDER_Input/RESTHeader NLSLanguage AMERICAN
    GET_ORDER_Input/RESTHeader Org_Id 204
    GET_ORDER_Input/InputParameters P_API_VERSION_NUMBER 1.0
    GET_ORDER_Input/InputParameters P_INIT_MSG_LIST F
    GET_ORDER_Input/InputParameters P_ORG_ID 204

    After you complete the mappings for Get_Order, the mapped source values should appear in the Mapping column of the Target section.


    Description of getorder_mapper.gif follows
    Description of the illustration getorder_mapper.gif
  5. Click Save to save your work.

Create Mappings for Create_Invoice

Perform the following steps to create the mappings:

  1. In the Order_Status_Update integration flow, click edit for the Map to Create_Invoice icon.

    The mapper appears.

  2. Assign constant values to the target elements.

    1. In the Target section, expand the execute node, then the CREATE_SINGLE_INVOICE_Input node, and then the RESTHeader node.

      Click the Responsibility element to open the Build Mappings page.

    2. Enter "RECEIVABLES_VISION_OPERATIONS" in the text box as the value for the Responsibility element.

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

    Path Element Value
    CREATE_SINGLE_INVOICE_Input/RESTHeader RespApplication AR
    CREATE_SINGLE_INVOICE_Input/RESTHeader SecurityGroup STANDARD
    CREATE_SINGLE_INVOICE_Input/RESTHeader NLSLanguage AMERICAN
    CREATE_SINGLE_INVOICE_Input/RESTHeader Org_Id 204
    CREATE_SINGLE_INVOICE_Input/InputParameters P_API_VERSION 1.0
    CREATE_SINGLE_INVOICE_Input/InputParameters P_INIT_MSG_LIST T
    CREATE_SINGLE_INVOICE_Input/InputParameters P_COMMIT T
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_BATCH_SOURCE_REC BATCH_SOURCE_ID 1188
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_HEADER_TBL/P_TRX_HEADER_TBL_ITEM TRX_HEADER_ID 101
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_HEADER_TBL/P_TRX_HEADER_TBL_ITEM CUST_TRX_TYPE_ID 1684
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_HEADER_TBL/P_TRX_HEADER_TBL_ITEM BILL_TO_CUSTOMER_ID 1290
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_HEADER_TBL/P_TRX_HEADER_TBL_ITEM SHIP_TO_CUSTOMER_ID 1290
    CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_HEADER_TBL/P_TRX_HEADER_TBL_ITEM COMMENTS Invoice created via ICS integration for booked Sales Order in Order Management

    After you complete this step, the mapped source values should appear in the Mapping column of the Target section.


    Description of mapper_constant.gif follows
    Description of the illustration mapper_constant.gif
  3. Add the following mapping for the header:

    • In the Source section, enter "HEADER_ID" in the Search field to locate this parameter.

      Select the HEADER_ID element from the X_HEADER_REC node.

    • In the Target section, expand the execute node, then the CREATE_SINGLE_INVOICE_Input node, then the InputParameters node, then the P_TRX_HEADER_TBL node, and then the P_TRX_HEADER_TBL_ITEM node.

      Select the TRX_NUMBER element.

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

    After the mapping, the source element HEADER_ID should appear in the Mapping column next to the TRX_NUMBER element in the Target section.


    Description of mapping-header_id.gif follows
    Description of the illustration mapping-header_id.gif
  4. Use the same approach, as described in the previous step, to add the following sets of mappings for the line items:

    Source Path Source Element Target Path Target Element
    BusinessEvent_Input/InputParameters/BusinessEvent/X_LINE_TBL/X_LINE_TBL_ITEM LINE_NUMBER execute/CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_LINES_TBL/P_TRX_LINES_TBL_ITEM LINE_NUMBER
    BusinessEvent_Input/InputParameters/BusinessEvent/X_LINE_TBL/X_LINE_TBL_ITEM ORDERED_ITEM execute/CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_LINES_TBL/P_TRX_LINES_TBL_ITEM DESCRIPTION
    BusinessEvent_Input/InputParameters/BusinessEvent/X_LINE_TBL/X_LINE_TBL_ITEM ORDERED_QUANTITY execute/CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_LINES_TBL/P_TRX_LINES_TBL_ITEM QUANTITY_ORDERED
    BusinessEvent_Input/InputParameters/BusinessEvent/X_LINE_TBL/X_LINE_TBL_ITEM ORDERED_QUANTITY execute/CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_LINES_TBL/P_TRX_LINES_TBL_ITEM QUANTITY_INVOICED
    BusinessEvent_Input/InputParameters/BusinessEvent/X_LINE_TBL/X_LINE_TBL_ITEM UNIT_SELLING_PRICE execute/CREATE_SINGLE_INVOICE_Input/InputParameters/P_TRX_LINES_TBL/P_TRX_LINES_TBL_ITEM UNIT_SELLING_PRICE

    Once you complete this step, the mapped source values should appear next to the corresponding target elements with the green check mark icons:


    Description of mapper_line.gif follows
    Description of the illustration mapper_line.gif
  5. Assign the following values:

    • In the Target section, expand the execute node, then the CREATE_SINGLE_INVOICE_Input node, then the InputParameters node, and then the P_TRX_DIST_TBL node.

      Click the P_TRX_DIST_TBL_ITEM element to open the Build Mappings page.

      In the Mapping section, enter the following information:

      <nsmpr1:P_TRX_DIST_ID/>.

    • In the Target section, expand the execute node, then the CREATE_SINGLE_INVOICE_Input node, then the InputParameters node, and then the P_TRX_SALESCREDITS_TBL node.

      Click the P_TRX_SALESCREDITS_TBL_ITEM element to open the Build Mappings page.

      In the Mapping area, enter the following information:

      <nsmpr1:P_TRX_SALESCREDITS_ID/>.

    The newly assigned mapping values should appear next to the corresponding elements in the Target section.


    Description of mapper_target.gif follows
    Description of the illustration mapper_target.gif

    Save your work.

  6. Click Exit Mapper.

  7. Save the integration.