My Oracle Support Banner

ODI Numeric Load Plan Variable does not Accept a Value Larger than 10 Digits but Session Variable does (Doc ID 2411772.1)

Last updated on FEBRUARY 26, 2019

Applies to:

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

Symptoms

NOTE: In the images below, any details including load plan and variable name represent a fictitious sample (based upon made up data used in the Oracle Demo instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

When executing an Oracle Data Integrator (ODI) load plan, a numeric load plan variable will not accept more than 10 digits as a Startup Value.  See the below screenshot for an example:
 

 

 

In contrast to the above screen shot, the numeric session variable is allowing more than 10 digits for the variable value.  See the below screenshot for an example:

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.