ODI Load Plan input parameter variable would not accept a numeric value larger than 10 digits

3673816

I have a Load Plan that calls a scenario with three input variables. Two are alphanumeric and one is numeric.

When I call the scenario by itself, I have no issues providing input for all three variables into the dialog box.

When I run the Load Plan, the dialog box only accepts up to 10 digits for the numeric variable. My variable value is longer than that.

Does anybody have any idea what might be causing it? Is it me not doing something right or is there an ODI limitation?

Thanks

Adrian_Popescu-Oracle

Hi,

What ODI version are you using ?

Adrian

Paula Istrate-Oracle

Hi,

I had similar problems myself with numeric variables values in ODI 11g because columns are set to have 10 digits.

See below workarounds, hope will help you:
- upgrading to ODI 12c where the precision of the columns has been increased to 19 digits
- use for the variable Text or Alphanumeric Types - not numeric.

Regards,

Paula