My Oracle Support Banner

CASE Step (with Child WHEN and ELSE Steps) of ODI Load Plan not Evaluating Correctly (Doc ID 2437867.1)

Last updated on MAY 09, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) Load Plan has been configured as follows:

1. The first step of the Load Plan was a Case Variable with refresh enabled on this step
2. Next, there were three child steps - two WHEN statements ("When Value=YES" and "When Value=NO") and one ELSE statement

When executing this Load Plan, it was observed that ODI always executed the "When Value = YES" step - regardless of the value of the variable itself.

The Load Plan seemed not to ever execute the "When Value = YES", or the "Else" steps of the Load Plan.

A screenshot of the initial Load Plan configuration is as follows:

 

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!

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