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 right side of 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, click Move to populate the field with the element.

   
   Description of the illustration each-records.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 Create.