To create routing rules for the insert operation:
-
Double-click the Common Oracle Mediator.
The Mediator Editor is displayed.
-
In the Routing Rules section, click the Create a new Routing Rule icon.
The Target Type dialog is displayed.
-
Select Service.
The Target Services dialog is displayed.
-
Navigate to XrefCustApp > References > SBL.
-
Select SBL and click OK.
-
Next to the Transform Using field, click the Transformation icon.
The Request Transformation map dialog is displayed.
-
Select Create New Mapper File and enter
COMMON_TO_SBL_INSERT.xsl. -
Click OK.
A COMMON_TO_SBL_INSERT.xsl file is displayed.
-
Drag and drop the inp1:Customers source element to the db:InputParameters target element.
The Auto Map Preferences dialog is displayed.
-
Click OK.
The transformation is created, as shown in Figure 44-35.
Figure 44-35 COMMON_TO_SBL_INSERT.xsl Transformation
Description of "Figure 44-35 COMMON_TO_SBL_INSERT.xsl Transformation" -
From the File menu, select Save All and close the COMMON_TO_SBL_INSERT.xsl file.
-
In the Synchronous Reply section, click Browse for target service operations.
The Target Type dialog is displayed.
-
Select Service.
The Target Services dialog is displayed.
-
Navigate to XrefCustApp > References > Logger.
-
Select Write and click OK.
-
Next to the Transform Using field, click the Transformation icon.
The Reply Transformation map dialog is displayed.
-
Select Create New Mapper File and enter
SBL_TO_COMMON_INSERT.xsl. -
Select Include Request in the Reply Payload.
-
Click OK.
A SBL_TO_COMMON_INSERT.xsl file is displayed.
-
Connect the inp1:Customers source element to db:X:APP_ID.
-
Drag and drop the populateXRefRow function from the Components window to the connecting line.
-
Double-click the populateXRefRow icon.
The Edit Function-populateXRefRow dialog is displayed.
-
Enter this information in the following fields:
-
xrefLocation:
"customer.xref" -
referenceColumnName:
"Common" -
referenceValue:
$initial.Customers/inp1:Customers/inp1:Customer/inp1:Id -
columnName:
"SBL_78" -
value:
/db:OutputParameters/db:X_APP_ID -
mode:
"LINK"
-
-
Click OK.
The SBL_TO_COMMON_INSERT.xsl file appears, as shown in Figure 44-36.
Figure 44-36 SBL_TO_COMMON_INSERT.xsl Transformation
Description of "Figure 44-36 SBL_TO_COMMON_INSERT.xsl Transformation" -
From the File menu, select Save All and close the SBL_TO_COMMON_INSERT.xsl file.
-
In the Synchronous Reply section, click the Assign Values icon.
The Assign Values dialog is displayed.
-
Click Add.
The Assign Value dialog is displayed.
-
In the From section, select Expression.
-
Click the Invoke Expression Builder icon.
The Expression Builder dialog is displayed.
-
In the Expression field, enter the following expression and click OK.
concat('INSERT-',$in.OutputParameters/db:OutputParameters/db:X_APP_ID,'.xml') -
In the To section, select Property.
-
Select the jca.file.FileName property and click OK.
-
Click OK.
The insert operation section appears, as shown in Figure 44-37.
Figure 44-37 Insert Operation with SBL Target Service
Description of "Figure 44-37 Insert Operation with SBL Target Service" -
From the File menu, select Save All.
-
Repeat Step 2 through Step 34 to specify another target service named EBS and its routing rules.
Figure 44-38 shows the insert operation section with SBL and EBS target services.
Figure 44-38 Insert Operation with SBL and EBS Target Services
Description of "Figure 44-38 Insert Operation with SBL and EBS Target Services"