In Oracle Integration Cloud (OIC), “for each” is a looping construct used to iterate over a collection of elements, such as an array or a list, and perform a set of actions for each element in the collection. This feature is commonly used when dealing with integration flows that involve processing multiple data elements.

To use the “for each” construct in Oracle Integration Cloud, you typically follow these steps:

1. Define the Collection: First, you need to have a collection of data elements that you want to iterate over. This collection can be a list, an array, or any other data structure that supports iteration.

2. Add a “For Each” Action: Within your integration flow, you’ll find an “For Each” action in the Oracle Integration Cloud’s visual designer. Drag and drop this action to the appropriate place in your integration flow.

3. Configure the “For Each” Action: Once you’ve added the “For Each” action, you’ll need to configure it. You specify the collection you want to iterate over and define how you want to access each individual element within the collection.

4. Define Actions Inside the Loop: Within the “For Each” action, you can add actions that will be executed for each element in the collection. These actions may involve data transformation, mapping, or other integration tasks.

5. Complete the Integration Flow: After defining the actions inside the loop, continue building the rest of the integration flow as needed.

Here’s a simplified example of using the “For Each” loop in Oracle Integration Cloud:

Let’s say you have an integration flow that receives an array of employee records and you want to process each record individually to perform some tasks like sending emails or updating a database.

1. Define the Collection: The incoming data will be an array of employee records.

2. Add a “For Each” Action: Drag and drop the “For Each” action from the palette to your integration flow.

3. Configure the “For Each” Action: In the configuration of the “For Each” action, you specify the input array (collection of employees) and define a variable to represent each individual element of the array (an employee record).

4. Define Actions Inside the Loop: Within the “For Each” action, you add actions like “Send Email” or “Update Database” to process each employee record one by one.

5. Complete the Integration Flow: Continue building the integration flow with any additional actions or steps after the “For Each” loop to complete the integration process.