My Oracle Support Banner

Incorrect Values Assigned To Variables Used In Scenarios Generated With ODI 11.1.1.6.x (Doc ID 1507678.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 to 11.1.1.6.3 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

A Scenario correctly functions in Oracle Data Integrator (ODI) 11.1.1.5.0 or older.

The Scenario in question uses ODI Variables, properly declared and refreshed in the underlying Package steps.

After update from ODI 11.1.1.5.0 to ODI 11.1.1.6.x, and re-generation of the Scenario, the Variables used inside the Scenario will be assigned with an unexpected numeric value, and this regardless to the Variable type: Numeric, Date, Alphanumeric and Text Variables will all get a numeric value, which seems corresponding to the Variable value internal ID (I_VAL column).

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
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.