My Oracle Support Banner

How to Force an ODI Session to Terminate with an In-Error Status (Doc ID 424240.1)

Last updated on OCTOBER 04, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


In an Oracle Data Integrator (ODI) Package, when a step terminates with an in-error status, the subsequent "On Failure" step sends an email alert to an administrator.

As a result of the successful execution of the email, the session terminates with a successfully executed status code.

The Package (or Scenario) is launched with a LOG_LEVEL of 0 and, therefore, the session execution summary does not appear in ODI Operator and, as a result, it is impossible to detect that a problem has been signaled in this application.

How is it possible then for ODI to keep track of the execution summary in such a case?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.