Map Data to Fetch In-Progress Activities

One of the key tasks to your integration is defining how data is transferred, or mapped, between the source and target projects and workspaces.

Mapper in Oracle Integration enables you to map element nodes between applications by dragging source element nodes onto target element nodes. When you open the mapper for a request or response message in an integration, the data structures are automatically populated with the information pulled from the source and target connections. You can expand and load data structure levels on demand to display additional levels. There is no limit on the levels of display.

To map data to get the source project by the workspace code and project code:

1. On the integration page, select Map (runQuerys), click Actions , and then select Edit.

   On the mapper, you can create the mappings either by linking Source fields to Target fields or by entering values directly on the Target section using an expression builder.

2. In the Target section, do the following:
   1. Right-click the Name field and select Create Target Node, then in the Expression Builder window, enter InProgress Activities and click Save .
   2. Right-click the Page Size field and select Create Target Node, then in the Expression Builder window, enter 100 and click Save .
   3. Right-click the Next Table Name field and select Create Target Node, then in the Expression Builder window, enter SM_ACTIVITY and click Save .
   4. Expand Tables, right-click the Table Name field and select Create Target Node, then in the Developer Toolbar panel, enter SM_ACTIVITY and then click Save .
   5. Expand Columns under Tables, right-click and select Create Target Node, then in the Developer Toolbar panel, enter ACTIVITY_NAME and click Save .

      Previously, in the Request Wrapper, you requested the columns in the following format; therefore, you need to add ACTIVITY_CODE, PROJ_ID, and STATUS to the columns field.

      "tableName": "SM_ACTIVITY",
      			"columns": 
      			 [
      				"ACTIVITY_NAME",
      				"ACTIVITY_CODE",
      				"PROJ_ID",
      				"STATUS"
      			 ]

   6. Right-click Columns and select Repeat Node. A 2 of 2 Columns node is created and the Expression Builder window opens. In the Expression Builder, enter ACTIVITY_CODE and click Save .
   7. Right-click the 2 of 2 Columns node and select Repeat Node. A 3 of 3 Columns node is created and the Expression Builder window opens. In the Expression Builder, enter PROJ_ID and click Save .
   8. Right-click the 3 of 3 Columns node and select Repeat Node. A 4 of 4 Columns node is created and the Expression Builder window opens. In the Expression Builder, enter STATUS and click Save .
   9. Expand Condition, and then right-click Operator and select Create Target Node. In the Expression Builder, enter AND and click Save .
   10. Expand Condition, and then Conditions. Add the following mappings for the child nodes under the Conditions node:
       1. For Column Name, add STATUS.
       2. For Operator, add EQUALS.
       3. For Value1, add InProgress.
   11. Right-click Conditions, and then select Repeat Node. A 2 of 2 Conditions node is created with three child nodes, Column Name, Operator, and Value1. Add the following mappings for the child nodes under the 2 of 2 Conditions node:
       • For Column Name, add PROJ_ID.
       • For Operator, add IN.
       • For Value1, add "(SELECT PROJ_ID FROM CO_PROJECT PROJ, WS_WORKSPACE WS WHERE PROJ.WORKSPACE_ID=WS.WORKSPACE_ID AND WS.NAME='OICWS')".

         Replace WS.NAME='OICWS' with your workspace name.

3. Click Save , then click Validate.
4. Click Go Back , then click Save.