My Oracle Support Banner

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 FEBRUARY 06, 2019

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

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
Symptoms
Changes
Cause
Solution
References


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