My Oracle Support Banner

Error Scale Violation Error While Importing Small Number With Decimals (Doc ID 1592724.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Agile PLM Framework - Version to [Release 9.3]
Information in this document applies to any platform.


Actual Behavior

While importing numeric attributes with small values from 0.0001, 0.0002 … 0.0009, below error occurs and the fields are not getting updated.

Scale violation: value '0' exceeds the configured maximum length of 4 digits to the right of the decimal".

Steps to Reproduce

The issue can be reproduced at will with the following steps:

  1. Log into Java client.
  2. Open Numeric01 on Items Page Two, change the Scale to 4.
  3. Create a source file and enter a value between 0.0001 and 0.0009 for the numeric attribute.
  4. Click Import under Tools & Settings and select above source file.
  5. Specify file content Items-> Item only
  6. Do required mapping
  7. Import




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.