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

Last updated on JULY 09, 2014

Applies to:

Oracle Transportation Management - Version: 6.1.0 to 6.2.2 - Release: 6.1 to 6.2
Information in this document applies to any platform.

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

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