While trying to create an object of custom object in MUX it fails with error
"An exception occurred while trying to update an object instance OBJECT_NAME"
We tried to create the instance in the Classic UI and it works fine, it's only while creating the instance via MUX fails.
Version: 16.2.x
DB: Oracle
During investigation it was observed that though there is no default value shown on the UI, there exist a default value for the attribute in DB odf_ca_custom_attributes.
As MUX is not form based as soon as we try to create an instance of custom object, the default value set(present in the DB) passed while instance creation resulting in above error.
Why the default value for the attribute is not shown on UI whereas it is visible in DB?
The reason the default value is shown in the DB and not on UI, because the value set as default is marked inactive.
1: Set and save a new default value for this attribute. The value should be active.
2: Clear the set default value in step 1, making sure no default value is set and save.
The above will clear the previously wrongly set default value for this attribute.