Float Field Values Could Be Too Big for Field Width But No Verification in Default Behavior (Doc ID 2023914.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile Engineering Data Management - Version 6.1.2.2 and later
Information in this document applies to any platform.

Goal

It should not be possible for end users to enter values too large for a float field and then receive a db error message if the value is too large for the field:
Internal Database Error in "dmi_upd_mas_elm" (EPSQL "EPQUPD") Code -910 OCI Error: -1438 / ORA-01438: value larger than specified precision allowed for this column.

For classification lists: Even though there might be no error message it is possible for end users to insert float values that do not fit into the field according to the field definition. Anyway, there is no error message because of the database precision.
This should be verified automatically and an appropriate message should be given without additional customizing (of for example cch_chk_rng).
 

Solution

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