You can set the error threshold for a session. In the Stop on Errors session property, enter the number of non-fatal errors the PowerCenter Integration Service can encounter before it stops the session.

When the PowerCenter Integration Service writes data to an Oracle E-Business Suite target, it increments the error threshold by one each time it encounters a duplicate row, orphan row, or any non-fatal error.

The following table describes behavior of the PowerCenter Integration Service based on the value of session properties:

The PowerCenter Integration Service processes data in hierarchies, which are also called batches. When the session fails, the PowerCenter Integration Service rolls back the complete hierarchy. The PowerCenter Integration Service does not commit partial hierarchy to the target, and ignores the commit type and commit interval.

If you set Stop on Errors to a value greater than 0, Orphan Row Handling and Duplicate Parent Row Handling to Error, and the sum of duplicate row count and orphan row count is less than the value of error threshold, the PowerCenter Integration Service starts writing data to the target table for the hierarchy. When the PowerCenter Integration Service starts writing the data to the target, and the sum of duplicate row count, orphan row count, and other error count exceeds the error threshold, the PowerCenter Integration Service does not write data to the target for that hierarchy and the session fails. However, the PowerCenter Integration Service writes the data to the target for all the previous hierarchies.

For example, you want to write data to the Claim Import open interface. You set the value for Stop on Errors to 5, Orphan Row Handling to Error, and Duplicate Parent Row Handling to Error. Each claim has 10 claim lines.

The PowerCenter Integration Service could not write two lines in the first claim to the target because of an orphan row error. The PowerCenter Integration Service commits the data to the target because the error threshold is less than five. The PowerCenter Integration Service encountered four orphan row errors when processing the second claim for the target. A total of six errors caused the error threshold to be reached. The PowerCenter Integration Service rolls back the complete hierarchy and the session fails.