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 MAY 22, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 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

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:

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.