Perform the following tasks to create routing rules for the 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 XrefOrderApp > References > EBS.

4. Select EBS and click OK.

5. Click the Transformation icon next to the Transform Using field.

   The Request Transformation map dialog is displayed.

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

7. Click OK.

   The COMMON_TO_EBS_UPDATE.xsl file is displayed.

8. Drag and drop the inp1:Orders 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.

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

11. Double-click the lookupXRef icon.

    The Edit Function: lookupXRef dialog is displayed.

12. Enter this information in the following fields:

    • xrefLocation: order.xref

    • referenceColumnName: Common

    • referenceValue: /inp1:Customers/inp1:Order/inp1:Id

    • columnName: EBS_i75

    • needException: true()

13. Click OK.

14. From the File menu, select Save All and close the COMMON_TO_EBS_UPDATE.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 XrefOrderApp > 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 EBS_TO_COMMON_UPDATE.xsl.

21. Click OK.

    The EBS_TO_COMMON_UPDATE.xsl file is displayed.

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

23. From the File menu, select Save All and close the EBS_TO_COMMON_UPDATE.xsl file.

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

    The Assign Values dialog is displayed.

25. Click Add.

    The Assign Value dialog is displayed.

26. In the From section, select Expression.

27. Click the Invoke Expression Builder icon.

    The Expression Builder dialog is displayed.

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

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

29. In the To section, select Property.

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

31. Click OK.

    The update operation section appears, as shown in Figure 44-62.

    Figure 44-62 Update Operation with EBS Target Service

    
    Description of "Figure 44-62 Update Operation with EBS Target Service"

32. From the File menu, select Save All.