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

Last updated on MAY 22, 2017

Applies to:

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

Symptoms

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. Login 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



Cause

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 hundreds of Community platforms