"ORA-02291: integrity constraint" When Clearing a Custom Picklist Field (Doc ID 1351168.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

A custom Manager Layout is created where a field is updated to define a picklist of options.

This Manager Layout is used and a specific data is assigned to this configured field based on one of the pre-defined items from the picklist. When the object is updated again and this field is updated to select the "Null" option, the following error is observed:

Cannot update the <OBJECT> record. <Field Name> must reference a valid <Field Name> record.
java.sql.BatchUpdateException: ORA-02291: integrity constraint (GLOGOWNER.FK_) violated - parent key not found

This is because the SQL is trying to update the field with a value that does not use the domain. Howeverver, it shouldn't even be using that data at all. It should be updating to NULL as they selected the "empty" selection.

Cause

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