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 JANUARY 05, 2023

Applies to:

Oracle Data Integrator - Version and later
Oracle Data Integrator on Marketplace - Version and later
Data Integration Platform Cloud Classic - Version 17.3.5 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.


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.





To view full details, 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 a vibrant support community of peers and Oracle experts.