Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3673816Jun 5 2018 — edited Jun 14 2018

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

Comments

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

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 12 2018
Added on Jun 5 2018
#business-intelligence-applications, #data-integrator, #system-management-and-integration, #variable
2 comments
398 views