Precision is Lost in CASE_MASTER.UD_NUMBER_* for Large Numbers (Doc ID 2373110.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Applications Oracle Life Sciences Argus Safety Version : 8.0.1

ArgusWeb appears to lose precision/data for the value for CASE_MASTER.UD_NUMBER_* for large numbers

e.g.

1. Store a large number with more than 7 significant digits into CASE_MASTER.UD_NUMBER_* -- for example by custom code or manual updates e.g.

2. Open and save the case in ARGUS

3. The value for UD_NUMBER_5 is changed from 1234567890123456789.123456789 to 1234567000000000000.0

  Other examples are 123456789.2 => 123456800, 14844253 => 14844250

4. Verified for UD_NUMBER_4, 5, 6, 7, 10, 12 but probably affecting all UD_NUMBER_*


There is no error, just the value is not saved correctly and precision is lost.

Cause

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