1. Developing SOA Applications with Oracle SOA Suite
  2. Sharing Functionality Across Service Components
  3. Working with Cross References
  4. Creating and Running the Cross Reference Use Case
  5. How to Create the Use Case
  6. Task 8: How to Specify Routing Rules for an Oracle Mediator Service Component
  7. To create routing rules for an insert operation:

To create routing rules for an insert operation:

  1. Double-click the Mediator1 Oracle Mediator.

    The Mediator Editor is displayed.

  2. In the Routing Rules section, click the Create a new Routing Rule icon.

    The Target Type dialog is displayed.

  3. Select Service.

    The Target Services dialog is displayed.

  4. Navigate to XrefCustApp > Mediators > Common, Services > Common.

  5. Select Insert and click OK.

  6. Click the Filter icon.

    The Expression Builder dialog is displayed.

  7. In the Expression field, enter the following expression: 

    $in.Sap01Collection/top:Sap01Collection/top:Sap01/top:operation='INSERT'

  8. Click OK.

  9. Next to the Transform Using field, click the Transformation icon.

    The Request Transformation map dialog is displayed.

  10. Select Create New Mapper File and enter SAP_TO_COMMON_INSERT.xsl.

  11. Click OK.

    An SAP_TO_COMMON_INSERT.xsl file is displayed in the XSLT Mapper.

  12. Drag and drop the top:SAP01 source element to the inp1:Customer target element.

    The Auto Map Preferences dialog is displayed.

  13. From the During Auto Map options, deselect Match Elements Considering their Ancestor Names.

  14. Click OK.

    The transformation is created, as shown in Figure 44-24.

    Figure 44-24 SAP_TO_COMMON_INSERT.xsl Transformation

    Description of Figure 44-24 follows
    Description of "Figure 44-24 SAP_TO_COMMON_INSERT.xsl Transformation"

  15. From the Components window, select Advanced.

  16. Select XREF Functions.

  17. Drag and drop the populateXRefRow function from the Components window to the line connecting the top:id and inp1:id elements.

  18. Double-click the populateXRefRow icon.

    The Edit Function-populateXRefRow dialog is displayed.

  19. Click Search to the right of the xrefLocation field.

    The SOA Resource Lookup dialog is displayed.

  20. Select customer.xref and click OK.

  21. In the referenceColumnName field, enter "SAP_01" or click Search to select the column name.

  22. In the referenceValue column, enter /top:Sap01Collection/top:Sap01/top:id.

  23. In the columnName field, enter "Common" or click Search to select the column name.

  24. In the value field, enter oraext:generate-guid().

  25. In the mode field, enter "Add" or click Search to select this mode.

    Figure 44-25 shows the populated Edit Function – populateXRefRow dialog.

    Figure 44-25 Edit Function – populateXRefRow Dialog: XrefCustApp Use Case

    Description of Figure 44-25 follows
    Description of "Figure 44-25 Edit Function – populateXRefRow Dialog: XrefCustApp Use Case"

  26. Click OK.

  27. From the File menu, select Save All and close the SAP_TO_COMMON_INSERT.xsl file.

    The Routing Rules section appears, as shown in Figure 44-26.

    Figure 44-26 Routing Rules Section with Insert Operation

    Description of Figure 44-26 follows
    Description of "Figure 44-26 Routing Rules Section with Insert Operation"