Load Plan Substitution APIs Associated With Load Plan Exception Handling Error Provide Information on the Load Plan Exception Package Instead of Information on the Failed Step (Doc ID 2199861.1)

Last updated on DECEMBER 22, 2016

Applies to:

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

Symptoms

Load Plan Substitution API is not providing the information about the failed step, instead it gives the package information invoked by the Load Plan Exception handling.

For example:

An ODI load plan (LP) with many steps was created and an exception handling scenario is associated to each LP step. When the steps fails, the load exception handling triggers a scenario created from a package that only contains the OdiSendMail step. The following information is added to the email body parameter of the OdiSendMail tool:

 

Note that the "Step" is the name of the exception package associated to the Load Plan Handling Exception. The "Previous Steps" and the "The current step" are without value because the package that contains the OdiSendMail has only this step and no previous steps.

 

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms