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 a delete operation:

To create routing rules for a delete 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 delete 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 = 'DELETE'

  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_DELETE.xsl.

  10. Click OK.

    A SAP_TO_COMMON_DELETE.xsl file is displayed.

  11. Right-click <sources> and select Add Parameter.

    The Add Parameter dialog is displayed.

  12. In the Local Name field, enter COMMONID.

  13. Select Set Default Value.

  14. Select Expression.

  15. In the XPath Expression field, enter 

    xref:lookupXRef("customer.xref","SAP_
01",/top:Sap01Collection/top:Sap01/top:id,"COMMON",false()).

  16. Click OK.

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

    The Auto Map Preferences dialog is displayed.

  18. Click OK.

  19. Delete the line connecting top:id and inp1:id.

  20. Connect COMMONID to inp1:id.

  21. Right-click inp1:id and select Add XSL node and then if.

    A new node if is inserted between inp1:customer and inp1:id.

  22. Connect top:id to the if node.

  23. From the Components window, select Advanced.

  24. Select XREF Functions.

  25. Drag and drop the markForDelete function from the Components window to the line connecting top:id and the if node.

  26. Double-click the markForDelete icon.

    The Edit Function-markForDelete dialog is displayed.

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

    The SOA Resource Lookup dialog is displayed.

  28. Select customer.xref and click OK.

  29. In the columnName field, enter "SAP_01" or click Search to select the column name.

  30. In the value field, enter /top:Sap01Collection/top:Sap01/top:Id.

    Figure 44-32 shows a populated Edit Function – markForDelete dialog.

    Figure 44-32 Edit Function – markForDelete Dialog: XrefCustApp Use Case

    Description of Figure 44-32 follows
    Description of "Figure 44-32 Edit Function – markForDelete Dialog: XrefCustApp Use Case"

  31. Click OK.

    The SAP_TO_COMMON_DELETE.xsl file appears, as shown in Figure 44-33.

    Figure 44-33 SAP_TO_COMMON_DELETE.xsl

    Description of Figure 44-33 follows
    Description of "Figure 44-33 SAP_TO_COMMON_DELETE.xsl"

  32. From the File menu, select Save All and close the SAP_TO_COMMON_DELETE.xsl file.

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

    Figure 44-34 Insert, Update, UpdateID, and Delete Operations

    Description of Figure 44-34 follows
    Description of "Figure 44-34 Insert, Update, UpdateID, and Delete Operations"