Perform the following tasks to create the 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 > References > SBL.

4. Select SBL and click OK.

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

   The Request Transformation map dialog is displayed.

6. Select Create New Mapper File and enter COMMON_TO_SBL_DELETE.xsl.

7. Click OK.

   A COMMON_TO_SBL_DELETE.xsl file is displayed.

8. Drag and drop the inp1:Customers source element to the db:InputParameters target element.

   The Auto Map Preferences dialog is displayed.

9. Click OK.

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

   Figure 44-39 COMMON_TO_SBL_DELETE.xsl Transformation

   
   Description of "Figure 44-39 COMMON_TO_SBL_DELETE.xsl Transformation"

10. Drag and drop the lookupXRef function from the Components window to the line connecting inp1:id and db:XCUSTOMER_ID.

11. Double-click the lookupXRef icon.

    The Edit Function: lookupXRef dialog is displayed.

12. Enter this information in the following fields:

    • xrefLocation: "customer.xref"

    • referenceColumnName: "Common"

    • referenceValue: /inp1:Customers/inp1:Customer/inp1:Id

    • columnName: "SBL_78"

    • needException: false()

13. Click OK.

14. From the File menu, select Save All and close the COMMON_TO_SBL_DELETE.xsl file.

15. In the Synchronous Reply section, click Browse for target service operations.

    The Target Type dialog is displayed.

16. Select Service.

    The Target Services dialog is displayed.

17. Navigate to XrefCustApp > References > Logger.

18. Select Write and click OK.

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

    The Reply Transformation map dialog is displayed.

20. Select Create New Mapper File and enter SBL_TO_COMMON_DELETE.xsl.

21. Click OK.

    The SBL_TO_COMMON_DELETE.xsl file is displayed.

22. Connect the db:X_APP_ID source element to the db:X:APP_ID target.

23. Drag and drop the markForDelete function from the Components window to the connecting line.

24. Double-click the markForDelete icon.

    The Edit Function-markForDelete dialog is displayed.

25. Enter this information in the following fields:

    • xrefLocation: "customer.xref"

    • columnName: "SBL_78"

    • value: /db:OutputParameters/db:X_APP_ID

26. Click OK.

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

28. In the Synchronous Reply section, click the Assign Values icon.

    The Assign Values dialog is displayed.

29. Click Add.

    The Assign Value dialog is displayed.

30. In the From section, select Expression.

31. Click the Invoke Expression Builder icon.

    The Expression Builder dialog is displayed.

32. In the Expression field, enter the following expression, and click OK.

    concat('DELETE-',$in.OutputParameters/db:OutputParameters/db:X_APP_ID,'.xml')
    

33. In the To section, select Property.

34. Select the jca.file.FileName property and click OK.

35. Click OK.

    The delete operation section appears, as shown in Figure 44-40.

    Figure 44-40 Delete Operation with SBL Target Service

    
    Description of "Figure 44-40 Delete Operation with SBL Target Service"

36. From the File menu, select Save All.

37. Repeat Step 1 through Step 36 to specify another target service named EBS and specify the routing rules.

    Figure 44-41 shows the delete operation section with SBL and EBS target services.

    Figure 44-41 Delete Operation with SBL and EBS Target Service

    
    Description of "Figure 44-41 Delete Operation with SBL and EBS Target Service"