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 update operation:

To create routing rules for an update operation:

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

    The Target Type dialog is displayed.

  2. Select Service.

    The Target Services dialog is displayed.

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

  4. Select Update and click OK.

  5. Click the Filter icon.

    The Expression Builder dialog is displayed.

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

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

  7. Click OK.

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

    The Request Transformation map dialog is displayed.

  9. Select Create New Mapper File and enter SAP_TO_COMMON_UPDATE.xsl.

  10. Click OK.

    An SAP_TO_COMMON_UPDATE.xsl file is displayed.

  11. Drag and drop the top:Sap01 source element to the inp1:Customer target element.

    The Auto Map Preferences dialog is displayed.

  12. Click OK.

  13. From the Components window, select Advanced.

  14. Select XREF Functions.

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

  16. Double-click the lookupXRef icon.

    The Edit Function-lookupXRef dialog is displayed.

  17. To the right of the xrefLocation field, click Search.

    The SOA Resource Lookup dialog is displayed.

  18. Select customer.xref and click OK.

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

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

  21. In the columnName field, enter "COMMON" or click Search to select the column name.

  22. In the needException field, enter true() or click Search to select this mode.

    Figure 44-27 shows the populated Edit Function – looupXRef dialog.

    Figure 44-27 Edit Function – lookupXRef Dialog: XrefCustApp Use Case

    Description of Figure 44-27 follows
    Description of "Figure 44-27 Edit Function – lookupXRef Dialog: XrefCustApp Use Case"

  23. Click OK.

  24. From the File menu, select Save All and close the SAP_TO_COMMON_UPDATE.xsl file.

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

    Figure 44-28 Insert Operation and Update Operation

    Description of Figure 44-28 follows
    Description of "Figure 44-28 Insert Operation and Update Operation"