Defining the Sequence in oracle data integrator

Defining the Sequence

To define the first step of the Package:

1. In the Package toolbar tab, select the Free Choice tool.
   
2. Select the step to set as the first one in the diagram.
   
3. Right-click and then select First Step.
   

The first step symbol appears on the step's icon.
To define the next step upon success:

1. In the Package toolbar tab, select the Next Step on Success tool.
   
2. Select one step in the diagram.
   
3. Keep the mouse button pressed and move the cursor to the icon of the step that must follow in case of a success, then release the mouse button.
   
4. Repeat this operation to link all your steps in a success path sequence. This sequence should start from the step defined as the First Step.
   

Green arrows representing the success path between the steps, with a ok labels on these arrows. In the case of an evaluate variable step, the label is true.
To define the next step upon failure:

1. In the Package toolbar tab, select the Next Step on Failure tool.
   
2. Select one step in the diagram.
   
3. Keep the mouse button pressed and move the cursor to the icon of the step that must follow in case of a failure, then release the mouse button.
   
4. Repeat this operation to link steps according to your workflow logic.
   

Red arrows representing the failure path between the steps, with a ko labels on these arrows. In the case of an evaluate variable step, the arrow is green and the label is false.
To define the end of the Package upon failure:
By default, a step that is linked to no other step after a success or failure condition will terminate the Package when this success or failure condition is met. You can set this behavior by editing the step's behavior.

1. In the Package toolbar tab, select the Free Choice tool.
   
2. Select the step to edit.
   
3. In the properties panel, select the Advanced tab.
   
4. Select End in Processing after failure or Processing after success. The links after the step disappear from the diagram.
   
5. You can optionally set a Number of attempts and an Time between attempts for the step to retry a number of times with an interval between the retries.