Unable to Update Custom Number Field With Decimal Length Configured (Doc ID 3053425.1)

Last updated on DECEMBER 04, 2024

Applies to:

Symptoms

Decimal places are not being correctly saved in Rest API call.

Create a new custom integer field with Max Length of 38 and Decimal Length as 4.
However this field does not accept the values from 0.0001- 0.0009.
But it accepts 0.0010.

This error happens only on API calls. On UI, the values are all correctly saved.


ERROR
Status 400 Bad Request
Value 0.0001 for field <custom field> exceeds the number of decimal places allowed.




STEPS

The issue can be reproduced at will with the following steps:
1. Run PATCH calls on object with passing some decimal values to the defined field

Changes

Cause

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