How to Use For Each Loop in OIC


How to Use For Each Loop in OIC

However, you can achieve similar looping behavior in OIC by using a combination of activities, such as “For Each” and “Iterate” actions, along with conditional logic. Here’s a general approach to implement a “For Each” loop-like behavior in OIC:

1. Create a List or Collection:

  • To iterate over a set of items, you should have a list or collection of those items. You can obtain this list from a REST API, a database query, or other sources, depending on your use case.

2. Iterate Over the List:

  • Use an “Iterate” or “For Each” action to iterate over the list or collection. You can find these actions in the Integration Designer palette.

3. Define Loop Activities:

  • Within the “Iterate” or “For Each” action, place the activities that you want to repeat for each item in the list. These activities can include data transformations, service invocations, or other operations.

4. Access Current Item:

  • During each iteration, you can access the current item from the list and use it within your activities. The exact way to access the current item may depend on the source of the list.

5. Exit Condition:

  • Implement an exit condition within the loop to determine when to stop iterating. This condition could be based on the number of iterations, a specific value in the list, or any other criteria relevant to your use case.

Example Scenario:

Let’s consider an example where you want to iterate over a list of orders and perform some processing for each order:

  1. Use an “Iterate” action to loop through the list of orders.
  2. Inside the “Iterate” action, place activities to process each order, such as data transformations or service invocations.
  3. Access the current order within the loop to work with its data.
  4. Define an exit condition, such as processing a specific number of orders or until a specific condition is met.
  5. When the exit condition is satisfied, the loop terminates, and you can continue with other activities in your integration.

While this approach allows you to implement looping behavior in OIC, it may not be as structured or visual as traditional programming language loops. The specific steps and actions may vary based on your integration requirements and the source of the data you’re iterating over.

Oracle Integration Cloud (OIC) Training Demo Day 1

You can find more information about Oracle Integration Cloud Service in this Oracle Docs Link



Unogeeks is the No.1 Training Institute for OIC. Anyone Disagree? Please drop in a comment

Please check our Oracle Integration Cloud Training Details here OIC Training

You can check out our other latest blogs on Oracle Integration Cloud in this OIC Blogs

💬 Follow & Connect with us:


For Training inquiries:

Call/Whatsapp: +91 73960 33555

Mail us at:

Our Website ➜

Follow us:





Leave a Reply

Your email address will not be published. Required fields are marked *