Add a For-Each Action to Iterate Over Individual Records

When an individual file is staged in Oracle Integration, add a second for-each action to iterate through each record in the file.

1. On the canvas, click Actions and drag and drop the For Each action after the Process_Single_File action but within the first for-each loop.

   The Create Action dialog is displayed.

2. Enter a name for the action, For_Each_InputRow.
3. Provide an optional description.
4. In the Repeating Element field, specify the element over which to iterate.

   Here, the element over which to loop is Row, which is the name you've provided for individual rows/records within a file in the previous action. Expand the Source tree to find this element. It's present under $Process_Single_File > ReadResponse > RowSet. After you've selected the element, drag to the Repeating Element field to populate the field with the element.

   
   
   Description of the illustration oic3_iterate_rows.png
   

5. In the Current Element Name field, enter an alias for the current record of the iteration, for example, InputRow. You'll use this alias for processing individual records downstream.
6. Click Save.